Dimensional Modeling: Step 5

• FINISH MODEL AND SANITY CHECK

• • Finish the STAR SCHEMA and build the DIMENSIONAL MODEL
  • SANITY CHECK 1: Source Data?
  • • Document the PSEUDO-ETL, a simple logical description of how you take your data in your source system and turn it into the dimension or fact.
    • Verifies that there’s not a “missing” piece of data that makes the model useful.
  • SANITY CHECK 2: Can you write SQL/MDX against your model?
  • • Run through your mock up reports, and free text questions.
    • Mentally walk through your reports, and ensure you can answer your reports from this model