Master dimensional modeling with facts, dimensions, and grains : the foundation of analytical data warehousing and lakehouse design.
How data modeling changes in a lakehouse architecture : schema-on-read, partition evolution, and building virtual semantic layers with Medallion Architecture.
Compare star schema and snowflake schema designs , when to denormalize for speed vs. normalize for storage, with practical examples and decision criteria.
Understand conceptual, logical, and physical data models : what each level contains, who owns it, and how they connect from business requirements.
