Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX
1h 19mIntermediate2023-10-31
Authors
Jermaine McDonald
Course details
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.
Skills covered
Power BIBusiness AnalyticsBusiness IntelligenceData AnalysisCert PrepData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Model the data in the PL-300 exam
- 02 - Before you begin
- 03 - Creating model calculations with DAX
- 04 - Model design best practices
- 05 - Power BI Desktop and the exercise files
1. Tables and Relationships
- 06 - Working with Tables - Best practices
- 07 - One-to-one relationships
- 08 - One-to-many relationships
- 09 - Many-to-many relationships
- 10 - Common pitfalls in creating relationships
2. Functions
- 11 - Recap of functions
- 12 - Row and filter contexts
- 13 - Using the CALCULATE function
- 14 - Creating dates with CALENDAR and CALENDARAUTO
- 15 - Accessing related data with the RELATED function
- 16 - Overriding default relationships with functions
- 17 - Time-intelligence functions
- 18 - Statistical functions
3. Measures
- 19 - Demo - Creating a quick measure in Power BI
- 20 - Demo - Creating a full measure
- 21 - Demo - Semi-additive measures
- 22 - Calculated columns vs. measures
- 23 - Implicit vs. explicit measures
- 24 - Work with aggregations
- 25 - Demo - Calculated tables
Conclusion
- 26 - Next steps