Category
dbt, modeling, and the modern data stack.
What dbt actually does and why teams adopt it: the staging, intermediate, and marts layering pattern, a worked model, and how tests and docs turn raw SQL into a trustworthy product.
When a sales rep changes team, should last quarter's numbers move with them? That question decides your dimension design. Type 1 versus Type 2 in plain terms, the join mistake that silently loses rows, and how dbt snapshots handle it.
Most dbt test suites are green and catch nothing. The four generic tests that earn their place, how to assert your model's grain, writing business-specific tests for reconciliation and freshness, and using severity so people keep paying attention.