Guided path

Analytics Engineering

From your first SELECT statement to a tested, documented dbt pipeline. Work through the steps in order, or jump to what you need. Tick each one off as you go - your progress is saved in this browser, no account needed.

0 / 9 steps complete

Query

SQL basicsSELECT, WHERE, GROUP BY - the language every query starts with.

You are hereGo →

Grain and joinsWhat a single row means, and how to combine tables without breaking it.

Go →

Model

Facts and dimensionsThe two table shapes behind almost every analytics model.

Staging, intermediate, martsHow a dbt project is organized into clean, predictable layers.

Go →

Build

dbt modelsTurn SQL files into a managed, dependency-aware pipeline.

Go →

dbt testsCatch broken data before it ever reaches a dashboard.

Go →

dbt docsDocument models so the next person - including future you - can follow them.

Go →

Incremental modelsProcess only what changed instead of rebuilding the whole table.

Go →

Final projectPut it together on a realistic, end-to-end scenario.

Go →