Big Data & Business Analytics, zero to expert

🧭

1. Data-Driven Decisions: From Question to Answer

Follow Alpenkorb's new head of growth from a vague question to a one-page budget memo, with real SQL on real-sized data in every lesson.

8 lessons · 101 min · Beginner

Free

📐

2. Data Literacy & KPI Design

Read numbers critically and define KPIs that two analysts compute the same way, with Alpenkorb's first dashboard as the case.

8 lessons · 101 min · Beginner

🔒

🧱

3. Data Types, Tables & Data Models

Keys, types, facts, dimensions and grain: the structure behind every correct number, checked with SQL on Alpenkorb's tables.

8 lessons · 100 min · Beginner

🔒

🗄️

4. SQL Basics: SELECT, WHERE, ORDER BY

Choose columns, filter rows, handle NULL, sort, calculate and work with dates, on the real Alpenkorb product and order tables.

8 lessons · 97 min · Beginner

🔒

📊

5. Aggregation & GROUP BY

Turn Alpenkorb's orders into report-ready totals, averages, shares and rates, and learn the mistakes that make totals quietly wrong.

8 lessons · 98 min · Beginner

🔒

🔗

6. JOINs: Combining Tables

Put Alpenkorb's customers, orders, lines, products and campaigns together without losing rows or counting them twice.

8 lessons · 104 min · Intermediate

🔒

🧩

7. Subqueries & CTEs

Break Alpenkorb's harder questions into named steps: subqueries, EXISTS, derived tables, CTE pipelines, recursive calendars and a debugging routine.

8 lessons · 106 min · Intermediate

🔒

🪟

8. Window Functions

Rankings, running totals, moving averages and period-over-period changes on Alpenkorb's orders, without losing a single row.

8 lessons · 99 min · Intermediate

🔒

🧰

9. Advanced SQL for Analytics

Date spines, pivots, text cleaning, JSON, subtotals, sampling, percentiles and query plans, on Alpenkorb's real-sized data.

8 lessons · 98 min · Intermediate

🔒

🐍

10. Python Essentials for Analysts

Values, loops, functions, dates and files: the plain Python an analyst needs before pandas, practised on Alpenkorb's real order data.

8 lessons · 89 min · Beginner

🔒

🐼

11. pandas: DataFrames

Load, filter, derive, sort and summarise Alpenkorb's orders with pandas, and learn the traps that make wrong numbers look right.

8 lessons · 89 min · Beginner

🔒

🧹

12. Data Cleaning & Preparation

Turn Alpenkorb's messy CRM export back into 1,554 customers with pandas, one checked and repeatable step at a time.

8 lessons · 91 min · Intermediate

🔒

🔍

13. Exploratory Data Analysis

Group, bin, correlate, resample and follow cohorts in pandas, then turn what you found into questions worth answering.

8 lessons · 92 min · Intermediate

🔒

🐘

14. What Makes Data "Big"

Measure volume, storage and cost on a million rows in your browser, and choose the simplest tool that really works.

8 lessons · 100 min · Intermediate

🔒

⚡

15. Distributed Processing: Spark Concepts

Learn how Spark splits, shuffles and plans work, and rehearse every idea with runnable Python and DuckDB labs.

8 lessons · 104 min · Intermediate

🔒

🏛️

16. Data Warehouses & Lakehouses

Model Alpenkorb for analysis, build bronze, silver and gold layers in SQL, and reason about partitions and cloud costs.

8 lessons · 109 min · Intermediate

🔒

🔄

17. ETL/ELT & Data Pipelines

Move Alpenkorb's data safely: idempotent loads, change data capture, contracts, backfills and a DAG run order in Python.

8 lessons · 111 min · Intermediate

🔒

🛠️

18. Analytics Engineering with dbt

Models, refs, tests, incremental loads and snapshots, practised as the SQL dbt compiles, on Alpenkorb's data.

8 lessons · 100 min · Advanced

🔒

⚡

19. Streaming & Real-Time Analytics

Event time, Kafka partitions, windows, watermarks and exactly-once, simulated on an Alpenkorb clickstream in SQL and pandas.

8 lessons · 98 min · Advanced

🔒

🛡️

20. Data Quality & Governance

Measure quality with SQL, catch broken metrics, know who owns what, and handle personal data with care.

8 lessons · 93 min · Advanced

🔒

👥

21. Customer Analytics: Cohorts, Retention & CLV

Follow customers from their first order, measure retention and churn honestly, and put a value on each segment.

8 lessons · 93 min · Advanced

🔒

📣

22. Marketing & Product Analytics

Funnels, sessions, attribution, ROAS, adoption and retention on Alpenkorb data, and the biases that make them lie.

8 lessons · 97 min · Advanced

🔒

🧪

23. A/B Testing & Experimentation

Design, size, analyse and report experiments by hand, from the hypothesis to a readout that survives a sceptical reader.

8 lessons · 102 min · Advanced

🔒

📈

24. Forecasting & Time Series

Trend, seasonality and noise, honest baselines, MAE and MAPE on a hold-out, regression features, intervals and a demand plan.

8 lessons · 94 min · Advanced

🔒

🤖

25. Predictive Analytics & Machine Learning Basics

Define a target without leakage, fit linear and logistic regression in NumPy, grow a Gini stump, and judge models against simple rules.

8 lessons · 96 min · Advanced

🔒

📊

26. Dashboards & Data Storytelling

Build the exact tables behind KPI cards, trends and breakdowns, catch misleading visuals by arithmetic, and turn a quarter into a board-ready page.

8 lessons · 97 min · Advanced

🔒

🚚

27. Operations & Supply Chain Analytics

Measure stock, delivery, capacity and cost-to-serve with SQL and pandas, and know which assumptions each formula makes.

8 lessons · 99 min · Advanced

🔒

💹

28. Finance & Pricing Analytics

Build the P&L from order data, find where margin is made and lost, and test prices, discounts, budgets and scenarios.

8 lessons · 97 min · Advanced

🔒

🤖

29. AI & LLMs in Analytics

Use AI tools for data work without trusting them blindly: verify generated SQL, evaluate classifiers, protect personal data and know the rules.

8 lessons · 96 min · Advanced

🔒

🎓

30. Capstone: A Full Analytics Project

Take Alpenkorb's Q2 2026 budget question from scoping and data audit to a model, cohorts, a test plan, a forecast and a decision log.

8 lessons · 117 min · Advanced

🔒