Advanced

Dimensional Modeling and Slowly Changing Dimensions

A star schema splits data into facts (the events, one row per measurement) and dimensions (the descriptive context). The hard part is not the shape, it is grain: stating what one fact row represents before you write anything, because getting that wrong is what makes every number downstream quietly incorrect.

Unlock the full curriculum — ₹2,000 / $25every concept + every answer · 6 months · no auto-renew

RELATED CONCEPTS

Lakehouse, Delta and the Medallion Architecture ETL vs ELT The Ontology (Semantic Layer)Data Quality and Validation Query Optimization and Execution Plans

LESSONS THAT TEACH THIS

Foundations of Forward Deployed EngineeringShape the tables so nobody has to ask you for the number16 min→The FDE EngagementThe join that is right 94% of the time is the whole engagement16 min→

PRACTICE THIS IN REAL QUESTIONS

SQL & Data EngineeringExplain Snowflake micro-partitions and clustering, and when a bigger warehouse will NOT make a query faster.→SQL & Data EngineeringHow do you size Snowflake warehouses, when do you scale up vs scale out, and how do you keep the bill sane?→System Design & Production EngineeringDecompose: design a system to detect credit-card fraud.→System Design & Production EngineeringDecompose: design a system to coordinate disaster response for a city.→System Design & Production EngineeringDecompose: merge patient records across a network of hospitals.→SQL & Data EngineeringDesign a star schema for a ride-sharing company's analytics.→