Tech Skills

Data Analytics & Business Intelligence

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

12,529
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 (3,068) Articles (1103)Blog Posts (1716)Tutorials (238)Research Papers (2)News (9)
Why Statistics is the Invisible Backbone of Data Science
Dev.to · Venus-Kennedy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Statistics is the Invisible Backbone of Data Science
INTRODUCTION In the hype-fueled world of tech, data science is often painted as a futuristic...
17 million Polymarket price snapshots, collected on one Mac for $0/month
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
17 million Polymarket price snapshots, collected on one Mac for $0/month
Most prediction-market datasets you find online are a one-time dump someone scraped, posted, and...
Web Scraping with APIs: A Complete Tutorial with Real Examples
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Web Scraping with APIs: A Complete Tutorial with Real Examples
A Hands-On Python Guide to Extracting Clean Data Efficiently Continue reading on Data Engineer Things »
The Month-End Close is Broken: How Modern Accountants Are Automating Financial Document Extraction
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Month-End Close is Broken: How Modern Accountants Are Automating Financial Document Extraction
Why Are Highly Trained CPAs Still Doing Manual Data Entry? Continue reading on Medium »
Connect Excel to a Database with Tens of Millions of Rows?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Connect Excel to a Database with Tens of Millions of Rows?
How do you connect Excel to a databases with tens of millions of rows.. and GBs of data? Continue reading on Medium »
Du Tableau HTML aux Instructions SQL INSERT en Un Clic
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Du Tableau HTML aux Instructions SQL INSERT en Un Clic
Vous avez trouvé des données sur un site web. Vous en avez besoin dans votre base de données. Le...
Host Nation Advantage: Do USA, Canada, and Mexico Get a Statistical Boost?
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Host Nation Advantage: Do USA, Canada, and Mexico Get a Statistical Boost?
Here's a stat that'll surprise you: since 1930, host nations win the World Cup 26% of the time—nearly...
Python for Data Science — Boxplots and Outlier Detection
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Boxplots and Outlier Detection
In the previous article, we used scatter plots to explore relationships between variables. Continue reading on Medium »
Python for Data Science — Scatter Plots and Relationships Between Variables
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Scatter Plots and Relationships Between Variables
In the previous article, we learned about three fundamental chart types: Continue reading on Medium »
CSV explained — the quirks that quietly corrupt your data (and how to avoid them)
Dev.to · William Andrews 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
CSV explained — the quirks that quietly corrupt your data (and how to avoid them)
CSV looks like the simplest file format there is. It isn't. A practical guide to delimiters, quoting, encoding, the Excel traps that destroy data, and how to pa
ARIMA & SARIMA: Model Statistik Klasik untuk Deret Waktu
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
ARIMA & SARIMA: Model Statistik Klasik untuk Deret Waktu
Membongkar tiga huruf ARIMA, lalu menambahkan “indra musim” lewat SARIMA, lengkap dengan perhitungan nyata untuk menentukan p, d, q. Continue reading on Medium
Mendelian Randomization in Clinical Epidemiology: Overcoming Confounding via Genetic Instruments
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Mendelian Randomization in Clinical Epidemiology: Overcoming Confounding via Genetic Instruments
In observational epidemiology, establishing a causal relationship between a risk factor (exposure) and a clinical outcome is notoriously… Continue reading on Me
My Drone Amputated My Fingerprint, and I Refused to Leave the Data Unanalyzed
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
My Drone Amputated My Fingerprint, and I Refused to Leave the Data Unanalyzed
TL;DR: My FPV drone injured me. Instead of guessing what happened, I pulled the Blackbox flight data, cracked it open with Python, and let… Continue reading on
My Drone Amputated My Fingerprint, and I Refused to Leave the Data Unanalyzed
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
My Drone Amputated My Fingerprint, and I Refused to Leave the Data Unanalyzed
TL;DR: My FPV drone injured me. Instead of guessing what happened, I pulled the Blackbox flight data, cracked it open with Python, and let… Continue reading on
Why Statistics is the Real Backbone of Data Science
Dev.to · Menje 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Statistics is the Real Backbone of Data Science
The explosive rise of data science has made one thing clear: everyone wants to build the next...
Monaco’s RCI registry: what you actually get from the data
Dev.to · OpenRegistry 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Monaco’s RCI registry: what you actually get from the data
Monaco lists roughly 14,000 active entities in the Registre du Commerce et de l’Industrie (RCI). The...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
3. Bölüm – İnsan Radarı
İnsanı tanımayan, hiçbir sistemi yönetemez. Continue reading on Medium »
Why I built a CSV-first rental profit tracker — no Plaid, no bank login
Dev.to · Lawrence Locke 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why I built a CSV-first rental profit tracker — no Plaid, no bank login
Most short-term-rental finance tools start the same way: connect your bank through Plaid, link your...
How I Built an Excel Dashboard With AI as My Planning Partner
Medium · ChatGPT 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How I Built an Excel Dashboard With AI as My Planning Partner
AI did not magically create a perfect dashboard, but it helped me build a clearer one because it forced me to define the story first. Continue reading on The Fi
Why Your Data Pipeline Works Perfectly… Until Real Users Arrive
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Your Data Pipeline Works Perfectly… Until Real Users Arrive
The day your clean architecture met reality Continue reading on Medium »
Why Your Data Pipeline Works Perfectly… Until Real Users Arrive
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Your Data Pipeline Works Perfectly… Until Real Users Arrive
The day your clean architecture met reality Continue reading on Medium »
Data Science vs Artificial Intelligence: Understanding the Differences, Similarities, and…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Science vs Artificial Intelligence: Understanding the Differences, Similarities, and…
Learn how Data Science and Artificial Intelligence differ in skills, responsibilities, technologies, and career opportunities Continue reading on Medium »
They Weren’t Unhappy. They Were Underpaid.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
They Weren’t Unhappy. They Were Underpaid.
How analyzing 1,470 HR records uncovered a $13.9M retention problem and three assumptions that turned out to be completely wrong. Continue reading on Medium »
Understanding the Iris Dataset Through Exploratory Data Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Understanding the Iris Dataset Through Exploratory Data Analysis
Exploratory Data Analysis on the Iris Dataset Continue reading on Medium »
Citation Analysis at Scale: Track Research Trends with Semantic Scholar Data
Dev.to · NexGenData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Citation Analysis at Scale: Track Research Trends with Semantic Scholar Data
The research landscape moves faster than any single researcher can keep up with. You might spend...
Fitness Tracker Accuracy Testing Methodology: A Comprehensive Guide
Dev.to · Sam Chen 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Fitness Tracker Accuracy Testing Methodology: A Comprehensive Guide
Introduction Fitness trackers have become ubiquitous in our daily lives, promising to...
Building a Transparent Digital SAT Score Estimator Without Pretending It Is Exact
Dev.to · 陈科林 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building a Transparent Digital SAT Score Estimator Without Pretending It Is Exact
Score calculators look simple from the outside: enter a number of correct answers, apply a conversion...
Por que o Value at Risk (VaR) Falha Diante de Eventos Extremos?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Por que o Value at Risk (VaR) Falha Diante de Eventos Extremos?
Introdução Continue reading on Medium »
Sharp Money vs Public Money: What Betting Line Movement Data Reveals
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Sharp Money vs Public Money: What Betting Line Movement Data Reveals
The Hidden Story in Every Line Change Every second, across dozens of sportsbooks, betting...
Financial crises rarely appear out of nowhere.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Financial crises rarely appear out of nowhere.
Whether it’s 1929, 2008, or 2020, the underlying mechanics often follow familiar patterns: Continue reading on Medium »
Databox MCP Setup Notes: Giving AI Access to Analytics Without Pretending the Metrics Are Magic
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Databox MCP Setup Notes: Giving AI Access to Analytics Without Pretending the Metrics Are Magic
The hard part of AI analytics is usually not the chat interface. It is the setup friction around permissions, metric definitions, stale… Continue reading on Med
Working in BI in Japan vs Europe: A Data MVP’s Perspective with Bernat Agulló Roselló (MVP)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Working in BI in Japan vs Europe: A Data MVP’s Perspective with Bernat Agulló Roselló (MVP)
In the world of data analytics, the journey from being an Excel power user to becoming a Microsoft Most Valuable Professional (MVP) is a… Continue reading on Me
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 »
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
Beyond the 80% Grind: Automated ETL and the Instant Synthetic Data Revolution
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w 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 1w 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 1w 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 »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w 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
Customer-Facing Analytics: What Your SaaS App Is Missing (And How to Add It)
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Customer-Facing Analytics: What Your SaaS App Is Missing (And How to Add It)
Most SaaS apps collect tons of data but give customers almost nothing back. Here's what customer-facing analytics looks like in practice, and how to build it ri
Two Identical Claims. One Got Paid. The Difference Was a Single Form
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Two Identical Claims. One Got Paid. The Difference Was a Single Form
Two claims leave the billing system looking identical. Same patient, same procedure, same payer. One gets paid. The other gets denied, and… Continue reading on
Who Owns African Data?
Medium · Startup 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Who Owns African Data?
A Plain-English Guide to Data Sovereignty on the Continent. Continue reading on Medium »
How to Convert PDF and Excel Invoices to CSV for Faster Data Processing
Dev.to · kevincarroll 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Convert PDF and Excel Invoices to CSV for Faster Data Processing
Manually converting invoice data from PDF or Excel files into CSV format is one of the most...