Tech Skills
Data Analytics & Business Intelligence
Excel, SQL, Power BI, Tableau — turn raw data into business decisions
Skills in this topic
7 skills — Sign in to track your progress
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 719 reads from curated sources
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
3w 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
Dev.to · Biricik Biricik
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
3w 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
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
3w 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
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Unsung Hero of Digital Success: Product Data Scientist
Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Construí un pipeline de BI para analizar el rendimiento de una creadora en Stripchat
Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Make Databricks Admin
This article give you detailing about how to make someone admin in the Databricks environment. Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Make Databricks Admin
This article give you detailing about how to make someone admin in the Databricks environment. Continue reading on Medium »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Clusterisasi Karakteristik Pekerja di Indonesia: Pekerja di Jawa Masih Termasuk Prioritas?
Bagaimana kondisi perekonomian Indonesia? Continue reading on Medium »
Medium · RAG
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
Medium · Deep Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Math That Won an Oscar
The Beauty of Perlin Noise Continue reading on Science Spectrum »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
3w 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
3w 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
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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 »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Silent Pulse of Knowledge: Why Data is the Soul of Sustainability
The true lifeblood of the organization flows elsewhere Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
A Brief History of Data Visualization
Data visualization isn’t just about fancy charts in BI reports; it is the oldest and powerful analytical tool. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Why Bitcoin Keeps Failing to Break Key Price Levels – And What It Really Means for You
Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Data Lakehouse Architecture Explained: The Best of Data Lakes and Data Warehouses
One paradigm to end the decade-long war between storage and structure. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Real Cost of Petrol in India: A Data-Driven Breakdown
04/18/2026 04:02 PM IST Continue reading on Medium »
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Your Data Pipeline Works Until It Suddenly Doesn’t
Why your “reliable” batch architecture is secretly choking your AI — and how to fix it before the dashboard goes red. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Your Data Pipeline Works Until It Suddenly Doesn’t
Why your “reliable” batch architecture is secretly choking your AI — and how to fix it before the dashboard goes red. Continue reading on Medium »
Medium · Startup
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Your Data Pipeline Works Until It Suddenly Doesn’t
Why your “reliable” batch architecture is secretly choking your AI — and how to fix it before the dashboard goes red. Continue reading on Medium »
DeepCamp AI