// course
Warehouse Modeling Clinic
Star/snowflake tradeoffs, slowly changing dimensions, and naming that survives audits.
Data Instructor-led cohort · 7 weeks ₫10,500,000 (info only)
Overview
Uses anonymized retail schemas. You will not get production credentials — instead, local DuckDB scenarios.
Included modules
- SCD Type 2 walkthrough with timelines
- Surrogate key discipline drills
- Fact table grain exercises
- Naming convention workshop
- Incremental model sketching
- Lineage diagram practice
- Review with a guest architect
Outcomes
- Produce a dimensional model diagram
- Write a grain statement stakeholders accept
- List three audit risks you will monitor
FAQ
Concepts apply broadly; labs use DuckDB locally.
Participant notes
Warehouse Modeling Clinic clarified grain arguments we were glossing over in client decks.