Introduction to dbt Core

dbt Setup for Azure PostgreSQL

SQL and Jinja Templating

dbt Tests

Incremental Models, Docs, and Snapshots

Building Your First Mart

Practice

Assignment

Gotchas & Pitfalls

Week 10 Lesson Plan (Teachers)

Building Your First Mart

Content coming soon...

Suggested Topics

• What a mart is: a business-ready, query-optimized model for end users
• Designing a mart from Week 9 modeling concepts: choosing grain, keys, and measures
• Building a mart model that references staging models using ref()
• Adding tests and documentation to your mart
• Materializing as a table vs a view: trade-offs for dashboard performance
• Connecting the mart to the data that your ingestion pipeline loads
• Verifying your mart with analytical queries before handing it to a dashboard
• The mart as a contract: how downstream consumers depend on stable column names and types

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.