Instiq

2Model the data

Practice questions →Glossary →
  • 2.1Design a data model

    Understand star schema, table/column properties, role-playing dimensions, relationship cardinality and cross-filter direction, a common date table, and calculated columns/tables.

  • 2.2Create calculations with DAX

    Understand measures vs calculated columns, aggregation measures, CALCULATE, time intelligence, statistical/semi-additive, quick measures, and calculation groups.

  • 2.3Optimize model performance

    Understand optimizing the model by removing unnecessary rows/columns, identifying slow elements with Performance Analyzer and DAX query view, and reducing granularity.