Dimensional Modeling: Step 4

• REFINE MODEL AND IDENTIFIY HIERARCHIES

• • Use feedback from the business users to further refine additional FACT measures (Revenue, Profit, Cost of Goods, etc).
  • Grab other attributes close
  • • Product Short Name  Product Long Name.
    • Country Name  Country ISO code.
  • FIND HIERARCHIES
  • • Requirements are good place to find them.
    • SOURCE SYSTEM MASTER/DETAIL is a good indicator of hierarchical data.