Intermediate
dbt & Analytics Engineering
A practitioner's tour of dbt and the analytics engineering discipline it created: what analytics engineering is and why it sits between data engineering and analysts, how ref() and source() build a dependency DAG out of plain SQL, the four materializations and when each one earns its cost, incremental model strategies (merge vs insert_overwrite, unique_key, is_incremental()) with a worked example, the testing and documentation layers that make a warehouse trustworthy, and the staging/intermediate/marts project structure nearly every serious dbt project converges on.
25 min
