When it comes to building up a new [[Data Warehouse]] - here's a general process: 1. Select a business process to model - A natural business activity supported by a *data-collection* system: e.g. inventory, order management, finance 2. declare the **grain** of the business process - how much *detail* do you need - i.e. "by store, by item, by date, by promotion" 3. choose dimensions that apply to each fact table row 4. identify the numeric facts that will populate each fact table row **** # More ## Source - Grad School