BEGINNER · 8 MODULES · 64 LESSONS
dbt and Analytics Engineering
Turn scattered SQL transformations into a versioned, tested, and documented data project with dbt that runs end to end with a single command.
- For you if
- You write transformation SQL by hand, in loose scripts, with no tests or version control.
- By the end
- You'll know how to build dbt models, write data tests, track history with snapshots, and run reliable incremental loads.
- You need
- Intermediate SQL, a dimensional model (star schema), and Python 3.13 or 3.14. Everything runs locally for free.

Curriculum
02Sources And Staging Models
- Module introduction: from a toy model to Kiosko's real data
- Declaring Kiosko's raw data as sources
- The `source()` function and why it matters
- Reading files directly with `external_location`
- Staging models: one model per source table
- Naming staging models: the `stg_` prefix
- Building `stg_orders` and `stg_events`
- Mini-project: Kiosko's complete staging layer
03Ref Marts And Materializations
- Module overview: from staging views to the star schema with `ref()`
- The `ref()` function and the DAG it builds
- Materializations: `view` versus `table`
- Rebuilding `dim_store` and `dim_date`
- Rebuilding `fact_orders` with `ref()`
- Choosing materializations for Kiosko
- Inspecting the DAG with `dbt ls`
- Mini-project: Kiosko's star schema in dbt
04Testing Your Models
- Module overview: from a star schema that runs to a star schema you trust
- What a data test actually checks
- Generic tests: `unique` and `not_null` on `fact_orders`
- Generic tests: `accepted_values` and `relationships`
- Writing your own generic test: `test_is_positive`
- Singular tests for business rules
- Reading `dbt test`'s report
- Mini-project: Kiosko's test suite
05Snapshots And Scd Type 2
- Module overview: from a star schema you trust to a star schema that remembers its past
- What a dbt snapshot actually does
- `timestamp` vs `check`: a snapshot's two strategies
- Configuring `dim_product_snapshot`
- Running the first snapshot
- Changing the source and snapshotting again
- Querying the historized `dim_product`
- Mini-project: Kiosko's SCD type 2 in dbt
06Incremental Models And Idempotency
07Macros Docs And Lineage
08Project Kioskos Dbt Warehouse
Reviews
What students say
These reviews are from enrolled students who completed at least 50% of the course. We moderate reviews only on content grounds (spam, offensive language, personal data), never for being critical or negative.
No approved reviews yet.
Be the first to share your experience!