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

LinkedIn Learning

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

via LinkedIn Learning

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.