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

Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2h ago
The System Didn’t Fail. It Did Exactly What It Was Designed To Do.
There is a common assumption we make when systems behave badly. Continue reading on AI Advances »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2h ago
Masih Ragu Ambil Sertifikasi BNSP Data Science? Ini Alasan Kenapa Kamu Justru Perlu Sekarang!
Sertifikasi BNSP Data Science sering dianggap sebagai “tiket tambahan” untuk masuk ke dunia kerja, terutama di bidang data dan teknologi… Continue reading on Me
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2h ago
Balancing ‌predictive ‌power ‌with privacy in insurance.
In insurance, the whole engine runs on data, and that data is personal by default. For a project with Sure Tomorrow, I looked at how… Continue reading on Medium
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5h ago
The Unexpected Benefits of Knowledge Hoarding: What Two Years with Papers Taught Me About Information Addiction
The Unexpected Benefits of Knowledge Hoarding: What Two Years with Papers Taught Me About Information Addiction Honestly, I never thought I'd become this person
DFAS-RPG: Article 08 | Validation Governance: Separating Path Integrity from Outcomes
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6h ago
DFAS-RPG: Article 08 | Validation Governance: Separating Path Integrity from Outcomes
Research Path Governance (DFAS-RPG) refers to the governance of how knowledge is produced, not merely what is published. Continue reading on Medium »
I Built an AI-powered Youth Intelligence Platform Dashboard to Track The Rate of Unemployment- Here…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 8h ago
I Built an AI-powered Youth Intelligence Platform Dashboard to Track The Rate of Unemployment- Here…
The Problem That Started Everything Continue reading on Medium »
ANÁLISE DE MOVIMENTAÇÃO DE EXPORTAÇÕES NOS PORTOS DO CEARÁ
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 8h ago
ANÁLISE DE MOVIMENTAÇÃO DE EXPORTAÇÕES NOS PORTOS DO CEARÁ
Este projeto traz análises sobre a exportação de cargas nos dois portos do estado do Ceará. A intensão principal é entender o impacto das… Continue reading on M
Your Pipeline Is 28.6h Behind: Catching Science Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 11h 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 12h 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 14h 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 14h 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 16h 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 18h 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 20h 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 20h 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 20h 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 22h 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 23h 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 1d 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 1d 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 1d 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 1d 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 1d 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 1d 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 1d ago
Unsung Hero of Digital Success: Product Data Scientist
Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 1d 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 1d 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 1d 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 1d 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 1d 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 1d 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 1d 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 2d 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 »