Create and transform columns
Design a star schema that contains facts and dimensions
Identify when to use reference or duplicate queries and the resulting impact
Identify and create appropriate keys for relationships
Configure data loading for queries
Configure table and column properties
Implement role-playing dimensions
Define a relationship’s cardinality and cross-filter direction
Create a common date table
Implement row-level security roles
Create single aggregation measures
Use CALCULATE to manipulate filters
Implement time intelligence measures
Identify implicit measures and replace with explicit measures