Microsoft Power BI Cookbook

Four-step dimensional design process

1. Choose the business process
   • The number and nature of processes to include depends on the scale of the sources and scope of the project
   • In this example, the chosen processes are Internet Sales, Reseller Sales, and General Ledger
2. Declare the granularity
   • For each business process (or fact) to be modeled from step 1, define the meaning of each row:
     • These should be clear, concise business definitions--each fact table should only contain one grain
     • Consider scalability limitations with Power BI Desktop and balance the needs between detail and history (for example, greater history but lower granularity)
     • Example: One Row per Sales Order Line, One Row per GL Account Balance per fiscal period

Separate ...