Design Methodology

• Choosing the process

• Choosing the grain

• Identifying and conforming the dimensions

• Choosing the facts

• Store pre-calculations in the fact table

• Rounding out the dimension tables

• Choosing the duration of the database

• Tracking slowly changing dimensions

• Deciding the query priorities and modes