Tech Skills

Data Analytics & Business Intelligence

Excel, SQL, Power BI, Tableau — turn raw data into business decisions

16,852
lessons
Skills in this topic
View full skill map →
Data Literacy
beginner
Write SELECT queries with JOIN and GROUP BY
Excel & Spreadsheets
beginner
Build a dynamic dashboard with pivot tables and slicers
SQL Analytics
intermediate
Write window functions (ROW_NUMBER, LAG, LEAD)
BI Tools
intermediate
Build an interactive dashboard from a SQL source
Python for Data
intermediate
Clean and transform a messy dataset with pandas
Data Storytelling
intermediate
Build a stakeholder dashboard with a narrative structure
ML for Analytics
advanced
Build a churn prediction model
All Reads (7,381) Articles (3042)Blog Posts (3429)Tutorials (374)Research Papers (39)News (497)
What Hiring Managers Actually Think When They See Your Data Science GitHub in 2026
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2h ago
What Hiring Managers Actually Think When They See Your Data Science GitHub in 2026
The job market didn’t close because AI took the work. It closed because the juniors forgot to grow up. Continue reading on DataDrivenInvestor »
My Favourite High-Probability Intraday Setup
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2h ago
My Favourite High-Probability Intraday Setup
Most traders keep adding more and more indicators, hoping they’ll find the perfect entry. I’ve done that too. But over time, I realised… Continue reading on Med
Normal Distribution — A Complete Guide for Beginners
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2h ago
Normal Distribution — A Complete Guide for Beginners
The normal distribution is a type of probability distribution that is bell-shaped and is symmetric about the mean. It is also referred to… Continue reading on M
The Importance of Data Profiling in the AI Era
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4h ago
The Importance of Data Profiling in the AI Era
Profiling your data is absolutely essential, regardless of how simple your data set might seem. In the age of artificial intelligence… Continue reading on Mediu
Advancing the Second Brain Model
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 8h ago
Advancing the Second Brain Model
The concept isn’t different. But what it can do has evolved. Continue reading on ILLUMINATION’S MIRROR »
The Day I Realized Watching Tutorials Wasn’t Enough
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 10h ago
The Day I Realized Watching Tutorials Wasn’t Enough
Building small projects taught me more than hours of watching videos. Continue reading on Medium »
AWS Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h ago
Enrich your datasets with business context: Migrating from legacy Topics to semantic datasets in Amazon Quick
In this post, we walk through what Dataset Enrichment is, how it differs from legacy Topics, and provide three migration scenarios with step-by-step guidance so
AWS Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h ago
Data modeling best practices for Amazon Quick Sight multi-dataset relationships
Today, we are excited to announce Multi-Dataset Relationships in Amazon Quick Sight. This new capability lets you define logical relationships between Quick Sig
AWS Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h ago
Data modeling patterns for Amazon Quick Sight multi-dataset relationships
In this post, we shift from concepts to patterns. For each schema, you’ll find a table structure, use cases, implementation steps, and sample SQL queries. We al
Build a unified semantic layer across datasets with multi-dataset Topics in Amazon Quick
AWS Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h ago
Build a unified semantic layer across datasets with multi-dataset Topics in Amazon Quick
In this post, we walk through how multi-dataset Topics work, explain how the chat agent uses defined relationships to generate cross-dataset queries, and demons
Should You Trust the Netflix Top 10? A Statistical Analysis
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 16h ago
Should You Trust the Netflix Top 10? A Statistical Analysis
Netflix’s Top 10 helps us choose faster. But does it help us choose better? Continue reading on Fanfare »
Why Aurangabad’s Digital Growth Is Boosting Data Science Jobs
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 18h ago
Why Aurangabad’s Digital Growth Is Boosting Data Science Jobs
Aurangabad is steadily embracing digital transformation, creating new opportunities for professionals with analytical and technical… Continue reading on Medium
How Data Science Is Opening New Career Opportunities in Dehradun’s Evolving Job Market
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 20h ago
How Data Science Is Opening New Career Opportunities in Dehradun’s Evolving Job Market
Dehradun is steadily emerging as a promising destination for technology-driven careers, supported by its expanding education sector, IT… Continue reading on Med
Top Data Science Training in Hyderabad with Placement Support
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 22h ago
Top Data Science Training in Hyderabad with Placement Support
The world is getting more and more dependent on data. Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 22h ago
Cookiecutter-data-science -A Python tool to structure your projects
Package version used: 2.3.0 Continue reading on Medium »
Causal Inference in Finance: Moving Beyond “What Happened?” to “What Actually Worked?”
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Causal Inference in Finance: Moving Beyond “What Happened?” to “What Actually Worked?”
Why the patterns in your dashboards might be lying to you Continue reading on Medium »
Stop Testing One Indicator at a Time. Loop Your Way to Better Trading
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Stop Testing One Indicator at a Time. Loop Your Way to Better Trading
Every trader has done it. You read about RSI on a forum, download some data, run a backtest, see a 60% win rate, and start trading it live… Continue reading on
Understanding Data Warehousing: The Complete Beginner’s Guide for Data Engineering
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Understanding Data Warehousing: The Complete Beginner’s Guide for Data Engineering
Learn what Data Warehousing is, how it works, why organizations use it Continue reading on Medium »
Python for Data Science — Sampling and Why Your Conclusions Can Be Wrong
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Python for Data Science — Sampling and Why Your Conclusions Can Be Wrong
In the previous article, we discussed probability distributions and how they help us understand the behavior of data. Continue reading on Medium »
Data Science Institute in Tilak Nagar — AI, ML & Python Training
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Data Science Institute in Tilak Nagar — AI, ML & Python Training
In today’s digital world, businesses generate huge amounts of data every day. They need skilled professionals who can analyze this data… Continue reading on Med
From Satellite Images to Smarter Air Quality Predictions: The Story Behind AIRSENSE
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
From Satellite Images to Smarter Air Quality Predictions: The Story Behind AIRSENSE
How we combined satellite imagery, meteorological data, and ground observations to estimate air quality across Mumbai Continue reading on Medium »
From Satellite Images to Smarter Air Quality Predictions: The Story Behind AIRSENSE
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
From Satellite Images to Smarter Air Quality Predictions: The Story Behind AIRSENSE
How we combined satellite imagery, meteorological data, and ground observations to estimate air quality across Mumbai Continue reading on Medium »
How to Write SQL Queries That Detect Unstable Join Filtering and Inconsistent Results
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
How to Write SQL Queries That Detect Unstable Join Filtering and Inconsistent Results
Query validation patterns that expose unstable joins and prevent inconsistent analytical outcomes Continue reading on Medium »
How to Write SQL Queries That Detect Unstable Join Filtering and Inconsistent Results
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
How to Write SQL Queries That Detect Unstable Join Filtering and Inconsistent Results
Query validation patterns that expose unstable joins and prevent inconsistent analytical outcomes Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Imagine waking up one day only to discover your account has been suspended.
THE DOWNSIDE OF CENTRALISED STORAGE PLATFORMS Continue reading on Medium »
Exploratory Data Analysis: Asking Good Questions of Your Data
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Exploratory Data Analysis: Asking Good Questions of Your Data
Before you build any model or draw any conclusion, you need to actually understand what you are looking at. This is how professionals do… Continue reading on Me
Exploratory Data Analysis: Asking Good Questions of Your Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Exploratory Data Analysis: Asking Good Questions of Your Data
Before you build any model or draw any conclusion, you need to actually understand what you are looking at. This is how professionals do… Continue reading on Me
Automating Source-to-Target Mapping
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Automating Source-to-Target Mapping
I built lineage-mcp (Agent-STTM), an MCP server + CLI that reads real SQL scripts and XML ETL exports (SSIS, Informatica PowerCenter, or a… Continue reading on
The Sharpe Ratio: The Metric That Runs the Investment Industry
Medium · Startup 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
The Sharpe Ratio: The Metric That Runs the Investment Industry
Most investors have heard of the Sharpe ratio. Fewer realize how much weight it actually carries behind the scenes, from how pension funds… Continue reading on
A 15-Year Breakout That Never Looked Back
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
A 15-Year Breakout That Never Looked Back
Testing Donchian Channels on AAPL Continue reading on Medium »
Seeing Is Believing: How to Visualize a Linear Regression Model in R
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Seeing Is Believing: How to Visualize a Linear Regression Model in R
If you’ve ever pasted the output of summary(lm(...)) into a Slack message or a slide deck, you know the problem: coefficients, standard… Continue reading on Med
InfoQ AI/ML 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
AWS Introduces Amazon S3 Annotations
AWS recently announced Amazon S3 Annotations, a feature that lets teams attach rich, searchable context such as summaries, classifications, compliance data, or
# Generating Sample Elon Musk Tweet Data Using Python for Practicing Fabric’s Medallion…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
# Generating Sample Elon Musk Tweet Data Using Python for Practicing Fabric’s Medallion…
**Subtitle:** A hands-on guide to simulating real-world Data Engineering scenarios — from Python data generation to Power BI Direct Lake… Continue reading on Me
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Looking at a spreadsheet containing hundreds of districts and dozens of demographic indicators rarely reveals meaningful patterns. Continue reading on Medium »
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Looking at a spreadsheet containing hundreds of districts and dozens of demographic indicators rarely reveals meaningful patterns. Continue reading on Medium »
9 Must-Know SQL Queries for Data Analysts and Data Scientists
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
9 Must-Know SQL Queries for Data Analysts and Data Scientists
SQL (Structured Query Language) is a fundamental tool for data professionals like data analysts and data scientists. While basic SQL… Continue reading on Medium
10 SQL Techniques for Optimizing Refresh Schedules for YTD, R12M, and Rolling Window Aggregations
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
10 SQL Techniques for Optimizing Refresh Schedules for YTD, R12M, and Rolling Window Aggregations
Scheduling strategies that optimize refresh efficiency for time-based aggregations and analytical workloads Continue reading on Medium »
10 SQL Techniques for Optimizing Refresh Schedules for YTD, R12M, and Rolling Window Aggregations
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
10 SQL Techniques for Optimizing Refresh Schedules for YTD, R12M, and Rolling Window Aggregations
Scheduling strategies that optimize refresh efficiency for time-based aggregations and analytical workloads Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
The Math of Civilizational Asset-Stripping: A Regression Model of Oligarchic Myopia
When you look at the current geopolitical and economic landscape, it is easy to assume that the ruling class has simply lost its mind. Continue reading on Mediu
Part 4: Advanced Data Engineering: Skew, Streams, and the Delta Lake Revolution
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Part 4: Advanced Data Engineering: Skew, Streams, and the Delta Lake Revolution
The advanced techniques that separate hobbyists from production experts. Continue reading on Medium »
From Churn Model to AI Assistant: How I Built an End-to-End Data Science Product
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
From Churn Model to AI Assistant: How I Built an End-to-End Data Science Product
By Deepti Dhanapala | Data Scientist | MPS Data Science, University at Buffalo Continue reading on Medium »
Is This Market Lying to Me? Part 1: The Problem and the Pipeline
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Is This Market Lying to Me? Part 1: The Problem and the Pipeline
This is the first in a six-part series on building a real-time surveillance pipeline for prediction markets. Part 1 lays out the problem… Continue reading on De
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
My OIBSIP Journey: How Oasis Infobyte Helped Me Grow as a Data Analyst
When I signed up for the Oasis Infobyte Summer Internship Program (OIBSIP) in the Data Analytics domain, I wasn’t entirely sure what to… Continue reading on Med
From Strava Data to Race Insights: Building a Tool to Understand Training and Race Performance
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
From Strava Data to Race Insights: Building a Tool to Understand Training and Race Performance
Build an app that pulls Strava data to visualize how your training impacts your race performance. Continue reading on Medium »
Population & Sample in Data Science!
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Population & Sample in Data Science!
Why tasting one spoon of soup tells you about the whole bowl, & how getting this wrong once humiliated a magazine in front of an entire… Continue reading on Med
Population & Sample in Data Science!
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Population & Sample in Data Science!
Why tasting one spoon of soup tells you about the whole bowl, & how getting this wrong once humiliated a magazine in front of an entire… Continue reading on Med
Population & Sample in Data Science!
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Population & Sample in Data Science!
Why tasting one spoon of soup tells you about the whole bowl, & how getting this wrong once humiliated a magazine in front of an entire… Continue reading on Med
Understanding Customer Loyalty Through 100,000 Starbucks Orders: An RFM Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Understanding Customer Loyalty Through 100,000 Starbucks Orders: An RFM Analysis
An RFM Analysis of Customers through Starbucks Order Patterns Continue reading on Medium »