Data TransformationBeginner → AdvancedNEW

dbt: Analytics Engineering

Master dbt from fundamentals to production — models, sources, refs, materializations, testing, documentation, Jinja macros, snapshots, CI/CD deployment, and Airflow integration.

4.9rating0 students4h total4 lessons

Start Course

What you'll learn

Set up a dbt project with correct folder structure and profiles

Write staging, intermediate, and mart models using ref() and source()

Choose between view, table, incremental, and ephemeral materializations

Test data quality with schema tests, singular tests, and dbt-expectations

Document models with schema.yml and generate living data docs

Write Jinja macros for reusable SQL logic

Use snapshots for SCD Type 2 history tracking

Deploy dbt with slim CI (state:modified) and GitHub Actions

Final Project

Build a full analytics data model: bronze sources → silver staging → gold mart with full test coverage and CI pipeline

Curriculum

4 lessons · 4h

dbt Fundamentals: Models, Sources, Refs, and Materializations

55 min

Testing & Documentation: Schema Tests and Data Docs

45 min

Jinja Macros, Snapshots, and Advanced Patterns

45 min

dbt in Production: CI/CD, Airflow, and Environments

40 min

Course Info

Lessons4 lessons

Total time4h

LevelBeginner → Advanced

Students0

Rating4.9 / 5.0

Start Course — Free