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