Introduction to Data Modeling

Data Modeling - What do you need to get started

Module 01 - Course Introduction 10 min.

Module 02A - Modeling Methodologies (Transactional Model) 14 min.

Module 02B - Modeling Methodologies (Dimensional Model) 19 min.

Module 03 - Transactional Model Design 18 min.

Module 04 - Dimensional Model Design 16 min.

Module 05A - Defining the Business Process (Planning a Project) 25 min.

Module 05B - Defining the Business Process (Declaring the Grain) 24 min.

Module 06A - Dimension Design (Dimension Types) 36 min.

Module 06B - Dimension Design (Conformed Dimensions) 14 min.

Module 06C - Dimension Design (Junk Dimensions) 9 min.

Module 06D - Dimension Design (Degenerate Dimensions) 7 min.

Module 06E - Dimension Design (Role Playing Dimensions) 9 min.

Module 06F - Dimension Design (Creating Dimensions) 12 min.

Module 06G - Dimension Design (Creating a Customer Dimension) 21 min.

Module 07A - Fact Design (Transaction Facts) 20 min.

Module 07B - Fact Design (Periodic Snapshot) 14 min.

Module 07C - Fact Design (Accumulating Snapshot) 7 min.

Module 08A - Relationships (Overview) 24 min.

Module 08B - Relationships (Many to Many - Double Counting) 14 min.

Module 08C - Relationships (Hierarchy and Parent-Child) 9 min.

Module 09A - Advanced Data Modeling Techniques (Overview) 21 min.

Module 09B - Advanced Data Modeling Techniques (Allocated Facts) 12 min.

Module 09C - Advanced Data Modeling Techniques (Other Dimensions) 14 min.

Module 10A - Designing for Business Intelligence (ETL Considerations) 17 min.

Module 10B - Designing for Business Intelligence (SSAS Consideration) 7 min.