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...