Tech Skills

Data Analytics & Business Intelligence

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

17,219
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,743) Articles (3283)Blog Posts (3520)Tutorials (399)Research Papers (42)News (499)
Data Engineering Described
Dev.to · John Otienoh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Data Engineering Described
Source: Fundamentals of Data Engineering by Joe Reis and Matt Housley, published by O'Reilly...
Top Monte Carlo Data Observability Alternatives in 2026
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Top Monte Carlo Data Observability Alternatives in 2026
How to tackle Data Observability outside of Monte Carlo in 2026 Continue reading on Medium »
The Strangest Data Science News of 2024 (That No One Is Talking About)
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
The Strangest Data Science News of 2024 (That No One Is Talking About)
Three counterintuitive discoveries that will change how you think about models, data, and scaling Continue reading on Medium »
The Strangest Data Science News of 2024 (That No One Is Talking About)
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
The Strangest Data Science News of 2024 (That No One Is Talking About)
Three counterintuitive discoveries that will change how you think about models, data, and scaling Continue reading on Medium »
Your Database Has Two Jobs.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Your Database Has Two Jobs.
A plain-language breakdown of data modeling, OLAP, and OLTP and why mixing them up will cost you. Continue reading on Medium »
Your JSON-to-Excel Converter Is Probably Corrupting Your Data. Here's the 30-Second Test
Dev.to · Ankur Soni 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Your JSON-to-Excel Converter Is Probably Corrupting Your Data. Here's the 30-Second Test
Last week a JSON-to-Excel tool quietly changed my data and I almost shipped it to a client. I pasted...
AWR (Automatic Workload Repository) — Oracle Performance Monitoring Tool | 002
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
AWR (Automatic Workload Repository) — Oracle Performance Monitoring Tool | 002
AWR (Automatic Workload Repository) — Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Why 90% of Data Science Beginners Fail in 2026 (And How to Actually Get Hired)
Industry realities, high-paying skills, aur sahi roadmap jo har fresher ko pata hona chahiye. Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Why 90% of Data Science Beginners Fail in 2026 (And How to Actually Get Hired)
Industry realities, high-paying skills, aur sahi roadmap jo har fresher ko pata hona chahiye. Continue reading on Medium »
Excel 101
Dev.to · Martin Mwenda 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Excel 101
Microsoft Excel is far more than just a grid of rows and columns, it is the fundamental language of...
How Excel Is Used in Real-World Data Analysis By a Curious Learner | Data & Analytics Series
Dev.to · grace 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
How Excel Is Used in Real-World Data Analysis By a Curious Learner | Data & Analytics Series
More Than Just a Spreadsheet When most people hear "Excel," they picture a grid of cells filled with...
Querying Video Analytics Parquet Exports With DuckDB Instead of a Warehouse
Dev.to · ahmet gedik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Querying Video Analytics Parquet Exports With DuckDB Instead of a Warehouse
How we replaced notebooks and a warehouse with DuckDB for ad-hoc video watch-time analytics on parti
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Best Data Science Course in Almora — Advanced Training
In today’s digital world, businesses kind of rely heavily on data, to make smarter decisions and so on. From healthcare and finance, all… Continue reading on Me
Why Time Zone Offsets vs.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Why Time Zone Offsets vs.
Daylight saving rules make time zone regions outperform fixed offsets Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
MCP is “dead” — or is it?
Today, I want to talk about how I’m saving anywhere from like 60% to 90% of my tokens for tool calling. And the solution is actually dead… Continue reading on M
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Why Smart Students Are Learning Data Engineering Before They Graduate
A few years ago, getting a degree was enough to start a career. Continue reading on Medium »
Most Companies Do Not Need Another Chatbot
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Most Companies Do Not Need Another Chatbot
They need their documents converted into decision-ready intelligence. Continue reading on Medium »
The Best Money Making Intraday Trading Strategy
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
The Best Money Making Intraday Trading Strategy
Most traders spend their time looking for the perfect entry. Continue reading on Medium »
“Proper Principles Provide Practical Practice & Proficiency”
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
“Proper Principles Provide Practical Practice & Proficiency”
5-P’s Without Needing To Harm Anyone Continue reading on Medium »
10 SQL Techniques for Reducing Unnecessary Full Table Scans and Query Execution Time
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
10 SQL Techniques for Reducing Unnecessary Full Table Scans and Query Execution Time
Optimizer-focused strategies that eliminate costly scans, improve index usage, and dramatically reduce query latency at scale Continue reading on Medium »
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
What is the biggest challenge you face in data science projects?
Is it data quality, stakeholder expectations, model deployment, business understanding, or something else? submitted by /u/Effective_Ocelot_445 [link] <a href="
Project Silica and the 10,000-Year Question: How We're Preserving Humanity's Data
Dev.to · Autonix Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Project Silica and the 10,000-Year Question: How We're Preserving Humanity's Data
Here is an uncomfortable fact about the digital age: it may leave behind less durable evidence of...
Claude Code Hooks: When CLAUDE.md Stops Being Enough
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Claude Code Hooks: When CLAUDE.md Stops Being Enough
It doesn’t take long for a .claude/CLAUDE.md to grow unwieldy. Continue reading on Data Science Collective »
Import JSON from an API in Google Sheets
Dev.to · bulldo.gs 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Import JSON from an API in Google Sheets
How to fetch JSON from any REST API in Google Sheets using Apps Script — parse the response, map objects to rows, and write a rectangular 2D array wit
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Exploring the Cosmos: A Guide to NASA's Eyes on Exoplanets Tutorial
Exploring the Cosmos: A Guide to NASA's Eyes on Exoplanets Tutorial As we continue to push the boundaries of space exploration, the search for exoplanets has be
External Validity Threats: Why Your A/B Test Results Might Not Generalize
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
External Validity Threats: Why Your A/B Test Results Might Not Generalize
Discover the external validity threats that can invalidate your A/B test results, from seasonality and sample pollution to the flicker… Continue reading on Medi
Goal Analytics, Fully Built: Data Pipeline, Six Models, and a Real Backtest
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Goal Analytics, Fully Built: Data Pipeline, Six Models, and a Real Backtest
Module 1 is done. Here’s everything that’s actually in the system now, how it’s validated, and what’s next. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
The Golden Ball Deserves a Formula: A Data-Driven Take on Football’s Most Debated Award
By Sunday Ikpe and Femi Akinmade Continue reading on Medium »
Spark Joy: How I Cut 100M Record Processing from 4.5 Minutes to 76 Seconds
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Spark Joy: How I Cut 100M Record Processing from 4.5 Minutes to 76 Seconds
My first professional love was data. Anything to do with data. I found it so interesting that everything in any system ever boiled down to… Continue reading on
Creating a Power BI Dashboard for Nigerian Retail Sales Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Creating a Power BI Dashboard for Nigerian Retail Sales Analysis
This project is based on a Nigerian Retail Sales dataset that contains a large amount of raw data, which on its own does not tell a clear… Continue reading on M
So, You Need a Data Management and Sharing Plan..
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
So, You Need a Data Management and Sharing Plan..
The NIH continues to tweek the requirements for the Data Management and Sharing Plan, here’s what it looks like in 2026 Continue reading on MetaScientific »
I've built a open source PDF-To-Excel-Converter
Dev.to · Tsvetan Gerginov 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
I've built a open source PDF-To-Excel-Converter
Github Repository Hi community, I've built a open source PDF to Excel Converter and let me tell you...
Learning Progress Pt.32
Dev.to · Muhamed Maxhuni 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Learning Progress Pt.32
Daily learning part thirty-two. I started today at 17:00. I started with SQL and completed 10...
Creating a Power BI Dashboard for Nigerian Retail Sales Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Creating a Power BI Dashboard for Nigerian Retail Sales Analysis
Using Power BI to uncover sales trends, regional performance, and profitability inisight from a Nigerian Retail Dataset. Continue reading on Medium »
What Really Makes Cars Pollute? A Data Science Deep Dive into CO₂ Emissions
Towards AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
What Really Makes Cars Pollute? A Data Science Deep Dive into CO₂ Emissions
Author(s): Sai Bhargav Rallapalli Originally published on Towards AI. How I built a 98.8% accurate prediction model — and discovered that the “cleanest” fuel is
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
There’s a particular kind of frustration that comes from working with data in 2026. You have a CSV. Maybe it’s sales records, maybe it’s… Continue reading on Me
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
There’s a particular kind of frustration that comes from working with data in 2026. You have a CSV. Maybe it’s sales records, maybe it’s… Continue reading on Me
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
There’s a particular kind of frustration that comes from working with data in 2026. You have a CSV. Maybe it’s sales records, maybe it’s… Continue reading on Me
20% of Customers Generate 43% of Revenue. Here’s What the Data Says
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
20% of Customers Generate 43% of Revenue. Here’s What the Data Says
I ran an RFM analysis on 17,000 e-commerce transactions from a Turkish online retailer. The results were eye-opening. Continue reading on Medium »
Modelo de Stackelberg: Quando Quem Move Primeiro Vence
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Modelo de Stackelberg: Quando Quem Move Primeiro Vence
Série: Modelos Matemáticos para Data-Driven Decision Making — Step 07 / 12 Continue reading on Medium »
Databricks Connect: Run Spark Code from Your Local IDE on a Remote Cluster
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Databricks Connect: Run Spark Code from Your Local IDE on a Remote Cluster
If you’ve ever worked with Spark, you know the usual workflow: write code, upload it to a notebook, run it on the cluster, debug through… Continue reading on Me
Introducing PRISM: A New NBA Impact Metric
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Introducing PRISM: A New NBA Impact Metric
Blending regularized adjusted plus-minus with possession-level box production. Continue reading on Medium »
One wallet made 58.9% of Base's 167,725 gasless USDC payments in the last 19 hours
Dev.to · LogicNodes 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
One wallet made 58.9% of Base's 167,725 gasless USDC payments in the last 19 hours
All numbers below are chain-derived via eth_getLogs against public RPCs. Nothing is self-reported,...
Optimizing Specific Power Consumption (kWh/T) in an Open Circuit Cement Ball Mill Using Data &…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Optimizing Specific Power Consumption (kWh/T) in an Open Circuit Cement Ball Mill Using Data &…
Grinding consumes 30–40% of cement plant electricity. Learn how to cut kWh/T by 8–15% using Python data analytics. Free code + GitHub repo… Continue reading on
Apache Iceberg: A Modern Data Architecture for Scalable Analytics
Dev.to · Prithvi S 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Apache Iceberg: A Modern Data Architecture for Scalable Analytics
Explore Apache Iceberg metadata hierarchy, schema evolution, hidden partitioning, and concurrency model.
The Death of the “Quick SQL” Ticket: Why Genie + Teams is a Data Engineer’s Best Friend
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
The Death of the “Quick SQL” Ticket: Why Genie + Teams is a Data Engineer’s Best Friend
How combining Databricks AI/BI Genie with Microsoft Teams transforms data teams from reactive report pullers into scalable semantic… Continue reading on Medium
My Data Science Internship Journey at Oasis Infobyte (OIBSIP)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
My Data Science Internship Journey at Oasis Infobyte (OIBSIP)
Learning Through Experience Continue reading on Medium »
Apache SeaTunnel Monthly Engineering Digest (May 2026): 87 PRs, Stronger Connectors, Smarter…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Apache SeaTunnel Monthly Engineering Digest (May 2026): 87 PRs, Stronger Connectors, Smarter…
Hello SeaTunnel community! Continue reading on Medium »