Learn the fundamental concepts and practical application of Dimensional Modeling using the Kimball Method in this comprehensive tutorial. Explore the importance of data warehouses, understand when to implement them, and discover the key components of dimensional design including dimensions, facts, star schemas, and snowflake schemas. Delve into crucial topics such as surrogate keys, the bus matrix, and the Seven W's of Data Warehouse Design. Gain insights on handling slowly changing dimensions and other essential considerations for effective data warehouse implementation. Master the art of transforming transactional databases into powerful analytical tools through dimensional modeling techniques.
Overview
Syllabus
Dimensional Modeling The Heart of the Data Warehouse
Bryan Cafferky
What's Ahead?
Why a Data Warehouse?
When is it Not Appropriate?
Where do you start to design a data warehouse?
Transactional Database Design (OLTP)
What is Dimensional Modeling?
What's a Dimension?
What's a Fact?
The Star Schema
Star Schema-Key Points
The Snowflake Schema The Snowflake Schema
Why Surrogate Keys?
Steps of Dimensional Modeling Review
The Bus Matrix
The Seven W's of Data Warehouse Design - User Story
Seven W's of Data Warehouse Design and the User Story
Slowly Changing Dimensions
Slowly Changing Dimension-Type 3
Some Additional Thoughts...
Taught by
Bryan Cafferky
