Tech Skills

Data Analytics & Business Intelligence

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

16,771
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,306) Articles (2991)Blog Posts (3416)Tutorials (364)Research Papers (39)News (496)
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 58m ago
Confused Between Data Science, Data Analytics, Cloud Computing, DevOps, Data Engineering, and Generative AI? Here's How to Choose the Right Career
Choosing the right technology can be overwhelming. Every day, you come across videos, blogs, and social media posts claiming that one technology is better than
Data Science with AI — Join IDSA Janakpuri Today
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1h ago
Data Science with AI — Join IDSA Janakpuri Today
Unlock your career potential with the Institute of Data Science and Analytics (IDSA), Janakpuri’s Data Science with AI Course — Delhi’s… Continue reading on Med
Data Science with AI — Enroll Now at Lonestar Academy Janakpuri
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2h ago
Data Science with AI — Enroll Now at Lonestar Academy Janakpuri
Step into the future of technology with Lonestar Academy Janakpuri’s Data Science with AI Course. Trusted by 15,000+ learners, we are… Continue reading on Mediu
Stop Writing Python Classes Until You Learn The 4 Things You Can Do To Every Piece Of Data An…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6h ago
Stop Writing Python Classes Until You Learn The 4 Things You Can Do To Every Piece Of Data An…
The data lives inside your objects. Most beginners only ever learn to put it in, and never touch it again. Continue reading on CodeToDeploy »
Why I Stopped Trying to Predict Electricity Price Spikes (And Built Something Better Instead)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6h ago
Why I Stopped Trying to Predict Electricity Price Spikes (And Built Something Better Instead)
A weekend project on nodal electricity markets, and the modeling mistake I almost made Continue reading on Medium »
Why I Stopped Trying to Predict Electricity Price Spikes (And Built Something Better Instead)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6h ago
Why I Stopped Trying to Predict Electricity Price Spikes (And Built Something Better Instead)
A weekend project on nodal electricity markets, and the modeling mistake I almost made Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 7h ago
Arbeitszeiterfassung 2026: Unternehmen auf die neue Pflicht vorbereiten
```html Stellen Sie sich vor, Sie sind ein Unternehmer und müssen sich plötzlich mit einer neuen, komplexen Regelung auseinandersetzen. Das ist die Situation, i
ORBIS
Reddit r/artificial 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 10h ago
ORBIS
The world is not lacking information. It is drowning in fragments. Markets move. Governments shift. Conflicts evolve. Supply chains fracture. Policy changes rip
The Invisible Architecture of Truth: Why the World’s Most Boring System is Our Last Defense Against…
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h ago
The Invisible Architecture of Truth: Why the World’s Most Boring System is Our Last Defense Against…
Universal Bibliographic Control isn’t just library science. Continue reading on Medium »
The Invisible Architecture of Truth: Why the World’s Most Boring System is Our Last Defense Against…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h ago
The Invisible Architecture of Truth: Why the World’s Most Boring System is Our Last Defense Against…
Universal Bibliographic Control isn’t just library science. Continue reading on Medium »
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 12h ago
SQL Window Functions: SQL’s Biggest Aha! Moment
SQL Window Functions Explained: ROW_NUMBER, RANK, DENSE_RANK, and NTILE Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 13h ago
What If Fraud Doesn’t Live in Transactions? What If It Lives Between Them?
For decades, financial crime detection has followed a remarkably simple philosophy. Every transaction is evaluated on its own. The system… Continue reading on M
5 SQL Interview Questions That Trip Up Beginners
Dev.to · Juhi Singhal 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 14h ago
5 SQL Interview Questions That Trip Up Beginners
5 SQL Interview Questions That Trip Up Beginners If you're prepping for a tech interview,...
Datenstrukturist — Warum wir einen neuen Beruf für das Informationszeitalter brauchen
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 15h ago
Datenstrukturist — Warum wir einen neuen Beruf für das Informationszeitalter brauchen
Mit der fortschreitenden Digitalisierung entstehen nicht nur neue Technologien, sondern auch neue Formen menschlicher Arbeit. Continue reading on Medium »
How Data Science is Transforming Everyday Life: From Netflix to Healthcare
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 16h ago
How Data Science is Transforming Everyday Life: From Netflix to Healthcare
Discover how the same technology that recommends your next movie also helps doctors detect diseases, banks prevent fraud, and businesses… Continue reading on Me
Why pandas_market_calendars Fails for Indian Markets (and what to use instead)
Dev.to · AION ANALYTICS 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 17h ago
Why pandas_market_calendars Fails for Indian Markets (and what to use instead)
Indian algo traders and quant developers hit the same wall: they reach for pandas_market_calendars,...
Sales Performance Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 17h ago
Sales Performance Analysis
How I Analyzed 1,000 Retail Sales Transactions in Microsoft Excel to Uncover Business Insights Continue reading on Medium »
Data Analytics: How Everyday Industries Actually Use Analytics
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 18h ago
Data Analytics: How Everyday Industries Actually Use Analytics
Have you ever sat on your couch late at night, staring at your streaming app, wondering how it managed to suggest the exact true-crime… Continue reading on Medi
7 Python Libraries That Feel Like Having a Senior Dev on Your Team
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 19h ago
7 Python Libraries That Feel Like Having a Senior Dev on Your Team
They won’t write your code for you — but they’ll save you from writing the wrong code. Continue reading on Stackademic »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 22h ago
Stop using CTEs just to filter window functions.
If you’ve ever written a Query like this just to get the top record per category: Continue reading on Medium »
How to Get Clean SEC EDGAR Filing Data (Without Getting Rate-Limited)
Dev.to · juhwandad 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 23h ago
How to Get Clean SEC EDGAR Filing Data (Without Getting Rate-Limited)
If you've ever tried to pull U.S. company filings straight from SEC EDGAR, you know the pain. The...
Tutorial Membuat Dashboard HRD di Power BI untuk Analisis Karyawan
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 23h ago
Tutorial Membuat Dashboard HRD di Power BI untuk Analisis Karyawan
Divisi Human Resources (HR) tidak lagi hanya berfokus pada administrasi karyawan. Saat ini, HR juga dituntut mampu mengolah data untuk… Continue reading on Medi
5 Fungsi Power BI dalam Supply Chain dan Operasional Perusahaan
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 23h ago
5 Fungsi Power BI dalam Supply Chain dan Operasional Perusahaan
Perusahaan menghasilkan data dalam jumlah besar setiap hari, mulai dari data persediaan barang, pengiriman, produksi, hingga penjualan… Continue reading on Medi
Beyond Dashboards: How Data Science and Predictive Analytics Are Transforming Business Decision…
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 23h ago
Beyond Dashboards: How Data Science and Predictive Analytics Are Transforming Business Decision…
For years, dashboards have been the cornerstone of business intelligence. Continue reading on Medium »
Beyond Dashboards: How Data Science and Predictive Analytics Are Transforming Business Decision…
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 23h ago
Beyond Dashboards: How Data Science and Predictive Analytics Are Transforming Business Decision…
For years, dashboards have been the cornerstone of business intelligence. Continue reading on Medium »
Beyond Dashboards: How Data Science and Predictive Analytics Are Transforming Business Decision…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 23h ago
Beyond Dashboards: How Data Science and Predictive Analytics Are Transforming Business Decision…
For years, dashboards have been the cornerstone of business intelligence. Continue reading on Medium »
The Invisible Problem in Agriculture: Why Two People Can Look at the Same Grain and See Different…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
The Invisible Problem in Agriculture: Why Two People Can Look at the Same Grain and See Different…
Imagine two experienced grain inspectors standing in front of the same sack of wheat. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Data Science vs Data Analytics: Which Career is Better?
As technology continues to evolve, Data Science and Data Analytics have become two of the most sought-after career paths in the IT… Continue reading on Medium »
From Messy Data to Clear Decisions: A SQL + Power BI Sales Analytics Project
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
From Messy Data to Clear Decisions: A SQL + Power BI Sales Analytics Project
A Medium-ready blog copy with SQL analysis and Power BI-style visual storytelling Continue reading on Medium »
From Messy Data to Clear Decisions: A SQL + Power BI Sales Analytics Project
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
From Messy Data to Clear Decisions: A SQL + Power BI Sales Analytics Project
A Medium-ready blog copy with SQL analysis and Power BI-style visual storytelling Continue reading on Medium »
Building a Pit Wall in Python: Simulating F1 Strategy Calls with FastF1
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Building a Pit Wall in Python: Simulating F1 Strategy Calls with FastF1
There is a specific kind of tension that happens on lap 21 of a Grand Prix. The tyres have gone off, the pit wall is staring at a timing… Continue reading on Me
Day 54: Using ClickHouse® Python Clients Effectively: A Practical Guide
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Day 54: Using ClickHouse® Python Clients Effectively: A Practical Guide
Using ClickHouse® Python Clients Effectively: A Practical Guide Day 54 of...
The Meta-Architecture of Interface Fracture: High-Dimensional Logical Stress and Systemic Collapse…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
The Meta-Architecture of Interface Fracture: High-Dimensional Logical Stress and Systemic Collapse…
By Supat Charoensappuech, in collaboration with Google Search AI Mode (3/7/2026) Continue reading on Medium »
Future of Data Science: From Raw Data to Smart Decisions- How AutoML Is Making Data Science More…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Future of Data Science: From Raw Data to Smart Decisions- How AutoML Is Making Data Science More…
Imagine being handed millions of rows of customer data and being asked a simple question: Continue reading on Medium »
I Open-Sourced the SEC 8-K Classifier Powering My Forensic Tool — Here's the Taxonomy
Dev.to · Jared Ablon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
I Open-Sourced the SEC 8-K Classifier Powering My Forensic Tool — Here's the Taxonomy
MIT-licensed pure-Python classifier that parses SEC 8-K bodies and surfaces buried Item 1.03/2.04/3.01/5.02 language mis-tagged under Item 8.01. Walkthrough of
Stop Optimizing Your Data Platform for Dashboards
Dev.to · ArisynData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Stop Optimizing Your Data Platform for Dashboards
For years, the success of a data platform was measured by one thing: How easily people could build...
Balancing Card Fraud Monitoring: Strategies to Optimize Risk Reduction and Operational Efficiency
Dev.to · Ksenia Rudneva 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Balancing Card Fraud Monitoring: Strategies to Optimize Risk Reduction and Operational Efficiency
Introduction: The Monitoring Dilemma in Card Fraud Prevention Excessive transaction...
Mastering Stepped Wedge Cluster Randomized Trials (SW-CRT): Design and Analysis | Lingcore SCI
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Mastering Stepped Wedge Cluster Randomized Trials (SW-CRT): Design and Analysis | Lingcore SCI
A Stepped Wedge Cluster Randomized Trial (SW-CRT) is a one-way crossover design where clusters switch from control to intervention at… Continue reading on Mediu
The Analytics Trap: Why More Data Doesn’t Mean Better Insights
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
The Analytics Trap: Why More Data Doesn’t Mean Better Insights
The organisations with the most data are not the ones making the best decisions. Continue reading on AI & Analytics Diaries »
How to Scrape Google Jobs Listings: A Complete Guide to the Google Jobs API
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
How to Scrape Google Jobs Listings: A Complete Guide to the Google Jobs API
Structured job data, apply links, and hiring signals for about a dollar per thousand listings. Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
[ZH] Virginia bans sale of geolocation data [ZH]
弗吉尼亚州禁止出售地理位置数据 TL;DR —— 2026年4月13日,弗吉尼亚州州长阿比盖尔·斯潘伯格签署了 S.B. 388 号法案,对《弗吉尼亚消费者数据保护法》(VCDPA)进行了修订,明确禁止出售地理位置数据。该立法将于2026年7月1日生效,使弗吉尼亚州与马里兰州和俄勒冈州的立场保持一致,尽管其对“出售”的
Format-preserving encryption for PII in Polars: FF3-1 vs FF1 for RUT, CPF, and DNI
Dev.to · Felipe Carvajal Brown 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Format-preserving encryption for PII in Polars: FF3-1 vs FF1 for RUT, CPF, and DNI
FF3-1 vs FF1 format-preserving encryption for RUT, CPF, and DNI in Polars: reversible PII masking, the domain minimum, and GDPR pseudonymization.
The Data Analyst Lens
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
The Data Analyst Lens
The expression “Data Analyst Lens” should not be understood simply as a reference to technical skill or the ability to work with data. It… Continue reading on M
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Why do people search the same thing in different ways?
Imagine three people who want the exact same thing. Continue reading on Medium »
Setting Up Your Data Science Toolkit: Pandas, NumPy, Matplotlib
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Setting Up Your Data Science Toolkit: Pandas, NumPy, Matplotlib
Three libraries. Endless possibilities. Here is how to get them installed and understand what each one actually does. Continue reading on Medium »
Setting Up Your Data Science Toolkit: Pandas, NumPy, Matplotlib
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Setting Up Your Data Science Toolkit: Pandas, NumPy, Matplotlib
Three libraries. Endless possibilities. Here is how to get them installed and understand what each one actually does. Continue reading on Medium »
15 SQL Tricks That Make You Look Like a Senior Data Analyst
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
15 SQL Tricks That Make You Look Like a Senior Data Analyst
Writing SQL queries that return the correct results is just the beginning. Experienced data analysts and database engineers know that… Continue reading on Stack
Storytelling with Exploratory Data Analysis (EDA) in Python
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Storytelling with Exploratory Data Analysis (EDA) in Python
In the realm of data science, the ability to tell a compelling story with data is as crucial as the technical skills to analyze it… Continue reading on Python i