Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Data Warehouse Design

Data Warehouse Design 

Learning data warehouse design is actually learning data modeling.

A very common approach of designing the data warehouse is Dimensional Modeling.

Typical artifact in data warehouse model

Here are the design patterns or tips I identified after studying the various books and reviewing the data warehouses.
Design Tip: Key for the Date Dimension

Design Tip: Use minidimension to handle rapidly changing monster dimension