Tech Skills

Data Analytics & Business Intelligence

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

14,268
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 (4,806) Articles (2188)Blog Posts (2249)Tutorials (312)Research Papers (30)News (27)
Segmentasi Pelanggan dan Prediksi Nilai Belanja pada Online Retail II Menggunakan K-Means dan…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Segmentasi Pelanggan dan Prediksi Nilai Belanja pada Online Retail II Menggunakan K-Means dan…
Pendahuluan Bisnis online retail hidup dari transaksi. Namun transaksi mentah belum otomatis memberi arah bisnis. Di dalam satu juta lebih… Continue reading on
Web Scraping: What It Is, Why It Matters, and How to Use It Responsibly
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Web Scraping: What It Is, Why It Matters, and How to Use It Responsibly
A practical guide to web scraping: how it works, why businesses use it, where it becomes difficult, and how to approach it responsibly. Continue reading on Medi
Best Data Science Institute in South Delhi
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Best Data Science Institute in South Delhi
Start your Data Science career with an Advanced Data Science Course in South Delhi. Learn from industry experts, work on live projects… Continue reading on Medi
KPIs That Matter: Choosing Metrics That Drive Business Decisions
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
KPIs That Matter: Choosing Metrics That Drive Business Decisions
One of the biggest mistakes new data analysts make is assuming that every metric is equally important. Continue reading on Medium »
Understanding Parquet: The File Format Built for Analytics
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Understanding Parquet: The File Format Built for Analytics
A beginner-friendly explanation of columnar storage, compression, schemas, and why Parquet is widely used in modern data platforms. Continue reading on Stackade
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Veri analizi projelerinde çoğu zaman “ne oldu?” sorusuna cevap ararız. Continue reading on Medium »
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Veri analizi projelerinde çoğu zaman “ne oldu?” sorusuna cevap ararız. Continue reading on Medium »
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Veri analizi projelerinde çoğu zaman “ne oldu?” sorusuna cevap ararız. Continue reading on Medium »
Looking for the Best Data Science Institute in South Delhi
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Looking for the Best Data Science Institute in South Delhi
Data Science is one of the fastest-growing career fields because today every business, from startups to large enterprises, generates a… Continue reading on Medi
Verinin Müşteriyle Buluştuğu Nokta: CRM Analitiği ve Müşteri Yaşam Boyu Değeri (Bölüm 1)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Verinin Müşteriyle Buluştuğu Nokta: CRM Analitiği ve Müşteri Yaşam Boyu Değeri (Bölüm 1)
Günümüz iş dünyasında en çok duyduğumuz cümlelerden biri şudur: “Yeni bir müşteri edinmek, var olan müşteriyi elde tutmaktan çok daha… Continue reading on Mediu
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Top 5 DBMS Concepts (2026) | Perfectnotes
Every single application you use — from Instagram to your online banking portal — runs on data. Continue reading on Medium »
Python ve Rust’ın Gücüyle Gerçek Zamanlı Veri İşleme: Bytewax Nedir?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Python ve Rust’ın Gücüyle Gerçek Zamanlı Veri İşleme: Bytewax Nedir?
Veri mühendisliği tarafında gerçek zamanlı veri (streaming) işleme süreçleriyle uğraşırken genellikle Apache Spark Structured Streaming… Continue reading on Med
How We Helped an Auto Parts Plant Cut MES Query Times by Up to 116x
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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
Every Dataset Has a Personality Disorder
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 »
The Nervous System of the Telco: Unlocking the Real-Time Power of the Network Element Interfaces…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 »
Enhanced RFM Analysis for Customer Segmentation using K-Prototypes
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 1d 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 »
Data Cleaning Fundamentals: Building a Reproducible Data Cleaning Pipeline
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 »
Data Cleaning Fundamentals: Building a Reproducible Data Cleaning Pipeline
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 »
Analysis on Customer Churn
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Analysis on Customer Churn
1. Business Problem Worth Solving Continue reading on Medium »
Bridging the Lab-Software Gap
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d ago
Bridging the Lab-Software Gap
What scientists need that engineers don’t understand Continue reading on Medium »
You’ve Been A Data Analyst Your Whole Life — You Just Didn’t Know It
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 »
Vanity Metrics vs. Actionable Metrics: A Framework for Knowing the Difference
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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
Building an End-to-End Lakehouse on Databricks: Instacart Analytics from Pipeline to Insight
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 »
Beyond the Credit Score: What 1.3 Million Loans Reveal About Who Actually Repays
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 »
Beyond the Credit Score: What 1.3 Million Loans Reveal About Who Actually Repays
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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 »
Where Does the Crowd Excel? Polymarket Accuracy by Category
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1d 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
Customer, Product, and Profitability Performance Analysis in Supply Chain Operations: A Case Study…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 »
Customer, Product, and Profitability Performance Analysis in Supply Chain Operations: A Case Study…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 »
I Didn’t Notice the Compounding Until the Last Day”
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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
I Spent 3 Months Using Extended Thinking in Production. Here’s When It Actually Helps.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 »
I Spent 3 Months Using Extended Thinking in Production. Here’s When It Actually Helps.
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 »
Institutional Compression: Why Models Fail to Match Reality
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 »
Microsoft Says Its GPU-Accelerated Warehouse Is Up to 7x Faster. Here’s How to Read That Benchmark.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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
It’s Not the Cow, It’s the How: What 60 Years of Food Data Say About the Climate Cost of Dinner
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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
It’s Not the Cow, It’s the How: What 60 Years of Food Data Say About the Climate Cost of Dinner
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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
We Built a Live World Cup 2026 Dashboard in Markdown
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
We Built a Live World Cup 2026 Dashboard in Markdown
104 matches, 48 nations, one trophy. Continue reading on Medium »
A/B Testing Statistics: P-Values, Confidence Intervals, and What They Actually Mean
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 2d 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
Garbage In, Garbage Out: Why AI Depends on Clean Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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
Understanding NetCDF: The Data Format Behind Climate and Satellite Science
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 »
The Skill That Separates Senior Data Scientists From Everyone Else
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 »
The Biotech Translation Gap: Where Clinical Success, Capital, and Unmet Need Diverge
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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
Data Centers: Balancing Perspectives in Local Political Debates
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Data Centers: Balancing Perspectives in Local Political Debates
The current debate suffers from a basic analytical flaw. Continue reading on Medium »
Solving the E-Commerce Fit Problem: My First End-to-End DataOps Pipeline
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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
Apache Spark Joins Explained: Everything You Need to Know About Strategies, Types, Execution Plans…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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
Um Pipeline para uma ONG: Transformei Dados do Instagram Em Recomendações
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 »
Who Finances the World?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Who Finances the World?
A Practical Guide to Global Capital, Debt Markets and Financial Systems Continue reading on Medium »