← PL-300 study guideNext domain
Domain 2 – Model the Data (25–30%)
8 lessons, each ending with a practice scenario (Pro)
Log in to save your progress.
- ✓2.1 — Configure Table and Column PropertiesProperties are set in Model view (or the Data view and Column tools ribbon) in the Properties pane. They don't change the data. They change how fields behave and look for everyone who builds reports on the model.Scenario: Pro
- ✓2.2 — Relationships, Cardinality, Cross-Filter Direction and Role-Playing DimensionsA relationship lets filters on one table reach another. You create it by dragging one column onto another in Model view, or with Manage relationships.Scenario: Pro
- ✓2.3 — Create a Common Date TableAlmost every model needs one shared date table related to every fact table's date column. It gives consistent years, quarters, months and fiscal periods across facts, and DAX time intelligence functions (lesson 2.6) rely on it.Scenario: Pro
- ✓2.4 — Measures, Calculated Columns and Calculated TablesDAX can create three kinds of objects. Choosing the right one is a frequent exam question. Calculated, Context, Stored in the model, Responds to slicers, Use on axes, slicers, rows of a matrix, Example.Scenario: Pro
- ✓2.5 — Single Aggregation Measures and the CALCULATE FunctionUse an iterator when the value must be computed per row first: Revenue = SUMX(Sales, Sales[Quantity] Sales[Unit Price]). This avoids storing a calculated column.Scenario: Pro
- ✓2.6 — Time Intelligence and Semi-Additive MeasuresTime intelligence functions shift or extend the dates in the filter context. They need a proper date table (lesson 2.3): contiguous, related to the fact table, and marked as a date table.Scenario: Pro
- ✓2.7 — Statistical Functions, Quick Measures and Calculation GroupsRank products by sales, keeping the rank stable when a product is filtered out of the visual.Scenario: Pro
- ✓2.8 — Optimize Model PerformanceSlow reports usually come from one of three places: a model that's too big, inefficient DAX, or too many or too heavy visuals. The exam expects you to find the cause with the right tool, then fix it.Scenario: Pro
Domain recapQuick overview of all lessons
- Configure table and column properties, relationships, cardinality and cross-filter direction
- Implement role-playing dimensions and a common date table
- Choose between measures, calculated columns and calculated tables
- Write DAX with CALCULATE, time intelligence, statistical and semi-additive functions
- Use quick measures and calculation groups
- Optimize model performance with Performance Analyzer, DAX query view and lower granularity
Domain 3: Visualize and analyze the data →