Dimensional Modeling

Dimensional Modeling

Bryan Cafferky via YouTube Direct link

Why a Data Warehouse?

4 of 21

4 of 21

Why a Data Warehouse?

Class Central Classrooms beta

YouTube playlists curated by Class Central.

Classroom Contents

Dimensional Modeling

Automatically move to the next video in the Classroom when playback concludes

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.