Data Modeling Intensive
KRW 420,000
Star schema thinking, bridge tables, and role-playing dimensions explained with pencil-first sketches.
Modeling mistakes compound quietly. Here you diagram before you click, stress-test grain, and document assumptions your future self will thank you for.
What is included
- Fact table grain exercises with written definitions
- Role-playing dimensions without mystery relationships
- Inactive relationships when you truly need them
- Bridge patterns for multi-value attributes
- Partition guidance for larger imports
- Validation queries you can paste into DAX Studio
Outcomes
- Produce a signed-off model diagram for one subject area
- List three grain risks your team agreed to monitor
- Ship a refreshed model with commented measures
Lead contact
Jiwon Hale
Modeling lead who diagrams grain before opening Power BI.
Questions
Is SQL required?
Helpful but not mandatory. We include optional SQL side notes; Power Query remains the default path.
Do you cover incremental refresh?
At a planning level yes—licensing-dependent features are flagged clearly when they appear.
What data volume should I expect?
Labs stay under a few million rows. Larger sets are discussed conceptually only.
Notes from participants
“Bridge table week mirrored our vendor tagging mess. The sketch-first rule kept the cohort from clicking circles for hours.”
Tuition is informational; enrollment happens after a human reply from [email protected].