Data Modeling
Modeling Management Reporting Layers
Design star schemas and composite models that stay fast under real management hierarchies.
₩4,500,000 · informational until contracted
- Duration
- 6 sessions over three weeks
- Format
- Live cohort
- Facilitator
- Marcus Yim
Program narrative
Attendees refactor brittle flat files into resilient models, introduce role-playing dimensions carefully, and validate performance with realistic row counts. The tone stays practical: fewer clever tricks, more maintainable structures your successors can inherit.
Inclusions
- Fact table grain decisions with workshop critiques
- Bridge tables for slowly changing attributes
- Query folding checks for direct query sources
- Aggregations where they genuinely help
- Documentation embedded in extended properties
- Office hours on participant models
Participant questions
Do we cover Dataflow Gen2?
Where relevant to staging; primary focus remains model design inside Power BI Desktop and service governance.
Is DAX depth included?
Yes, targeted patterns for time intelligence and semi-additive measures; it is not an exhaustive DAX encyclopedia.
What if our warehouse forbids direct query?
We discuss import-mode trade-offs and incremental refresh plans; engineering outside Power BI is not built for you.
Recent cohort notes
The grain decision worksheet alone saved us from another half-built conformed dimension.