Tech Skills

Data Analytics & Business Intelligence

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

16,772
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,307) Articles (2992)Blog Posts (3416)Tutorials (364)Research Papers (39)News (496)
DuckDB Embraces Lakehouse Vector Search; SQLite Deep Dives into xUpdate & VFS Builds
Dev.to · soy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
DuckDB Embraces Lakehouse Vector Search; SQLite Deep Dives into xUpdate & VFS Builds
DuckDB Embraces Lakehouse Vector Search; SQLite Deep Dives into xUpdate & VFS Builds ...
The Line of Best Fit Is a Lie — It’s Actually a Choice
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Line of Best Fit Is a Lie — It’s Actually a Choice
And understanding that choice changes how you think about every model that comes after it. Continue reading on Medium »
The Line of Best Fit Is a Lie — It’s Actually a Choice
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Line of Best Fit Is a Lie — It’s Actually a Choice
And understanding that choice changes how you think about every model that comes after it. Continue reading on Medium »
Backtesting Without Cheating: Bitemporal Joins, As-Of Correctness, and the Sahm Rule
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Backtesting Without Cheating: Bitemporal Joins, As-Of Correctness, and the Sahm Rule
Most backtest had access to a number it shouldn’t have known. Here’s how that look-ahead bias gets in, how to measure it, and how to build… Continue reading on
Backtesting Without Cheating: Bitemporal Joins, As-Of Correctness, and the Sahm Rule
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Backtesting Without Cheating: Bitemporal Joins, As-Of Correctness, and the Sahm Rule
Most backtest had access to a number it shouldn’t have known. Here’s how that look-ahead bias gets in, how to measure it, and how to build… Continue reading on
7 Python Libraries I Wish I Had Found Years Earlier
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
7 Python Libraries I Wish I Had Found Years Earlier
They would’ve saved me hundreds of hours. Continue reading on Stackademic »
Pandas and Data Visualization Using Matplotlib and Seaborn
Dev.to · Joseous Ng'ash 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Pandas and Data Visualization Using Matplotlib and Seaborn
New chapter in Learning data analytics and data science. The focus now is on Pandas as a Python...
The Data Engineer’s Job Is Changing Faster Than Anyone Admits — Here’s What’s Actually Coming in…
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Data Engineer’s Job Is Changing Faster Than Anyone Admits — Here’s What’s Actually Coming in…
The manual work isn’t just getting easier. It’s getting automated away. Here’s the honest map of what survives — and what doesn’t. Continue reading on Medium »
Python for Data Science — Line Charts, Bar Charts, and Histograms
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Line Charts, Bar Charts, and Histograms
In the previous article, we introduced Matplotlib and learned how to create basic visualizations in Python. Continue reading on Medium »
Python for Data Science — Line Charts, Bar Charts, and Histograms
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Line Charts, Bar Charts, and Histograms
In the previous article, we introduced Matplotlib and learned how to create basic visualizations in Python. Continue reading on Medium »
I Built Full Source-Attributed Analytics for Indie Developers — No Third-Party Tools
Dev.to · Dan Oluwatunmibi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Built Full Source-Attributed Analytics for Indie Developers — No Third-Party Tools
When I started building Rubies Unleashed — an open publishing platform for indie games, apps, and...
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Pandas vs Polars vs DuckDB 2026: I Processed 1 Million Rows in FastAPI (Pandas Crashed My RAM…
I killed a production server with a CSV file. Continue reading on Medium »
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Pandas vs Polars vs DuckDB 2026: I Processed 1 Million Rows in FastAPI (Pandas Crashed My RAM…
I killed a production server with a CSV file. Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Pandas vs Polars vs DuckDB 2026: I Processed 1 Million Rows in FastAPI (Pandas Crashed My RAM…
I killed a production server with a CSV file. Continue reading on Medium »
The Day I Realized Web Scraping Is One of Python’s Most Underrated Skills
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Day I Realized Web Scraping Is One of Python’s Most Underrated Skills
For a long time, I completely underestimated web scraping. Continue reading on Stackademic »
The Day I Realized Web Scraping Is One of Python’s Most Underrated Skills
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Day I Realized Web Scraping Is One of Python’s Most Underrated Skills
For a long time, I completely underestimated web scraping. Continue reading on Stackademic »
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
7 Crucial Barriers Between Data Teams and Self-Healing Data Architecture
What data teams need to build with AI to make self-healing data architecture a practical reality The post 7 Crucial Barriers Between Data Teams and Self-Healing
Reddit r/MachineLearning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
TSAuditor: A time-series auditing framework [P]
This happened a few months ago when I was working on an analysis project that dealt with time-series data. The dataset was large (10 years of data). I was using
Product Mix Emerged as the Primary Driver of Profitability
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Product Mix Emerged as the Primary Driver of Profitability
The bicycle retail industry operates within a highly competitive environment where profitability is influenced not only by sales volume… Continue reading on Med
I Built an Interactive 3D Universe Map Connecting the Yin-Yang Diagram to 11 Scientific Fields
Dev.to · wenyumoney 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Built an Interactive 3D Universe Map Connecting the Yin-Yang Diagram to 11 Scientific Fields
I built an unusual educational website: a bilingual (EN/ZH) platform that maps the ancient Taiji...
How Data Professionals Use AI — and What Really Matters
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Data Professionals Use AI — and What Really Matters
I’ve been a data engineer for over 20 years. I started when “big data” meant a few terabytes and tuning queries by hand was half the job… Continue reading on Me
DiffusionGemma, Column-Level Data Lineage Engine, LLMs: The Hard Parts | Issue 93
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
DiffusionGemma, Column-Level Data Lineage Engine, LLMs: The Hard Parts | Issue 93
A weekly curated update on data science and engineering topics and resources. Continue reading on Medium »
Python vs R for data analysis — from a statistician’s perspective
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python vs R for data analysis — from a statistician’s perspective
I trained as a statistician before I became a data scientist. That order matters more than people think when choosing between these two… Continue reading on Med
Python vs R for data analysis — from a statistician’s perspective
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python vs R for data analysis — from a statistician’s perspective
I trained as a statistician before I became a data scientist. That order matters more than people think when choosing between these two… Continue reading on Med
How Data Science Interviews Are Changing in the GenAI Era
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Data Science Interviews Are Changing in the GenAI Era
The skills companies value today are very different from what they looked for just a few years ago. Continue reading on The Startup »
I stopped writing throwaway scripts for messy CSVs and just use SQL now
Dev.to · Herbert Tzekian 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I stopped writing throwaway scripts for messy CSVs and just use SQL now
Someone sends you a CSV. Then a folder of CSVs. Then a CSV that's actually tab-separated but named...
Beyond the 80% Grind: Automated ETL and the Instant Synthetic Data Revolution
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Beyond the 80% Grind: Automated ETL and the Instant Synthetic Data Revolution
Is Your Modern Data Stack Still Running on Manual Labor? Continue reading on Medium »
Day 27 of 100 Days of ClickHouse® - Optimizing ClickHouse® Queries for Faster Execution
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Day 27 of 100 Days of ClickHouse® - Optimizing ClickHouse® Queries for Faster Execution
Introduction As datasets grow larger and analytical workloads become more demanding, query...
From SQL Beginner to Intermediate: My SQL Learning Journey (Part 2)
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
From SQL Beginner to Intermediate: My SQL Learning Journey (Part 2)
When I decided to transition towards Data Engineering, I knew SQL would be the foundation of everything. Continue reading on Medium »
Master Data Analytics with AI at IDSA Janakpuri
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Master Data Analytics with AI at IDSA Janakpuri
Step into the future of analytics with the Data Analytics with AI Course at the Institute of Data Science and Analytics, Janakpuri… Continue reading on Medium »
AI Is Changing ETL Pipelines. But Not in the Way Most People Think!
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
AI Is Changing ETL Pipelines. But Not in the Way Most People Think!
What every Data Engineer needs to understand before AI becomes a standard part of every Data platform! Continue reading on Medium »
Your Hard Drive should not be the Graveyard of your Research Projects
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Your Hard Drive should not be the Graveyard of your Research Projects
Or why we built unpublished.pub Continue reading on Medium »
Data Analyst Salary in Kerala 2026: Skills That Increase Your Pay
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Analyst Salary in Kerala 2026: Skills That Increase Your Pay
Data is becoming one of the most valuable assets for businesses. From startups in Kochi to multinational companies in Thiruvananthapuram… Continue reading on Me
SalesIQ: Building a Full-Stack Sales Analytics Dashboard with AI — A Team’s Journey
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
SalesIQ: Building a Full-Stack Sales Analytics Dashboard with AI — A Team’s Journey
When our team sat down to plan our internship project, we knew we didn’t want to build “just another CRUD app.” We wanted something that… Continue reading on Me
How Data Moves: A Guide to Pipeline and Warehouse Patterns
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How Data Moves: A Guide to Pipeline and Warehouse Patterns
From transactional systems to trusted analytical data products Continue reading on Level Up Coding »
Why Statistics is Important in Data Science
Dev.to · jayson kibet 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Statistics is Important in Data Science
Introduction Ask ten people what data science is and you'll hear things like...
The Readers Are Leaving Wikipedia. The Money Isn’t.
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Readers Are Leaving Wikipedia. The Money Isn’t.
Traffic to the world’s reference library has fallen by about a quarter in three years. The cause is stranger than the headlines suggest… Continue reading on Reg
Kesalahan yang Sering Dilakukan Pemula saat Belajar SQL dan Power BI
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Kesalahan yang Sering Dilakukan Pemula saat Belajar SQL dan Power BI
Di era data saat ini, SQL dan Power BI menjadi dua keterampilan yang paling banyak dicari dalam bidang analisis data. SQL digunakan untuk… Continue reading on M
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Brutal Truth About Becoming a Data Scientist in 2026 (And Why Python is Your Golden Ticket)
Let’s be real for a second. Aajkal har doosra insaan AI, machine learning, aur data science ki baat kar raha hai. It is easy to get… Continue reading on Medium
Chatting with your Data: Conversational Analytics in BigQuery
Dev.to · Aryan Irani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Chatting with your Data: Conversational Analytics in BigQuery
For the last decade, the workflow for Business Intelligence hasn't changed much: A business...
How To Always Land Data Science Interviews
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How To Always Land Data Science Interviews
Why you are not getting any callbacks Continue reading on Data Science Collective »
Snowflake’s one-page SEC demo treats structured filings as text
Medium · RAG 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Snowflake’s one-page SEC demo treats structured filings as text
Reading the Cortex one-pager, and why this is the textbook example of treating structured data as text. Continue reading on Data Science Collective »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why I Chose Data Science Even Though I Started With Zero Experience
A year ago, if someone had asked me what Data Science was, I probably would have given a vague answer involving artificial intelligence… Continue reading on Med
The Hidden Cost of Data Bias: Why Your Analysis Might Be More Wrong Than You Think
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Hidden Cost of Data Bias: Why Your Analysis Might Be More Wrong Than You Think
We live in the age of data. Every day, companies make millions of decisions backed by analysis, algorithms, and insights derived from vast… Continue reading on
The Hidden Order of the Landscape: Adding Uncertainty to MapServer Interpolation
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Hidden Order of the Landscape: Adding Uncertainty to MapServer Interpolation
What working on interpolation in MapServer taught me about maps, uncertainty, and the mathematics of the unseen. Continue reading on Medium »
Understanding Data Structures by Building a Contact Book in Python
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Understanding Data Structures by Building a Contact Book in Python
Data structures sound scary. They are not. Let this simple project show you exactly what they are and why they matter. Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Analytics vs Data Science vs Business Intelligence
Data Analytics vs Data Science vs Business Intelligence: Understanding the Differences and Choosing the Right Career Path Data is everywhere. Every online purch
What I Wish I Knew Before Becoming a Data Scientist
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
What I Wish I Knew Before Becoming a Data Scientist
When I first entered Data Science, I thought the profession was primarily about models. Continue reading on Medium »