Tech Skills

Data Analytics & Business Intelligence

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

16,772
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
All Reads (7,307) Articles (2992)Blog Posts (3416)Tutorials (364)Research Papers (39)News (496)
Training in Dad Mode: How I Built a Strava-to-Notion Dashboard with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Training in Dad Mode: How I Built a Strava-to-Notion Dashboard with Python
A small personal automation project for turning fitness data into a useful training system Continue reading on Medium »
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Your Apache Iceberg Tables Are Slowing Down (And How to Fix It)
Continue reading on Medium »
Tinkering with Databricks: Claude Desktop, MCP, and a Clinical Intelligence Server
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Tinkering with Databricks: Claude Desktop, MCP, and a Clinical Intelligence Server
When Claude Desktop becomes the interface, MCP becomes the bridge, and Databricks stays the governed data backbone, the shape of a… Continue reading on Medium »
【UoM】 Health Data Science 25/26 — Semester 2 (All Optional)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
【UoM】 Health Data Science 25/26 — Semester 2 (All Optional)
In Semester 2, every module is optional. You’ll choose 4 out of 11 available units. The course list was shared in mid-November, and you’ll… Continue reading on
The Math Behind “The House Always Wins”
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Math Behind “The House Always Wins”
Breaking down the hidden probabilities on the casino floor. Continue reading on Towards AI »
What a client constraint taught me about writing Databricks code in 2026
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What a client constraint taught me about writing Databricks code in 2026
Left to my own devices, I write Databricks code in a terminal. Claude Code across the repo, Databricks Asset Bundles to ship, pytest… Continue reading on Medium
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
My Data Project Was 22 Megabytes for the LLM. Now It’s 241 Kilobytes.
I didn’t change the data. I changed how I packaged it. Continue reading on Medium »
Last Summer I Wrote Code to Analyze the Titanic Dataset.
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Last Summer I Wrote Code to Analyze the Titanic Dataset.
Last summer, I was learning data science the way most people do. Pick a popular dataset. Write some pandas code. Run a few plots. Call it… Continue reading on M
Building Production-Grade Delta Lake Pipelines with Apache Spark on Databricks
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building Production-Grade Delta Lake Pipelines with Apache Spark on Databricks
A deep dive into the medallion architecture, Delta Lake internals, Z-ordering, and optimized Spark writes — the patterns that separate… Continue reading on Code
Audit Workflows, Reef Cameras, Tokenizer Research: Three CDS Capstone Projects
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Audit Workflows, Reef Cameras, Tokenizer Research: Three CDS Capstone Projects
Most graduate-level coursework ends with a final exam or paper. The CDS Capstone Project ends with research the UN features on its blog… Continue reading on Med
Survivorship Bias in Backtesting: The Ghosts of the Stock Market
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Survivorship Bias in Backtesting: The Ghosts of the Stock Market
Lehman Brothers, Bear Stearns, Sears — and why every strategy built on S&P 500 historical data is missing the companies that mattered most… Continue reading on
AWS Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
AI-powered BI with Snowflake and Amazon Quick
In this post, you will learn how to build an end-to-end integration between Snowflake semantic views and Amazon Quick. The sample data is user review data for a
How to Reduce Your Cost to Serve Without Sacrificing Customer Experience
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Reduce Your Cost to Serve Without Sacrificing Customer Experience
Imagine two customers buying the exact same product at the exact same price. On paper, they generate identical revenue. In reality, one of… Continue reading on
What We Teach Our Private Students (2026)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What We Teach Our Private Students (2026)
Public details of the STS 2:1 guidance programme, highlighting our structured, ethical framework. Continue reading on Medium »
Why Is Cost to Serve So Hard to Measure?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Is Cost to Serve So Hard to Measure?
Two customers buy the exact same product at the exact same price. One of them quietly costs you twice as much to serve. Same revenue line… Continue reading on M
I Replaced Pandas Workflows with DuckDB. Here’s What Happened.
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Replaced Pandas Workflows with DuckDB. Here’s What Happened.
The Data Tool I Treated Like a Database Turned Out to Be a Better DataFrame Continue reading on Medium »
The Ultimate Guide to Data Visualization with Pandas in 2026: Architectures, PyArrow Backends, and…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Ultimate Guide to Data Visualization with Pandas in 2026: Architectures, PyArrow Backends, and…
The release of Pandas 3.0 on January 21, 2026, marks a fundamental paradigm shift in the Python data ecosystem. For web developers and… Continue reading on Medi
From Black Box to Runbook: Why Every Data Product Needs an FAA Checklist
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Black Box to Runbook: Why Every Data Product Needs an FAA Checklist
There is a particular kind of silence that happens in data teams when a critical system breaks. Continue reading on Medium »
R Shiny and Google Cloud Run
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
R Shiny and Google Cloud Run
Dashboards are useful when you want your audience to be able to explore data without asking them to read through static tables or code. In… Continue reading on
Data Engineering Coding Challenge (Python Data Validation)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Engineering Coding Challenge (Python Data Validation)
​Sample Data Engineering Take Home Test with Solution Continue reading on Medium »
How Socioeconomic Factors Influence Chronic Disease Outcomes
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Socioeconomic Factors Influence Chronic Disease Outcomes
Chronic disease management is influenced by far more than medical treatment alone. Research has consistently shown that factors such as… Continue reading on Med
How you play is where you belong
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How you play is where you belong
A location-free model that reads a player’s role from how he behaves on the ball — and the positions he could play. Continue reading on Medium »
CODE #4: CHOOSING THE RIGHT PROGRAMMING LANGUAGE? (R DATA SCIENCE & VISUALIZATION)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
CODE #4: CHOOSING THE RIGHT PROGRAMMING LANGUAGE? (R DATA SCIENCE & VISUALIZATION)
Trade-offs in programming languages; LLM bias toward Python/away from Rust; historical perspective; and a use-case of R for advanced data… Continue reading on M
What are data centers in web hosting?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What are data centers in web hosting?
Written by Richard Detering Continue reading on Medium »
How We Built a Per-Plant CO2 Dataset for 4,551 Power Stations Worldwide
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How We Built a Per-Plant CO2 Dataset for 4,551 Power Stations Worldwide
The authors built and openly published a dataset covering 4,551 power stations worldwide, combining emissions, ownership, capacity, fuel type, and climate-zone
Data Products Aren’t Dead, But They’re No Longer The Endgame
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Products Aren’t Dead, But They’re No Longer The Endgame
Data products helped organizations organize and govern information at scale, but competitive advantage now comes from embedding trusted data into the decisions
Nobody Needs a GPU All Day
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Nobody Needs a GPU All Day
Most of the time, your GPU is waiting for you. Continue reading on Medium »
From (Heated) Rivalry to (Dirty) Dancing: make 10 devs learn to share one BI app
Medium · DevOps 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From (Heated) Rivalry to (Dirty) Dancing: make 10 devs learn to share one BI app
Just like on a rink, two developers enter the shared BI app to compete for the same measure. Only one will survive. By morning there’s a… Continue reading on Me
Managing Relational Bottlenecks: A Technical Audit of Advanced Academic Database Support Systems
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Managing Relational Bottlenecks: A Technical Audit of Advanced Academic Database Support Systems
An architectural evaluation of external infrastructure, dialect precision, and digital footprint protection for computer science and data… Continue reading on M
Why Choose a Data Science Course in Pitampura for a High-Paying Job?
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Choose a Data Science Course in Pitampura for a High-Paying Job?
Artificial Intelligence (AI) and digital transformation are reshaping industries worldwide, creating a strong demand for professionals who… Continue reading on
“The Silent Revolution: Why Your Data, Not Your Model, Is the Secret to AI Success”
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
“The Silent Revolution: Why Your Data, Not Your Model, Is the Secret to AI Success”
The Silent Revolution: Why Your Data, Not Your Model, Is the Secret to AI Success Continue reading on Medium »
Building a Production-Ready Snowflake MCP Server
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building a Production-Ready Snowflake MCP Server
MCP lets Claude query Snowflake directly in real time. This guide covers three deployment patterns (stdio, SSE, cloud-hosted), RSA key-pair auth, a minimal-perm
How Data Science Is Supporting Talent Development Across Vadodara’s Growing Industries
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Data Science Is Supporting Talent Development Across Vadodara’s Growing Industries
Vadodara’s industrial landscape is evolving as manufacturing, engineering, pharmaceuticals, and service-based companies increasingly… Continue reading on Medium
From 0–0 to 4–0: What Changed for Spain?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From 0–0 to 4–0: What Changed for Spain?
Spain dominated both matches, but only one produced goals. FIFA’s post-match data shows that the difference was penetration, movement and… Continue reading on M
Using GitHub as a Wildfire Time-Series Database: A Geospatial Aviation Pipeline
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Using GitHub as a Wildfire Time-Series Database: A Geospatial Aviation Pipeline
I built a pipeline that correlates wildfire incident data from InciWeb with live aircraft positions from FlightAware, using GitHub itself as the time-series dat
How I Prepared for a Data Science Aptitude Test for a German Master’s Program
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How I Prepared for a Data Science Aptitude Test for a German Master’s Program
What is a Data Science Aptitude Test & Which Programs Require It? Continue reading on CodeToDeploy »
Baidu’s Unlimited OCR : Beats DeepSeek OCR, Parses entire book in one go
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Baidu’s Unlimited OCR : Beats DeepSeek OCR, Parses entire book in one go
How to use Baidu’s Unlimited OCR Continue reading on Data Science in Your Pocket »
AI and Machine Learning Training in Hyderabad
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
AI and Machine Learning Training in Hyderabad
Data Science Course in Hyderabad — Build a Successful Career with Quality Thought Software Institute Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How I Transitioned from Mechatronics Engineering to Data Science
When people hear that I work as a Data Scientist today, they often assume that I studied Computer Science or Statistics. The reality is… Continue reading on Med
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How I Transitioned from Mechatronics Engineering to Data Science
When people hear that I work as a Data Scientist today, they often assume that I studied Computer Science or Statistics. The reality is… Continue reading on Med
Where Are Wellington’s Most Dangerous Roads? Mapping Crash Hotspots with Spatial Data Science
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Where Are Wellington’s Most Dangerous Roads? Mapping Crash Hotspots with Spatial Data Science
What 12,000 crash records, a clustering test, and one seriously counter — intuitive finding revealed about road safety in New Zealand’s… Continue reading on Med
Polars: A Practical Introduction to Fast DataFrames in Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Polars: A Practical Introduction to Fast DataFrames in Python
I have been analyzing data in Python for more than 10 years. In the beginning, I wrote a lot of custom Python functions for data… Continue reading on Medium »
Biology in Finance
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Biology in Finance
I studied Biology for six years. Today, I work in credit and risk modeling — and have done so for roughly the same amount of time. Continue reading on Medium »
The Quiet Skill That Separates $50K Analysts from $150K Analysts
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Quiet Skill That Separates $50K Analysts from $150K Analysts
It’s not SQL. It’s not Python. It’s not dashboards. Here’s what it actually is — and why almost nobody teaches it. Continue reading on AI & Analytics Diaries »
The Quiet Skill That Separates $50K Analysts from $150K Analysts
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Quiet Skill That Separates $50K Analysts from $150K Analysts
It’s not SQL. It’s not Python. It’s not dashboards. Here’s what it actually is — and why almost nobody teaches it. Continue reading on AI & Analytics Diaries »
Music, Mood, and Mental Health: What Listening Habits Reveal About Wellbeing
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Music, Mood, and Mental Health: What Listening Habits Reveal About Wellbeing
Music is part of everyday life for many people. Some use it to focus while studying, some play it while working, and others listen to… Continue reading on Mediu
Nobody Prepared Me for My First On-Call Rotation. Here’s What I Wished They Had.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Nobody Prepared Me for My First On-Call Rotation. Here’s What I Wished They Had.
The survival kit for the first six months of production ownership that nobody gives you. Continue reading on Stackademic »
What is Ontology — the secret sauce to supercharge the data retrieval?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What is Ontology — the secret sauce to supercharge the data retrieval?
Demystifying Ontology, & comparing it with normal data retrieval. This is also a comparative study of Graph vs. Non-Graph based retrieval. Continue reading on M