Tech Skills

Data Analytics & Business Intelligence

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

9,244
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 247 reads from curated sources

Your Pipeline Is 28.6h Behind: Catching Science Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2h ago
Your Pipeline Is 28.6h Behind: Catching Science Sentiment Leads with Pulsebit
Your Pipeline Is 28.6h Behind: Catching Science Sentiment Leads with Pulsebit We’ve just...
The First 30 Minutes I Spend When I Open a New Dataset
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3h ago
The First 30 Minutes I Spend When I Open a New Dataset
Why data exploration is like a first date — and how skipping it once cost me three days of wasted work. Continue reading on Medium »
Python for Data Science — Mini Project: File-Based Data Processor
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5h ago
Python for Data Science — Mini Project: File-Based Data Processor
A practical mini project that combines text files, CSVs, and JSON into one simple data workflow — the kind of small project that actually… Continue reading on M
Python for Data Science — Mini Project: File-Based Data Processor
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5h ago
Python for Data Science — Mini Project: File-Based Data Processor
A practical mini project that combines text files, CSVs, and JSON into one simple data workflow — the kind of small project that actually… Continue reading on M
How AI & Sports Analytics Are Transforming Every Sport in 2026
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 7h ago
How AI & Sports Analytics Are Transforming Every Sport in 2026
From gut instinct to neural networks — the $9.76 billion revolution that is rewriting how teams win, lose, scout, and compete. Continue reading on Medium »
A Guide To Building Your First Web Scraper with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 9h ago
A Guide To Building Your First Web Scraper with Python
We’ve all been there. You find a website with amazing data maybe like a list of stock prices, movie reviews etc. and you wanted that data… Continue reading on M
Future of Data Analytics: What’s Next After AI (2026 and Beyond)
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h ago
Future of Data Analytics: What’s Next After AI (2026 and Beyond)
The world of data is evolving faster than ever before. Not long ago, data analytics was mainly about writing SQL queries, building… Continue reading on Level Up
5 Data Patterns That Scream 'Your Developer Is Burning Out
Dev.to · Артур Пан 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h ago
5 Data Patterns That Scream 'Your Developer Is Burning Out
Burnout doesn't start with a resignation letter. IDE activity data reveals 5 warning patterns weeks before a developer quits or crashes.
Stop Planning Your Data Governance Strategy (Do This Instead)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h ago
Stop Planning Your Data Governance Strategy (Do This Instead)
Having realigned our mental models in the previous installment, we now face the crucible of execution. A paradigm shift is merely the… Continue reading on Data
You Don’t Need a Data Analyst Who Just Crunches Numbers.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 13h ago
You Don’t Need a Data Analyst Who Just Crunches Numbers.
Most companies hire data analysts expecting someone who can pull reports and build dashboards. But the ones who actually move the needle… Continue reading on Me
Simon Willison's Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 15h ago
SQL functions in Google Sheets to fetch data from Datasette
TIL: SQL functions in Google Sheets to fetch data from Datasette I put together some notes on patterns for fetching data from a Datasette instance directly into
How 80% of Our Signups Come From 20% of Countries: 6 Months of Geographic Data from an Indie AI Platform
Dev.to · Biricik Biricik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 15h ago
How 80% of Our Signups Come From 20% of Countries: 6 Months of Geographic Data from an Indie AI Platform
How 80% of Our Signups Come From 20% of Countries: 6 Months of Geographic Data from an Indie...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 17h ago
Motivation for Enrolling in Data Analysis with Machine Learning
In the modern era of scientific inquiry, the boundary between theoretical modeling and experimental observation is increasingly bridged by… Continue reading on
Modernizing Data Ingestion: An Async PostgreSQL Pipeline with Psycopg 3
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 17h ago
Modernizing Data Ingestion: An Async PostgreSQL Pipeline with Psycopg 3
Orchestrating high-performance migrations using asynchronous architectures and memory-safe processing. Continue reading on Medium »
When Python Breaks: A Practical Guide to Escaping Dependency Hell with Conda and Spyder
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 17h ago
When Python Breaks: A Practical Guide to Escaping Dependency Hell with Conda and Spyder
Everything was working perfectly… until suddenly, nothing worked anymore. Continue reading on Medium »
Leading a greenfield PostgreSQL database analytics focused buildout — Communication.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 18h ago
Leading a greenfield PostgreSQL database analytics focused buildout — Communication.
Leading a client-facing Data Engineering project? Ingesting raw data (bronze layer as defined in medallion architecture) from multiple… Continue reading on Medi
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 18h ago
La ética de datos en el análisis de datos
Comencé a adentrarme en la ética de datos gracias a un curso de la Academia de Cisco, la cual me ayudó a ganar una base sólida de teoría y… Continue reading on
Unsung Hero of Digital Success: Product Data Scientist
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 18h ago
Unsung Hero of Digital Success: Product Data Scientist
Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 19h ago
Construí un pipeline de BI para analizar el rendimiento de una creadora en Stripchat
Continue reading on Medium »
Make Databricks Admin
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 20h ago
Make Databricks Admin
This article give you detailing about how to make someone admin in the Databricks environment. Continue reading on Medium »
Make Databricks Admin
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 20h ago
Make Databricks Admin
This article give you detailing about how to make someone admin in the Databricks environment. Continue reading on Medium »
The Era of Agentic Analytics: From Static to Active Intelligence
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 20h ago
The Era of Agentic Analytics: From Static to Active Intelligence
What does agentic analytics and data science mean? Is it just cheaper execution — or is something fundamentally changing? Continue reading on Medium »
The Era of Agentic Analytics: From Static to Active Intelligence
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 20h ago
The Era of Agentic Analytics: From Static to Active Intelligence
What does agentic analytics and data science mean? Is it just cheaper execution — or is something fundamentally changing? Continue reading on Medium »
Data in Production, Part 1: Building for Production (Not Just for Your Laptop)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 20h ago
Data in Production, Part 1: Building for Production (Not Just for Your Laptop)
Part 1 of a 3-part series on what nobody teaches you about taking data from your laptop to production. Continue reading on Medium »
Data Engineering & Data Pipelines
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 23h ago
Data Engineering & Data Pipelines
Before dashboards, before AI models, before any useful business insight -someone has to move, clean and organize the raw data. Continue reading on Medium »
Stopped Sending Status Updates. Nobody Asked Where They'd Gone.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 23h ago
Stopped Sending Status Updates. Nobody Asked Where They'd Gone.
The updates had been landing in inboxes for eleven months. Nobody had mentioned them. I found this out by stopping. Continue reading on Activated Thinker »
Semester report: The Impact of M-Pesa on Financial Inclusion and Economic Development in Kenya
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Semester report: The Impact of M-Pesa on Financial Inclusion and Economic Development in Kenya
Course: Masters in Data Science for Society and Business Continue reading on Medium »
Clusterisasi Karakteristik Pekerja di Indonesia: Pekerja di Jawa Masih Termasuk Prioritas?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Clusterisasi Karakteristik Pekerja di Indonesia: Pekerja di Jawa Masih Termasuk Prioritas?
Bagaimana kondisi perekonomian Indonesia? Continue reading on Medium »
Mastering Modern Hiring Demonstration: Using Docling and PostgreSQL by Bob to Build a Local…
Medium · RAG 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Mastering Modern Hiring Demonstration: Using Docling and PostgreSQL by Bob to Build a Local…
This blog post’s idea is to explore how to bridge the gap between traditional relational data and unstructured documents to create a… Continue reading on Medium
Why I Joined Illumination to Seek Signal, Not Just Noise?
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Why I Joined Illumination to Seek Signal, Not Just Noise?
The Signal and the Noise: Why I Joined Illumination to Seek High Resolution Truth Continue reading on ILLUMINATION »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
A Guide To Building Your First Web Scraper with Python
A guide towards building Your First Web Scraper(LEGAL ONLY) with Python Continue reading on Medium »
Math That Won an Oscar
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Math That Won an Oscar
The Beauty of Perlin Noise Continue reading on Science Spectrum »
I Learned Python for 4 Years — Here’s What Actually Helped My Career
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
I Learned Python for 4 Years — Here’s What Actually Helped My Career
Most Python Advice Sounds Good. Very Little of It Actually Moves Your Career Forward. Continue reading on Stackademic »
54 Years Later: What the Data Behind Humanity’s Return to the Moon Shows
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
54 Years Later: What the Data Behind Humanity’s Return to the Moon Shows
How I reconstructed the physics of a real lunar mission, visualised cislunar space in 3D, and compared it to every Apollo mission using… Continue reading on Med
54 Years Later: What the Data Behind Humanity’s Return to the Moon Shows
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
54 Years Later: What the Data Behind Humanity’s Return to the Moon Shows
How I reconstructed the physics of a real lunar mission, visualised cislunar space in 3D, and compared it to every Apollo mission using… Continue reading on Med
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
The Resonance of the Code: Cracking the Voynich Manuscript Using the Schumann Frequency (7.83 Hz)
For centuries, the Voynich Manuscript (MS 408) has been considered the ultimate enigma of cryptography. This study proposes a paradigm… Continue reading on Medi
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Migrating Apache Iceberg Tables Between AWS Accounts: What Nobody Tells You
When my company needed to migrate to a new AWS account, I took on this project — and ended up successfully migrating nearly 2,000 Iceberg… Continue reading on M
A thought on Pydantic
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
A thought on Pydantic
Pydantic is the most widely used data validation library for Python. It allows you to define the “shape” of your data using Python type… Continue reading on Med
Predicting Blood Shortages Before They Happen
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Predicting Blood Shortages Before They Happen
How NLP, Random Forest, and a deep respect for clinical messiness built a blood demand forecasting system that works in production Continue reading on Medium »
Many Paths Lead to Data Work
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Many Paths Lead to Data Work
Having worked in the data space for many years, I’ve always been fascinated by just how diverse the talent pool is. I’m not talking about… Continue reading on M
Why Your Data Lakehouse Isn’t Ready for Agentic AI
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Why Your Data Lakehouse Isn’t Ready for Agentic AI
Four structural failures that will break when autonomous agents start querying your data Continue reading on Medium »
We’re Drowning in Data… But Most of It Means Nothing
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
We’re Drowning in Data… But Most of It Means Nothing
We often say “data is everywhere.” But we rarely stop to realize how true that actually is. Continue reading on Towards Data Engineering »
Decisions Your Data Can’t Make: The Perils of Radicalized Data Driven Thinking
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Decisions Your Data Can’t Make: The Perils of Radicalized Data Driven Thinking
The highest-leverage decisions are often the least defensible ones, until they work. Continue reading on Medium »
Augmented Analytics for Operations Teams: What Actually Works (And What Doesn’t)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Augmented Analytics for Operations Teams: What Actually Works (And What Doesn’t)
I’ve sat in enough vendor demos to know the difference between a capability and a pitch. Continue reading on Medium »
Augmented Analytics in Retail: What the Dashboards Can’t Tell You
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Augmented Analytics in Retail: What the Dashboards Can’t Tell You
Most retailers are swimming in data. The problem isn’t the data. It’s what happens after. Continue reading on Medium »
O que realmente faz um cliente deixar nota 1? Analisei 99 mil avaliações da Olist pra descobrir
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
O que realmente faz um cliente deixar nota 1? Analisei 99 mil avaliações da Olist pra descobrir
Quando comecei a explorar os dados da Olist, esperava encontrar algum vendedor problemático, uma categoria de produto com mais reclamações… Continue reading on
Augmented Analytics vs.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Augmented Analytics vs.
I spent years building BI reports that nobody read. Here’s what I wish I’d understood sooner. Continue reading on Medium »
Making Inventory Management Smarter with ABC-XYZ Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Making Inventory Management Smarter with ABC-XYZ Analysis
Link to problem and notebook: https://www.kaggle.com/code/cheenarawat/abc-xyz-analysis Continue reading on Medium »