Tech Skills

Data Analytics & Business Intelligence

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

9,907
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 712 reads from curated sources

Python for Data Analytics: A Beginner’s Complete Guide
Dev.to · Audrine Marion 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Python for Data Analytics: A Beginner’s Complete Guide
In today’s digital world, data has become one of the most valuable resources. Every time we shop...
Python and Its Role in Data Analytics: A Beginner-Friendly Guide Using Logistics Data
Dev.to · NelimaL 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Python and Its Role in Data Analytics: A Beginner-Friendly Guide Using Logistics Data
Introduction In today’s digital economy, organizations generate huge amounts of data every...
Python and how Python is used in the data analytics space.
Dev.to · Jesse Ngugi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Python and how Python is used in the data analytics space.
Hey there! If you've ever looked at a massive spreadsheet and felt overwhelmed, or wondered how...
A Practical Guide to Time Series Forecasting for Business: From Raw Data to Reliable Predictions
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
A Practical Guide to Time Series Forecasting for Business: From Raw Data to Reliable Predictions
“Prediction is very difficult, especially if it’s about the future.” — Niels Bohr Continue reading on Medium »
File Compaction in Delta Lake: The Art of Right-Sizing Your Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
File Compaction in Delta Lake: The Art of Right-Sizing Your Data
The Small File Problem: A Data Engineer’s Nightmare Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Wallet Clustering Is Reshaping Privacy in Web3
Wallet clustering has quietly become one of the most important layers of modern blockchain intelligence. Continue reading on Medium »
The Epistemology of Prediction Markets Reflexivity, Financialized Truth, and the Oracle Paradox
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The Epistemology of Prediction Markets Reflexivity, Financialized Truth, and the Oracle Paradox
Author: Nicholas Michael Grossi, N.M.G., Axiom Hive Continue reading on Medium »
You Don’t Need More Python Courses. You Need This One Skill.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
You Don’t Need More Python Courses. You Need This One Skill.
The uncomfortable truth about why learners plateau — and what actually moves the needle Continue reading on Medium »
SQL Query Execution and Indexing — How Databases Optimize Queries at Scale
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
SQL Query Execution and Indexing — How Databases Optimize Queries at Scale
Understanding query optimization, indexing, and how databases process millions of records at scale Continue reading on Medium »
SQL Query Execution and Indexing — How Databases Optimize Queries at Scale
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
SQL Query Execution and Indexing — How Databases Optimize Queries at Scale
Understanding query optimization, indexing, and how databases process millions of records at scale Continue reading on Medium »
User Research and Analytics: Beats by Dre
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
User Research and Analytics: Beats by Dre
Analyzing consumer insights and creating a strategic launch for the next generation of Beats speakers. Continue reading on Medium »
The Hidden Language People Speak Every Day — And Why Most of Us Miss It
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The Hidden Language People Speak Every Day — And Why Most of Us Miss It
We Are Trained to Trust Words Too Easily Continue reading on The Gravity »
Understanding Python’s dict vs collections.defaultdict: A Comprehensive Guide
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Understanding Python’s dict vs collections.defaultdict: A Comprehensive Guide
Stop writing repetitive key-existence checks. There’s a better way. Continue reading on Medium »
I Tracked Skin Changes for 4,300 Days — From Archive to Dataset to Recovery Model
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
I Tracked Skin Changes for 4,300 Days — From Archive to Dataset to Recovery Model
What began as a personal archive slowly became a long-term observation dataset. Continue reading on Medium »
Apache NiFi a quick guide
Dev.to · Manoj 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Apache NiFi a quick guide
A comprehensive reference covering concepts, architecture, components, ecosystem alternatives, and...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Decision debt… how poor data practices destroy AI value
The tax that erodes even the most AI projects Continue reading on Medium »
Stop Uploading Your Data to AI Chatbots
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Stop Uploading Your Data to AI Chatbots
You have a spreadsheet with ten thousand rows of sales data. Customer names. Purchase amounts. Dates. Locations. You want to find trends… Continue reading on Me
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
The RED FLAG in US Life Insurance.
RED FLAG. US Life Insurers have $2.4T (7.5% of US GDP) — sitting in private credit and offshore reinsurance. The red flag — visible stress… Continue reading on
SHAP in Tactical Analytics: Explaining Defensive Behavior
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
SHAP in Tactical Analytics: Explaining Defensive Behavior
Your model predicted it. Now you have to explain it to a coach. Continue reading on Medium »
Data Modeling in Power BI: Joins, Relationships, and Schemas Explained
Dev.to · Cynthia Sophie Mwangi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Data Modeling in Power BI: Joins, Relationships, and Schemas Explained
Introduction Data Modeling, the beginning of making sense out of data. This is one of the...
Analyzing Steam Games 2025: Genres, Players and User Ratings
Dev.to · Daniel Sánchez Moares 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Analyzing Steam Games 2025: Genres, Players and User Ratings
As part of my Master in Data Science & AI at Evolve, I worked on a data analysis project using a...
What are the main components of Data Science?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
What are the main components of Data Science?
Data Science is made up of several important components that work together to collect, process, analyze, and interpret data for better… Continue reading on Medi
Mengapa Data Cleaning di Excel Sering Tidak Efisien?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Mengapa Data Cleaning di Excel Sering Tidak Efisien?
Salah satu alasan utama Excel kurang efisien untuk data cleaning adalah karena prosesnya masih sangat manual dan memakan waktu. Pengguna… Continue reading on Me
Everyone Builds a Churn Model. Almost Nobody Reduces Churn.
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Everyone Builds a Churn Model. Almost Nobody Reduces Churn.
Why predicting who leaves is the easy part — and what most data teams get wrong after that Continue reading on Medium »
Everyone Builds a Churn Model. Almost Nobody Reduces Churn.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Everyone Builds a Churn Model. Almost Nobody Reduces Churn.
Why predicting who leaves is the easy part — and what most data teams get wrong after that Continue reading on Medium »
I Used Python and AI to Clean 64,000 Government Records — Here’s What Sydney’s Economy Told Me
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
I Used Python and AI to Clean 64,000 Government Records — Here’s What Sydney’s Economy Told Me
A data analyst’s honest walkthrough of messy open data, AI-assisted cleaning, and the urban insights hiding inside a spreadsheet Continue reading on Medium »
I Used Python and AI to Clean 64,000 Government Records — Here’s What Sydney’s Economy Told Me
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
I Used Python and AI to Clean 64,000 Government Records — Here’s What Sydney’s Economy Told Me
A data analyst’s honest walkthrough of messy open data, AI-assisted cleaning, and the urban insights hiding inside a spreadsheet Continue reading on Medium »
Transform Logistics Data Into Profitable Decisions with Intersect Analytics
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Transform Logistics Data Into Profitable Decisions with Intersect Analytics
At Intersect Analytics, we help logistics and supply chain businesses turn complex operational data into powerful business intelligence… Continue reading on Med
This Intraday Trading Strategy Gives 95% Good Results
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
This Intraday Trading Strategy Gives 95% Good Results
AA Pro Entry Engine + EWO Strategy: A Complete Guide for Smarter Trend Trading Continue reading on Medium »
Your company has more dashboards than decisions. Here’s why.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Your company has more dashboards than decisions. Here’s why.
The $4 trillion bet on data was supposed to end strategic confusion. It industrialized it instead. Continue reading on Medium »
Avi Loeb Analyzes the First UFO File Release
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Avi Loeb Analyzes the First UFO File Release
The United States government has released here its first batch of newly public files on Unidentified Objects (UFO/UAP). These are objects… Continue reading on M
Always, the data is wrong
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Always, the data is wrong
Data-driven decisions Continue reading on Medium »
Google Tag Manager Is Moving Toward a More Unified Tagging Structure. Here’s Why That Matters
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Google Tag Manager Is Moving Toward a More Unified Tagging Structure. Here’s Why That Matters
Google Tag Manager appears to be heading into one of its more meaningful structural updates in years. Continue reading on Medium »
Data Has Its Own Three-Body Problem
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Data Has Its Own Three-Body Problem
I’m not a physicist by training, but I work with a few of them and while I watched the 3-Body Problem on Netflix something struck me… Data… Continue reading on
Data Has Its Own Three-Body Problem
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Data Has Its Own Three-Body Problem
I’m not a physicist by training, but I work with a few of them and while I watched the 3-Body Problem on Netflix something struck me… Data… Continue reading on
Building realistic electric transmission grid dataset at scale: a pipeline from open dataset
Microsoft Research 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Building realistic electric transmission grid dataset at scale: a pipeline from open dataset
Microsoft Research is excited to release an open dataset of approximate transmission topology of the U.S. power grid derived from publicly available data. The a
How I Screened 388 Resumes in Hours (With Python and No ML)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
How I Screened 388 Resumes in Hours (With Python and No ML)
A hiring team had a problem: 388 applicants, a 4-day window, and no tooling to handle it. Someone needed to produce an interview shortlist… Continue reading on
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Statistical Analysis and Risk Modeling of Health Insurance Policyholders
Health insurance companies rely heavily on statistical analysis to make pricing decisions, estimate financial risk, and understand… Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
2026 Hantavirus: Availability Cascade?
History is defined by biological “shocks.” As of May 2026, a cluster of the Andes Hantavirus (ANDV) on a cruise ship in the South Atlantic… Continue reading on
Inferential Statistics in Data Science with Examples | Confidence Interval & Hypothesis Testing…
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Inferential Statistics in Data Science with Examples | Confidence Interval & Hypothesis Testing…
Learn inferential statistics in data science with simple explanations and examples. Continue reading on Medium »
Inferential Statistics in Data Science with Examples | Confidence Interval & Hypothesis Testing…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Inferential Statistics in Data Science with Examples | Confidence Interval & Hypothesis Testing…
Learn inferential statistics in data science with simple explanations and examples. Continue reading on Medium »
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
When Customers Churn at Renewal: Was It the Price or the Project?
A practitioner's guide to causal attribution when two churn drivers arrive at once. The post When Customers Churn at Renewal: Was It the Price or the Project? a
Let’s talk of graves, of worms, and…Radar charts
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Let’s talk of graves, of worms, and…Radar charts
As I’m a product of the online data analysis sphere on Twitter (I refuse to call it X), I’m very well familiar with radar charts and pizza… Continue reading on
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
The Comparator That Fails Us: How Drift in People Becomes Drift in Systems
I. The Individual Operator Continue reading on Medium »
Idempotency in Data Pipelines: How to Prevent Duplicate Records
Dev.to · 137Foundry 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Idempotency in Data Pipelines: How to Prevent Duplicate Records
A pipeline that runs twice should produce the same result as one that runs once. That property is...
How to Build a Dead Letter Queue System for Reliable Data Processing
Dev.to · 137Foundry 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
How to Build a Dead Letter Queue System for Reliable Data Processing
Every data processing system will eventually receive a record it cannot handle. A missing required...
SQL vs NoSQL: Mana yang Lebih Baik untuk Aplikasi Kamu?
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
SQL vs NoSQL: Mana yang Lebih Baik untuk Aplikasi Kamu?
Halo, saya Anjas Rani. Saat pertama kali belajar backend, saya sempat bingung ketika harus memilih database. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Why Data Engineering is the Future of Tech Careers in India
In today’s digital world, companies generate massive amounts of data every second. Continue reading on Medium »