Completed
Dimensional Modeling The Heart of the Data Warehouse
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Dimensional Modeling
Automatically move to the next video in the Classroom when playback concludes
- 1 Dimensional Modeling The Heart of the Data Warehouse
- 2 Bryan Cafferky
- 3 What's Ahead?
- 4 Why a Data Warehouse?
- 5 When is it Not Appropriate?
- 6 Where do you start to design a data warehouse?
- 7 Transactional Database Design (OLTP)
- 8 What is Dimensional Modeling?
- 9 What's a Dimension?
- 10 What's a Fact?
- 11 The Star Schema
- 12 Star Schema-Key Points
- 13 The Snowflake Schema The Snowflake Schema
- 14 Why Surrogate Keys?
- 15 Steps of Dimensional Modeling Review
- 16 The Bus Matrix
- 17 The Seven W's of Data Warehouse Design - User Story
- 18 Seven W's of Data Warehouse Design and the User Story
- 19 Slowly Changing Dimensions
- 20 Slowly Changing Dimension-Type 3
- 21 Some Additional Thoughts...
