All Episodes

Displaying 21–40 of 87 in total

Building Fact and Dimension Tables

This episode focuses on a practical PL-300 objective: Building Fact and Dimension Tables. Fact tables represent measurable business events, while dimension tables prov...

Preventing Duplicate Facts and Modeling the Correct Grain

This episode focuses on a practical PL-300 objective: Preventing Duplicate Facts and Modeling the Correct Grain. A model can return inflated totals when table grain or...

Choosing Reference vs. Duplicate Queries

This episode focuses on a practical PL-300 objective: Choosing Reference vs. Duplicate Queries. A referenced query remains dependent on the output of its source query,...

Merging Queries to Enrich Data

This episode focuses on a practical PL-300 objective: Merging Queries to Enrich Data. Merging queries joins columns from related tables, so key selection, match behavi...

Appending Queries to Combine Similar Tables

This episode focuses on a practical PL-300 objective: Appending Queries to Combine Similar Tables. Appending queries stacks rows from structurally similar tables, maki...

Identifying and Creating Relationship Keys

This episode focuses on a practical PL-300 objective: Identifying and Creating Relationship Keys. Relationship keys must uniquely and consistently identify the intende...

Configuring Query Data Loading

This episode focuses on a practical PL-300 objective: Configuring Query Data Loading. Intermediate Power Query results can support later queries without all being load...

Configuring Table and Column Properties

This episode focuses on a practical PL-300 objective: Configuring Table and Column Properties. Table and column properties help preserve meaning through names, formatt...

Designing Relationships for Correct Filter Behavior

This episode focuses on a practical PL-300 objective: Designing Relationships for Correct Filter Behavior. Semantic-model relationships must produce the intended filte...

Implementing Role-Playing Dimensions

This episode focuses on a practical PL-300 objective: Implementing Role-Playing Dimensions. Role-playing dimensions let one dimension, such as Date, support different ...

Defining Relationship Cardinality

This episode focuses on a practical PL-300 objective: Defining Relationship Cardinality. Relationship cardinality must match the real uniqueness and grain on both side...

Configuring Cross-Filter Direction

This episode focuses on a practical PL-300 objective: Configuring Cross-Filter Direction. Cross-filter direction determines how filter context propagates through a mod...

Creating a Common Date Table

This episode focuses on a practical PL-300 objective: Creating a Common Date Table. A common date table provides a consistent calendar for multiple analyses and suppor...

Choosing the Right Calculation Layer

This episode focuses on a practical PL-300 objective: Choosing the Right Calculation Layer. A correct result can still live in the wrong layer, so analysts must decide...

Creating Calculated Columns

This episode focuses on a practical PL-300 objective: Creating Calculated Columns. Calculated columns create row-level model values that can be used in slicers, groupi...

Creating Calculated Tables

This episode focuses on a practical PL-300 objective: Creating Calculated Tables. Calculated tables are derived inside the semantic model with DAX and should be chosen...

Creating Basic DAX Measures

This episode focuses on a practical PL-300 objective: Creating Basic DAX Measures. DAX measures define reusable business metrics that are evaluated under the current f...

Using CALCULATE to Modify Filter Context

This episode focuses on a practical PL-300 objective: Using CALCULATE to Modify Filter Context. CALCULATE evaluates an expression in a modified filter context, making ...

Removing and Replacing Filters with CALCULATE

This episode focuses on a practical PL-300 objective: Removing and Replacing Filters with CALCULATE. Using CALCULATE effectively requires deciding which filters should...

Implementing Time Intelligence Measures

This episode focuses on a practical PL-300 objective: Implementing Time Intelligence Measures. Time-intelligence measures depend on a trustworthy calendar and relation...

Broadcast by