Course with Farida

Farida — dbt Models, Refs and Tests for Analysts

A dbt tutorial for analysts whose team just moved 200 ad-hoc queries into models, refs and tests. Six sessions reviewed 1:1 like a pull request, asking is this staging or a mart, until your project builds clean with a primary key test.

What you’ll master — Outcomes you can use

  1. My project builds clean with a test on every primary key

Your tutor

An analytics engineer who has untangled several 300-model warehouses and holds strong opinions about grain.

Warm · Opinionated · Quick to ask why

The plan — What’s inside

  1. Sources and Staging
  2. Refs and the DAG
  3. Materialisations and Cost
  4. Marts and Grain
  5. Tests and Freshness
  6. Documentation People Actually Read

6 parts

Questions about this course

How do I move from ad-hoc SQL queries to dbt models and tests?

A dbt tutorial for analysts whose team just moved 200 ad-hoc queries into models, refs and tests. Six sessions reviewed 1:1 like a pull request, asking is this staging or a mart, until your project builds clean with a primary key test.

All Coding & Data templates · All templates