Welcome to dbt@scale¶
A two-day hands-on workshop where you tackle a real-world dbt project under the hood of MediaPulse - a fictional media conglomerate built to break in exactly the ways real data warehouses do.
Who's in the room¶
| Role | Organisation |
|---|---|
| Participants & host | DPG |
| Facilitation & analytics engineering | Xebia |
| dbt expertise & talks | dbt Labs |
What you'll do¶
You'll work in one of four groups, each with a dedicated slice of the MediaPulse dbt project to explore, fix, and extend. Every group shares the same codebase but focuses on different dbt concepts and different parts of the data platform.
| Group | Level | Theme |
|---|---|---|
| Group 1 | Intermediate | Testing · Sources · Jinja & Macros |
| Group 2 | Advanced I | Seeds · Snapshots · Test review |
| Group 3 | Advanced II | Incremental models · Singular tests · Revenue analytics |
| Group 4 | Power Users | dbt-project-evaluator · dbt-expectations · CI/CD |
How to use this guide¶
- Use the top navigation tabs to jump between sections.
- Each group has an Overview (context + learning objectives) and a Checklist (step-by-step tasks).
- Checklist steps include collapsible hints - try the task first, then expand the hint if you're stuck.
- The MediaPulse Project page documents the shared codebase: schemas, known bugs, and the overall structure.
Ground rules¶
- Collaborate freely within your group; share discoveries across groups.
- The bugs are intentional - finding them is part of the exercise.
- There is no single right answer for design decisions. Be ready to defend your choices.
- Ask facilitators for a nudge, not for the answer.