‘Nine-Step Methodology’ includes following steps:
„ Choosing the process
„ Choosing the grain
„ Identifying and conforming the dimensions
„ Choosing the facts
„ Storing 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 the query modes

9 step to design data warehouse