01 — Guided Learning
Chapter 11 is a 10% major Fundamentals domain. Learn it as one operating system rather than a bag of warehouse vocabulary.
Ten-lesson route
- BI, DW, Data Warehousing & Principles
- Inmon / Corporate Information Factory
- Kimball, Facts, Dimensions & the Bus
- Architecture, Storage Roles & History
- Historical Loads, CDC & Low Latency
- Requirements, Mapping, DQ & Population
- BI Portfolio, Users, OLAP & Self-Service
- Data Product Lifecycle & Operations
- Metadata, Lineage & Trust
- Governance, Acceptance & Metrics
What to be able to teach after the route
Explain why the correct Chapter 11 answer normally follows this order:
What decision must the business make? → what history/grain/freshness is required? → what can the sources actually provide? → which architectural role fits? → how will data be integrated and loaded? → how will users consume it? → how will meaning/provenance/security be controlled? → how will it be released and supported? → how will value be measured?
This order prevents three common failures: tool-first design, architecture-name memorization without decision logic, and treating go-live as the end of DW/BI management.