Status: planned. This page intentionally does not present Snowflake or dbt as professional experience. The project will be updated as the lab is actually built.
Planned architecture
Synthetic source data
↓
Snowflake RAW
↓
dbt STAGING
↓
dbt INTERMEDIATE
↓
Analytics MARTS
↓
Power BI / documented analysis
What I will demonstrate
- Warehouse organization and role of raw, staging, intermediate, and mart layers.
- dbt models, tests, documentation, and lineage.
- Dimensional modeling for reusable business metrics.
- SQL transformations and data-quality checks.
- A small BI layer using the curated analytical models.
Evidence to be published
GitHub code, architecture notes, dbt documentation screenshots, model lineage, test results, and a walkthrough of key design decisions.