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
Dev.to · Ab
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
csvtidy: merge and clean CSV files from the terminal, with reusable recipes
Every month it's the same CSV exports. Same system, same columns, same handful of cleanup steps...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
How We Helped an Auto Parts Plant Cut MES Query Times by Up to 116x
On a single automotive parts production line, PLCs write a new data point every few hundred milliseconds, with SCADA, test equipment, and… Continue reading on M
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Every Dataset Has a Personality Disorder
Every dataset has a personality, and most of them have a disorder. Continue reading on Data Science Collective »
Dev.to · Furiosa Studio
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
How we model the Golden Boot race across 30+ leagues
"Top scorer of a league" sounds like one line of SQL: SELECT player, COUNT(*) FROM goals GROUP BY...
Dev.to · Kanishga Subramani
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Day 49: Building Dashboards with ClickHouse® and Apache Superset
Introduction A fast analytical database alone isn't enough to deliver insights....
Dev.to · SpurIQ Engineering
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Automating the RevOps Data Layer: How to Make CRM Actually Reflect Reality
45% of contacts never get logged. 17% of rep time goes to data entry. Here's the architecture that...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
The Nervous System of the Telco: Unlocking the Real-Time Power of the Network Element Interfaces…
Imagine a human body trying to survive when: Continue reading on Medium »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Enhanced RFM Analysis for Customer Segmentation using K-Prototypes
In the previous article, we performed basic RFM Analysis using K-Means. However, customer behaviour is not limited to spending activity… Continue reading on Med
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
One Survey Asked Rich People Ten Times More Often Than Poor People.
You ran a survey, but it was lopsided: for every poor person you reached, you reached ten rich people. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Data Cleaning Fundamentals: Building a Reproducible Data Cleaning Pipeline
A Practical Framework for Transforming Raw Data into Analysis-Ready Datasets Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Data Cleaning Fundamentals: Building a Reproducible Data Cleaning Pipeline
A Practical Framework for Transforming Raw Data into Analysis-Ready Datasets Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Analysis on Customer Churn
1. Business Problem Worth Solving Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Bridging the Lab-Software Gap
What scientists need that engineers don’t understand Continue reading on Medium »
Dev.to · Season Mudbhary
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
I Built an Open Healthcare Data Dictionary with 100k+ ISO-11179 Terms — Here's What I Learned
If you've ever worked on a healthcare data team, you've lived this problem: one system calls it...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
You’ve Been A Data Analyst Your Whole Life — You Just Didn’t Know It
A beginner’s guide to one of the most in-demand skills of the decade — told through the decisions you already make every day. Continue reading on Medium »
Dev.to · Nasrul Hazim Bin Mohamad
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
When a KPI reads 163 billion instead of 819
TL;DR A metrics engine had two query paths — a SQL push-down for big datasets, an...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Vanity Metrics vs. Actionable Metrics: A Framework for Knowing the Difference
Why pageviews, followers, and time-on-page are seductive but misleading without context. A behavioral science framework for distinguishing… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Building an End-to-End Lakehouse on Databricks: Instacart Analytics from Pipeline to Insight
In my previous article, I wrote about what two Databricks learning tracks reinforced about the modern data lifecycle — and why the… Continue reading on Medium »
Simon Willison's Blog
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
HTML table extractor
Tool: HTML table extractor Yet another in my growing collection of paste-conversion tools. This one accepts pasted rich text from browsers (with embedded HTML t
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Beyond the Credit Score: What 1.3 Million Loans Reveal About Who Actually Repays
Three projects on real lending data, and what they say about a fairer, sharper way to decide who gets a loan. Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Beyond the Credit Score: What 1.3 Million Loans Reveal About Who Actually Repays
Three projects on real lending data, and what they say about a fairer, sharper way to decide who gets a loan. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Where Does the Crowd Excel? Polymarket Accuracy by Category
Not all predictions are created equal. Weather, politics, sports, and crypto operate under fundamentally different uncertainty regimes —… Continue reading on Me
Dev.to · Atqiya Abida Anjum
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
How Microsoft Excel Quietly Breaks Your JSON Imports (And How to Fix It)
If you have ever built an application or pipeline that accepts CSV uploads, you have probably run...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Customer, Product, and Profitability Performance Analysis in Supply Chain Operations: A Case Study…
Suhani Khanna Data Science Intern, Unified Mentor Department of Data Science and Analytics June 2026 Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Customer, Product, and Profitability Performance Analysis in Supply Chain Operations: A Case Study…
Suhani Khanna Data Science Intern, Unified Mentor Department of Data Science and Analytics June 2026 Continue reading on Medium »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
I Didn’t Notice the Compounding Until the Last Day”
Continuing from my last day, today I am writing about my further experiments added today and submitted on the leaderboard. To analyse, you… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
I Spent 3 Months Using Extended Thinking in Production. Here’s When It Actually Helps.
Where adaptive thinking earns its token cost, and the task types where more thinking quietly makes things worse. Continue reading on Data Science Collective »
Medium · LLM
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
I Spent 3 Months Using Extended Thinking in Production. Here’s When It Actually Helps.
Where adaptive thinking earns its token cost, and the task types where more thinking quietly makes things worse. Continue reading on Data Science Collective »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Institutional Compression: Why Models Fail to Match Reality
Institutions compress reality to broadcast it. The compression scales. Accuracy does not. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Microsoft Says Its GPU-Accelerated Warehouse Is Up to 7x Faster. Here’s How to Read That Benchmark.
In June 2026, Microsoft announced GPU acceleration built into Fabric Data Warehouse — early access preview, four regions, sign-up form… Continue reading on Towa
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
It’s Not the Cow, It’s the How: What 60 Years of Food Data Say About the Climate Cost of Dinner
I wanted to understand how much what we eat really costs the planet. I didn’t reach for a hot take; I reached for the data. Three projects… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
It’s Not the Cow, It’s the How: What 60 Years of Food Data Say About the Climate Cost of Dinner
I wanted to understand how much what we eat really costs the planet. I didn’t reach for a hot take; I reached for the data. Three projects… Continue reading on
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
We Built a Live World Cup 2026 Dashboard in Markdown
104 matches, 48 nations, one trophy. Continue reading on Medium »
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
The Complete SQL Roadmap for 2026: From First Query to Job-Ready
SQL turned 50 this year. It is still the single most requested skill on every data analyst job posting — and the roadmap to mastering it… Continue reading on Me
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
A/B Testing Statistics: P-Values, Confidence Intervals, and What They Actually Mean
Demystify A/B testing statistics — p-values, confidence intervals, Type I and Type II errors, and one-tail vs two-tail tests explained in… Continue reading on M
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Day 1 of My Data Science Journey: Building the Foundation
Today marks the beginning of my six‑month Data Science internship. For me, this isn’t just another training program — it’s the start of a… Continue reading on M
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Garbage In, Garbage Out: Why AI Depends on Clean Data
Artificial Intelligence is changing the way we live, work, and make decisions. It recommends the movies we watch, assists doctors in… Continue reading on Medium
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Understanding NetCDF: The Data Format Behind Climate and Satellite Science
A beginner-friendly guide to the scientific file format behind climate science, remote sensing, hydrology, and Earth observation. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
The Skill That Separates Senior Data Scientists From Everyone Else
Sebastian Wernicke on communication, stakeholder resistance, and why data alone rarely changes minds. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
The Biotech Translation Gap: Where Clinical Success, Capital, and Unmet Need Diverge
The biotech market is often described as one long funnel: science enters at one end, clinical trials test whether it works, investors fund… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Data Centers: Balancing Perspectives in Local Political Debates
The current debate suffers from a basic analytical flaw. Continue reading on Medium »
The Register
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Microsoft to assist European Commission in defense of EU-US data-sharing agreement
Court says Redmond can file briefs, take part in hearings amid challenge to the current path Big Tech's data spice uses to legally flow
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Solving the E-Commerce Fit Problem: My First End-to-End DataOps Pipeline
If you have ever ordered a shirt online only to find out it fits like a tent, you know the frustration of e-commerce sizing. But for… Continue reading on Medium
Towards Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
I Completed Five Years in Analytics Consulting: 5 Lessons That Changed How I Work
The tools I use for analytics and reporting have changed more than I expected, yet my questions for any analytics project haven't moved much. The post I Complet
Dev.to · David Maina
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
From Zero to Spreadsheet: My Honest First Experience with Microsoft Excel
A beginner's journey through cells, formulas, and a few accidental disasters When someone first...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Apache Spark Joins Explained: Everything You Need to Know About Strategies, Types, Execution Plans…
Joins are one of the most computation heavy and expensive operations in data processing systems. While joins are common in traditional… Continue reading on Medi
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Um Pipeline para uma ONG: Transformei Dados do Instagram Em Recomendações
Tem projetos que surgem de uma necessidade técnica. Esse surgiu de uma conversa. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Who Finances the World?
A Practical Guide to Global Capital, Debt Markets and Financial Systems Continue reading on Medium »
DeepCamp AI