Introduction
  • Introduction
  • Raw data and course activities
  • Keep Fact and Dimension tables separate
  • Before you forget
  • Keep the structure simple - From Snowflake to star
  • Always Format measures
  • Always use a date table 1. Turn off Auto date tables
  • Always use a date table 2. Create a date table on the fly with Power query
  • Always use a date table 3. Mark a date table as a date table
  • Hide Fields
  • Document measures using Tool-tips
  • Do not Transform data using DAX
  • Conclusion