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...
Description:
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.