Steps of Dimensional Modeling

Identify the Business Processes

Identify the Facts and Dimensions in your Dimensional Data Model

Define the Grain

Identify the Attributes / Keys for Dimensions

Build the Schema

Store Historical Info

Last updated