Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

via LinkedIn Learning

Go to class Write review

Overview

Prepare for the Power BI Data Analyst Associate (PL-300) exam in this course, with topics pertaining to creating model calculations using DAX.

Syllabus

Introduction

Model the data in the PL-300 exam
Before you begin
Creating model calculations with DAX
Model design best practices
Power BI Desktop and the exercise files

1. Tables and Relationships

Working with Tables: Best practices
One-to-one relationships
One-to-many relationships
Many-to-many relationships
Common pitfalls in creating relationships

2. Functions

Recap of functions
Row and filter contexts
Using the CALCULATE function
Creating dates with CALENDAR and CALENDARAUTO
Accessing related data with the RELATED function
Overriding default relationships with functions
Time-intelligence functions
Statistical functions

3. Measures

Demo: Creating a quick measure in Power BI
Demo: Creating a full measure
Demo: Semi-additive measures
Calculated columns vs. measures
Implicit vs. explicit measures
Work with aggregations
Demo: Calculated tables

Conclusion

Next steps

Taught by

Jermaine McDonald

Reviews

4.6 rating at LinkedIn Learning based on 134 ratings

Start your review of Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX