Get this course

Departmental Skills → Data & BI → Internal

Multidimensional Schemas and Slowly Changing Dimensions (BII04)


Description
Multidimensional Schema is specially designed to model data warehouse systems. The schemas are designed to address the unique needs of very large databases designed for analytical purposes (OLAP).

In this course, we will explain Star and Snowflake schema along with Galaxy and Star Cluster Schema and venture into Slowly Changing Dimensions (SCD) Types

1 Hour | Videos and Readings
Content
  • Multidimensional Schemas
  • Intro & Star Schema
  • Snowflake Schema
  • Galaxy and Star Cluster
  • Multidimensional Schemas Summary
  • Slowly Changing Dimensions
  • What are slowly changing dimensions?
  • SCD Summary
Completion rules
  • All units must be completed
Back