Dimensional Modeling: Step 2

• FIND PATTERNS

• • Begin to identify the WHAT’s and the BY’s
  • WHAT = FACT (measures)
  • BY = DIMENSION
  • • Examples:
    • • I would like to know what is the proportion of Sales by my different product groups and customer types.
      • What is the proportion of revenue that comes from repeat versus first time customers.
      • What is the profile of customers (profile = Location, Income, and Gender) that make up 80% of my actual Profit as opposed to 80% of revenue.
  • Develop a rough dimensional model
  • • Meant to help PROTOTYPE reports