‘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...

Dimensionality Modeling

Dimensions are the foundation of the fact table, and is where the data for the fact table is collected. Typically dimensions are nouns like date, store, inventory etc. These dimensions are where all the data is stored. For example, the date dimension could contain...

OLTP System vs Data Warehousing

OLTP System Data Warehouse Operational User Managerial Users (Decision Makers) Operational Strategic Decision Pattern – predictable Pattern – unpredictable Record transaction (e.g. student enrolment) Analysis Basis Transactional Data Details to summary...