Tech Skills

Data Analytics & Business Intelligence

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

16,768
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,303) Articles (2989)Blog Posts (3416)Tutorials (363)Research Papers (39)News (496)
What 295,732 IPL balls reveal: chase to win, and the death overs are a different game
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What 295,732 IPL balls reveal: chase to win, and the death overs are a different game
I cleaned every IPL delivery from 2008 to 2026 into one tidy ball-by-ball table — 295,732 rows — and...
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
How to Build a Credit Scoring Grid From a Logistic Regression Model?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Build a Credit Scoring Grid From a Logistic Regression Model?
Turning model coefficients into a 0–1000 score, with risk classes and stability checks Continue reading on Medium »
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...
Getting Started with Exploratory Data Analysis (EDA) in Python: A Beginner’s Practical Guide
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Getting Started with Exploratory Data Analysis (EDA) in Python: A Beginner’s Practical Guide
When I first started working with data, I was eager to jump straight into machine learning models and predictive analytics. Like many… Continue reading on Mediu
Getting Started with Exploratory Data Analysis (EDA) in Python: A Beginner’s Practical Guide
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Getting Started with Exploratory Data Analysis (EDA) in Python: A Beginner’s Practical Guide
When I first started working with data, I was eager to jump straight into machine learning models and predictive analytics. Like many… Continue reading on Mediu
Power BI Data Modeling Unleashed: Master Schemas, Relationships, and Joins for High-Performance Reporting
Dev.to · It's pronounced W3SHY 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Power BI Data Modeling Unleashed: Master Schemas, Relationships, and Joins for High-Performance Reporting
Whether you're brand new to Power BI or just getting started with data analytics, this guide walks...
My 3rd excel project
Dev.to · Mohammad Meezan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
My 3rd excel project
I picked up a random dataset of amazon book sales of 10 years from kaggle and started exploring and...
How Data Science Projects Fail (and What Developers Can Do Differently)
Dev.to · Eva Clari 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Data Science Projects Fail (and What Developers Can Do Differently)
Organizations spend millions of dollars building data science and machine learning capabilities. They...
Day 29 of 100 Days of ClickHouse® - Understanding Distributed Tables
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 29 of 100 Days of ClickHouse® - Understanding Distributed Tables
Introduction As datasets grow, a single ClickHouse® server may eventually become...
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 »
Turning messy Airbnb / Vrbo / Booking.com payout CSVs into per-property profit
Dev.to · Lawrence Locke 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Turning messy Airbnb / Vrbo / Booking.com payout CSVs into per-property profit
Hosts rarely have a single clean ledger. Revenue comes from one export, platform fees from another,...
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...
From Privacy Compliance to Data Security — How GBase Helps Prevent Sensitive Data Exposure
Dev.to · Scale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Privacy Compliance to Data Security — How GBase Helps Prevent Sensitive Data Exposure
Organizations today face increasing pressure to protect sensitive information while still making data...
Modelling, Joins, Relationships and different Schemas
Dev.to · Pepsy-11y 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Modelling, Joins, Relationships and different Schemas
Data Modelling is the invisible architecture that structures your data so it is fast accurate and...
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 »
7 Resume Bullet Transformations That Turn “Task Doer” into “Impact Owner”
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
7 Resume Bullet Transformations That Turn “Task Doer” into “Impact Owner”
A LinkedIn connection sent me his resume. He had 3 years of experience. Good company. Decent projects. Solid Python skills. Continue reading on Medium »
Why regex couldn't parse my invoices (and what did)
Dev.to · zhongqiyue 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why regex couldn't parse my invoices (and what did)
I spent three weekends building a regex pipeline for invoice data extraction. By the end of it, I had...
Reddit r/artificial 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Utah Data Center Brute Forced Through to Approval Despite Widespread Popular Opposition
A data center was forced through government approval in Utah despite the citizens widely opposing its impact on scarce water resources and numerous other object
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why You Keep Falling for Dumb Data Tricks (And How Simple Math Fixes It)
A math book made me rethink every “obvious” conclusion I’ve ever drawn — and honestly, it kind of wrecked me in a good way. Continue reading on Mr. Plan ₿ Publi
TournamentIQ — Intelligence System on FIFA World Cup 2026
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
TournamentIQ — Intelligence System on FIFA World Cup 2026
TournamentIQ is a live intelligence system that tracks team strength using Elo Ratings. Continue reading on Medium »
1.4.6 Aggregate Cost: Choosing HashAgg vs GroupAgg
Dev.to · JoongHyuk Shin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
1.4.6 Aggregate Cost: Choosing HashAgg vs GroupAgg
A query like SELECT region, COUNT(*) FROM sales GROUP BY region folds many rows together, collapsing...
1.4.4 Join Strategies: Nested Loop, Hash, Merge
Dev.to · JoongHyuk Shin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
1.4.4 Join Strategies: Nested Loop, Hash, Merge
The costs in 1.4.2 and 1.4.3 were about how to read a single table. A join combines two tables, and...
From Legacy Data Platforms to Modern Data Stacks: Why Metadata Matters More Than Technology
Dev.to · Amit Kumar Singh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Legacy Data Platforms to Modern Data Stacks: Why Metadata Matters More Than Technology
Introduction Organizations spend millions of dollars modernizing data platforms. They migrate from...
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...
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Introduction to Pandas Series and DataFrames with Common Methods
If you work in the field of data analytics, you are probably familiar with Pandas. Pandas is a fast, flexible, and easy-to-use Python… Continue reading on Mediu
Vertical & Horizontal Bar Chart Plotting In Python with Matplotlib
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Vertical & Horizontal Bar Chart Plotting In Python with Matplotlib
This is a simple tutorial to plot the frequencies of your data labels using python. Continue reading on Medium »
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 »
How to Analyze Hacker News Engagement Patterns for Content Strategy
Dev.to · NexGenData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Analyze Hacker News Engagement Patterns for Content Strategy
Hacker News is a remarkably predictable ecosystem if you know how to read the signals. Every day,...
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
We shipped a weather app that learns your personal cold threshold — no ML, just percentiles
Dev.to · niixolabs 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
We shipped a weather app that learns your personal cold threshold — no ML, just percentiles
There's a gap between knowing the temperature and knowing whether to grab a coat. 14°C means very...
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
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