Tech Skills

Data Analytics & Business Intelligence

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

9,251
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

Showing 254 reads from curated sources

New EV Sales Are Slowing = Charging Crisis? The Real Opportunity Hidden in the Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
New EV Sales Are Slowing = Charging Crisis? The Real Opportunity Hidden in the Data
The ‘Real Charging Demand’ Obscured by Media Headlines Continue reading on Medium »
The Death of the Dashboard: Why I’m Finally Trading My SQL Queries for Conversations
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Death of the Dashboard: Why I’m Finally Trading My SQL Queries for Conversations
I’ve spent the last decade of my life in the “trenches” of data. I’m 35 now, and if I’m honest, I’ve spent a good chunk of those years… Continue reading on Medi
Practical SQL Concepts
Dev.to · Alex Waiganjo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Practical SQL Concepts
Introduction In today's world data driven world, data is becoming more valuable in that it...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Protocolo de Síntesis v1.0.0: El Framework para la Toma de Decisiones y Síntesis de Inteligencia
Introducción Continue reading on Medium »
Systems Thinking for Research
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Systems Thinking for Research
Continue reading on Operations Research Bit »
“I Have Read and Agree to the Terms” Is Now the Biggest Lie We Tell Ourselves on the Web
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
“I Have Read and Agree to the Terms” Is Now the Biggest Lie We Tell Ourselves on the Web
Do you know why you don’t bother reading the privacy agreements on your smart devices? Continue reading on Medium »
Building a School Database from Scratch: A Practical Introduction to SQL
Dev.to · Shadrack Tesot 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building a School Database from Scratch: A Practical Introduction to SQL
Building a school database from scratch There’s a certain kind of satisfaction that comes...
From Complaints to Intelligence: How Data Reveals Nigeria’s Waste Management Crisis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Complaints to Intelligence: How Data Reveals Nigeria’s Waste Management Crisis
Introduction Continue reading on Medium »
The Python Cheatsheet Every Data Scientist Wishes They’d Had on Day One
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Python Cheatsheet Every Data Scientist Wishes They’d Had on Day One
Every term is explained in plain English. Every snippet you’ll actually use. Bookmark this — you’ll come back. Continue reading on Medium »
The 1,000 Repository Milestone - The Power of Sharding
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The 1,000 Repository Milestone - The Power of Sharding
In the world of Big Data, the instinct is usually to build a bigger “bucket” — a massive SQL database or a monolithic Data Lake. Continue reading on Medium »
Speed isn’t the problem. I analysed 4,472 quick commerce reviews to find out what is.
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Speed isn’t the problem. I analysed 4,472 quick commerce reviews to find out what is.
About the project: Continue reading on Medium »
The Complete Guide to Python Data Visualization Libraries
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Complete Guide to Python Data Visualization Libraries
Python has become the go-to language for data visualization, and for good reason. Its ecosystem offers a tool for every situation, whether… Continue reading on
I Built an F1 Race Intelligence Dashboard — Here’s Everything I Learned
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Built an F1 Race Intelligence Dashboard — Here’s Everything I Learned
From GPS telemetry to spring-physics cameras, AI race engineers to voice commentary — the story of turning raw Formula 1 data into a… Continue reading on Medium
Applying SQL Concepts: DDL, DML, Filtering, and Data Transformation
Dev.to · Sharon-nyabuto 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Applying SQL Concepts: DDL, DML, Filtering, and Data Transformation
Structured Query Language (SQL) is the standard language used to interact with relational databases....
Unpacking the language of data: DDL, DML, Filtering and Transformation.
Dev.to · Zawadi Mwikali 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Unpacking the language of data: DDL, DML, Filtering and Transformation.
📌 DDL vs DML In SQL, commands are broadly divided into two categories: DDL (Data...
*177* The Structural Discontinuity 2/3 Inactivation of Life:
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
*177* The Structural Discontinuity 2/3 Inactivation of Life:
When Interpretation Replaces Observation Continue reading on Medium »
How I Built a System That Turns Raw Sales Data Into Business Decisions in A Day
Dev.to · Sai Sarvaja Boominathan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How I Built a System That Turns Raw Sales Data Into Business Decisions in A Day
Most companies I've talked to have the same problem. They collect sales data religiously — every...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Data Matters in Small-Scale Industrial Systems
You do not need a data science team or a six-figure analytics platform. You need a spreadsheet and the discipline to fill it. Continue reading on Medium »
Keep pushing, Keep fixing, Keep learning to handling uncertainity
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Keep pushing, Keep fixing, Keep learning to handling uncertainity
Only working framework for moving through uncertainty Continue reading on Data Box »
10 Data Science Problems Every Retailer Wants Solved (And How to Frame Them)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
10 Data Science Problems Every Retailer Wants Solved (And How to Frame Them)
Part 9 of “The Retail Data Playbook” Continue reading on Medium »
Python for Data Science — Defensive Coding for Noisy Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Defensive Coding for Noisy Data
If you’ve only worked with clean tutorial datasets, Python can feel deceptively easy. Continue reading on Medium »
Python for Data Science — Defensive Coding for Noisy Data
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Defensive Coding for Noisy Data
If you’ve only worked with clean tutorial datasets, Python can feel deceptively easy. Continue reading on Medium »
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Write Pandas Like a Pro With Method Chaining Pipelines
Master method chaining, assign(), and pipe() to write cleaner, testable, production-ready Pandas code The post Write Pandas Like a Pro With Method Chaining Pipe
How Boards Can Use Question Refinement Patterns to Turn Complex Data into Actionable Insights
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Boards Can Use Question Refinement Patterns to Turn Complex Data into Actionable Insights
Photo by Planet Volumes on Unsplash Continue reading on The Boardroom Knights »
How Boards Can Use Question Refinement Patterns to Turn Complex Data into Actionable Insights
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Boards Can Use Question Refinement Patterns to Turn Complex Data into Actionable Insights
Photo by Planet Volumes on Unsplash Continue reading on The Boardroom Knights »
The Emoji Bug in SQL Server That Isn’t Actually a Bug
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Emoji Bug in SQL Server That Isn’t Actually a Bug
You run the same logic in two databases: Continue reading on Medium »
The Emoji Bug in SQL Server That Isn’t Actually a Bug
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Emoji Bug in SQL Server That Isn’t Actually a Bug
You run the same logic in two databases: Continue reading on Medium »
Lebanon News Focuses on War. People Search Survival.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Lebanon News Focuses on War. People Search Survival.
In March 2026, nearly all international news coverage about Lebanon focused on conflict. But public attention told a different story. Continue reading on Medium
Spatially Prioritizing Land Restoration in Kenya: A Data-Driven Approach to Maximizing Impact for…
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Spatially Prioritizing Land Restoration in Kenya: A Data-Driven Approach to Maximizing Impact for…
One of the greatest questions for investors, communities, scientists, policymakers, governments, and anyone who cares about land… Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Introduction to SQL: Basics and Types of Queries
Structured Query Language (SQL) is the standard language used to interact with relational databases. It allows users to store, retrieve… Continue reading on Med
Choosing the Right Python Data Structure: List, Tuple, Set, or Dictionary?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Choosing the Right Python Data Structure: List, Tuple, Set, or Dictionary?
A practical guide to understanding when — and why — to reach for each one. Continue reading on Medium »
Counting the Silence: The Data That Proves Gender Bias in Music
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Counting the Silence: The Data That Proves Gender Bias in Music
What’s going on, and what we can do about it Continue reading on Fourth Wave »
EDA Made Simple: How to Explore Any Database Like a Pro!
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
EDA Made Simple: How to Explore Any Database Like a Pro!
Practical techniques to navigate complex databases and ask the right questions Continue reading on Medium »
What FP&A Actually Looks Like in Insurance And Why Most Analysts Aren’t Ready for It
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What FP&A Actually Looks Like in Insurance And Why Most Analysts Aren’t Ready for It
Budgeting and Excel are the entry ticket. Here’s what actually makes you valuable. Continue reading on Medium »
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Stocked or Stranded? Predictive Analytics In Healthcare Supply Chains
In 'Closing the Gap: Where Are Africa’s Healthcare Predictive Models', it was evident that the gap between research findings and… Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Stocked or Stranded? Predictive Analytics In Healthcare Supply Chains
In 'Closing the Gap: Where Are Africa’s Healthcare Predictive Models', it was evident that the gap between research findings and… Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The First Act of Creation Is Not Building — It Is Naming
Why creation begins long before code, matter, or form Continue reading on Medium »
The Alchemy Of Information
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Alchemy Of Information
From Overload to Vitality Continue reading on Beyond Lines »
Best Proxies for Web Scraping (2026 Guide)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Best Proxies for Web Scraping (2026 Guide)
Discover the best proxies for web scraping in 2026, including datacenter, residential, and rotating setups. Continue reading on Medium »
How Polls Predict Elections Without Asking Everyone (And Why They’re Sometimes Wrong)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Polls Predict Elections Without Asking Everyone (And Why They’re Sometimes Wrong)
Let us just say it is election season and you turn on the news and see: Continue reading on Medium »
Stop Chasing Shadows: Why Domain Intelligence is the Analytics Upgrade You Didn’t Know You Needed
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Stop Chasing Shadows: Why Domain Intelligence is the Analytics Upgrade You Didn’t Know You Needed
I’ve spent the better part of the last decade staring at dashboards. If you’re like me — somewhere in that mid-career “sweet spot” where… Continue reading on Me
This Single Indicator Is Best For Swing Trading
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
This Single Indicator Is Best For Swing Trading
SCALPER PRO Apex Predator System Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Fundamentos y Arquitectura de Datos
Arquitectura propuesta: Continue reading on Medium »
Journal Figure Reproduction | Plotting RDA with Python
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Journal Figure Reproduction | Plotting RDA with Python
Redundancy Analysis Continue reading on Top Python Libraries »
Journal Figure Reproduction | Plotting RDA with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Journal Figure Reproduction | Plotting RDA with Python
Redundancy Analysis Continue reading on Top Python Libraries »
Simulation: Using Random Numbers to Model Uncertainty
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Simulation: Using Random Numbers to Model Uncertainty
Using random numbers and simulation to understand uncertainty and make better decisions. Continue reading on Medium »
Job Scraping Tools vs API: Reliability, Cost, and Compliance
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Job Scraping Tools vs API: Reliability, Cost, and Compliance
Disclaimer: This section is informational, not legal advice. Continue reading on Medium »
Why Jupiter Devoured Shoemaker-Levy 9 and Spared 3I/ATLAS
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Jupiter Devoured Shoemaker-Levy 9 and Spared 3I/ATLAS
Continue reading on Medium »