Intermediate
Dimensional Data Modeling
Model for analytics engineers who still touch OLTP schemas. Workshops emphasize naming discipline, conformed dimensions, and change capture patterns that survive quarterly planning debates.
Duration: 5 weeks · 36 hours · Format: Studio cohort
Price (informational): ￥164,000
Request information
What is included
- Grain statements that survive stakeholder edits
- SCD2 without silent history loss
- Bridge tables when fan-out is real
- Surrogate keys with operational join safety
- Documentation blocks analysts actually read
Outcomes
- Publish a bus matrix for one product domain
- Defend a grain change with migration sequencing
- Pair with analytics on a conformed dimension PR
Lead contact
Imani Brooks
Analytics engineering lead; former consultant on retail loyalty programs.
FAQ
dbt appears in one module; SQL remains the spine.
We note nested record trade-offs but stay warehouse-agnostic.
No ML feature store design.
Participant notes
Grain worksheet stopped three scope fights. Wish we had another retail example beyond convenience.
Lin · Analytics engineer · 4/5 · survey
SCD2 lab mirrored our subscription changes. Mentor comments referenced our actual column names.
Hiro · Media group