Roadmap · stage 4/13

Warehousing

Stage 4 of 13 · 25 resources · 2 categories

What this stage is

Warehousing is stage 4 of 13 in the DE//AGENT roadmap. It currently holds 25 resources: 10 tutorials, 3 skills, 3 patterns across 2 categories.

What it teaches

Dimensional modelling, dbt and serving reliable metrics.

What you can do after this stage

Model a star schema with a declared grain
Gate a change on data-aware CI

Exit gate

Gate: You can serve a metric that analysts trust. The stage deliverable: pattern-dimensional-model.

Gates are self-assessed — the roadmap does not track your progress; it tells you what to be able to do before moving on.

Categories in this stage

Data Warehouses (5), dbt (20)

Registry resources for this stage

Sorted by composite score — provenance, completeness and trust, per the scoring model:

Resource	Type	Difficulty	Verification	Score
dbt Test Writer	Skill	beginner	community	40.5
dbt Model Review	Skill	intermediate	community	40.5
dbt MCP Server	MCP server	intermediate	community	38.2
Warehouse Clustering Advisor	Skill	advanced	community	36.5
dbt as Models + Tests + Docs	Pattern	beginner	community	35.75
Dimensional Model (star schema)	Pattern	intermediate	community	34.75
Data Vault (hubs, links, satellites)	Pattern	advanced	community	34.75
Run the dbt warehouse tests starter end to end	Tutorial	beginner	community	34.15
The warehouse mental model — micro-partitions, clustering, scan vs compute	Tutorial	beginner	community	34.15
Write the minimum dbt test set for a model	Tutorial	beginner	community	34.15
Capstone — the warehousing checklist, end to end	Tutorial	intermediate	community	34.15
Incident — the dashboard query that went slow	Tutorial	intermediate	community	34.15
Make queries prune — clustering keys and scan diagnosis	Tutorial	intermediate	community	34.15
Model a star schema — facts, conformed dimensions, declared grain	Tutorial	intermediate	community	34.15
Review a dbt model PR before merge	Tutorial	intermediate	community	34.15
Run dbt model review and tests from the workbench plugin	Tutorial	intermediate	community	34.15
Warehouse production gotchas — cost, full refreshes, late data	Tutorial	advanced	community	34.15
dbt → warehouse → tests → docs	Project	beginner	community	32.65
dbt Full-Refresh Guard	Hook	intermediate	community	32.6
Warehouse query is slow	Runbook	intermediate	community	29.25
Warehouse Explorer	Plugin	intermediate	community	28.6
dbt Workbench	Plugin	intermediate	community	28.1
dbt Project Template	Template	beginner	community	28.1
dbt Best Practices Guide	Reference	—	community	27.7
dbt Documentation	Reference	—	community	27.7

Documented learning objectives

Rank tests by the cost of the failure they prevent
Write a custom singular test
Wire freshness on a source
State a model's grain and match it to its unique key test
Choose table vs incremental vs view deliberately
Handle late data in an incremental model
Separate scan inefficiency from compute inefficiency
Choose a clustering key from predicate selectivity

Continue the progression

← Data Processing · Lakehouse →

← Full roadmap · All learning topics