Data Modeling
Module 01 - Course Introduction 
Module 02A - Modeling Methodologies (Transactional Model) 
Module 02B - Modeling Methodologies (Dimensional Model) 
Module 03 - Transactional Model Design 
Module 04 - Dimensional Model Design 
Module 05A - Defining the Business Process (Planning a Project) 
Module 05B - Defining the Business Process (Declaring the Grain) 
Module 06A - Dimension Design (Dimension Types) 
Module 06B - Dimension Design (Conformed Dimensions) 
Module 06C - Dimension Design (Junk Dimensions) 
Module 06D - Dimension Design (Degenerate Dimensions) 
Module 06E - Dimension Design (Role Playing Dimensions) 
Module 06F - Dimension Design (Creating Dimensions) 
Module 06G - Dimension Design (Creating a Customer Dimension) 
Module 07A - Fact Design (Transaction Facts) 
Module 07B - Fact Design (Periodic Snapshot) 
Module 07C - Fact Design (Accumulating Snapshot) 
Module 08A - Relationships (Overview) 
Module 08B - Relationships (Many to Many - Double Counting) 
Module 08C - Relationships (Hierarchy and Parent-Child) 
Module 09A - Advanced Data Modeling Techniques (Overview) 
Module 09B - Advanced Data Modeling Techniques (Allocated Facts) 
Module 09C - Advanced Data Modeling Techniques (Other Dimensions) 
Module 10A - Designing for Business Intelligence (ETL Considerations) 
Module 10B - Designing for Business Intelligence (SSAS Consideration) ​