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

Focused View

Jermaine McDonald

1:18:36

47 View

01 - Introduction

01 - Model the data in the PL-300 exam.mp4

00:49

02 - Before you begin.mp4

01:19

03 - Creating model calculations with DAX.mp4

03:29

04 - Model design best practices.mp4

02:58

05 - Power BI Desktop and the exercise files.mp4

01:37

02 - 1. Tables and Relationships

01 - Working with Tables Best practices.mp4

03:45

02 - One-to-one relationships.mp4

03:46

03 - One-to-many relationships.mp4

03:24

04 - Many-to-many relationships.mp4

02:27

05 - Common pitfalls in creating relationships.mp4

03:35

03 - 2. Functions

01 - Recap of functions.mp4

02:24

02 - Row and filter contexts.mp4

06:58

03 - Using the CALCULATE function.mp4

02:44

04 - Creating dates with CALENDAR and CALENDARAUTO.mp4

03:48

05 - Accessing related data with the RELATED function.mp4

02:22

06 - Overriding default relationships with functions.mp4

02:44

07 - Time-intelligence functions.mp4

04:37

08 - Statistical functions.mp4

03:48

04 - 3. Measures

01 - Demo Creating a quick measure in Power BI.mp4

03:47

02 - Demo Creating a full measure.mp4

06:44

03 - Demo Semi-additive measures.mp4

02:56

04 - Calculated columns vs. measures.mp4

02:33

05 - Implicit vs. explicit measures.mp4

01:27

06 - Work with aggregations.mp4

02:02

07 - Demo Calculated tables.mp4

01:40

05 - Conclusion

01 - Next steps.mp4

00:53

Description

The Power BI Data Analyst Associate certification is intended for data professionals who leverage Microsoft's Power BI data tool. This course is part of a series of courses designed to prepare for the Microsoft Power BI Data Analyst PL-300 exam. In this course, instructor Jermaine McDonald covers the exam topics relating to creating model calculations using the DAX modeling languages. Jermaine takes you step-by-step through three core areas you need to know for the exam: tables and relationships, functions, and measures. Learn about the different aspects of creating model calculations with DAX, including working with tables, unlocking the power of relationships, and common pitfalls in designing these relationshipsI. Get an overview of the functions used in DAX, with examples of how they work and relevant tips for the exam. Finally learn to create quick and full measures, decide between measures and calculated columns, and ways Power BI makes it easy to work with for data analysis.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

DAX

Jermaine McDonald

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.