Power BI Data Analyst Associate (PL-300) Cert Prep: Designing and Developing a Power BI Data Model
1h 26mIntermediate2023-07-27
Authors
Emilio Melo
Cloud solutions architect with 20+ years of IT experience
Course details
The Power BI Data Analyst Associate certification verifies your capabilities as a data analyst professional to leverage the Microsoft Power BI data tool. This course is part of a larger series designed to prepare you for the Microsoft PL-300 certification exam. Join instructor Emilio Melo as he explores the skills you need to know to get ready to tackle the official exam. In this course, Emilio shows you how to design Power BI data models, including working with star and snowflake schemas, filtering out unnecessary data, and configuring metadata. He then describes how to work with relationships on a data model, from creating and configuring relationships to configuring cross-filter direction, working with date tables, working with role-playing dimensions, and more.
Skills covered
Power BIBusiness AnalyticsBusiness IntelligenceData AnalysisCert PrepData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Designing and developing a Power BI data model
- 02 - Overview of the Power BI data analyst certification
1. Designing a Power BI Data Model
- 03 - Understanding data models
- 04 - Star and snowflake schemas
- 05 - Filtering out unnecessary data
- 06 - Report granularity
- 07 - Configuring metadata
- 08 - Manipulating tables on a Power BI data model
- 09 - Configuring table and column properties
2. Working with Relationships
- 10 - Creating and configuring relationships
- 11 - Configuring cross-filter direction
- 12 - Working with date tables
- 13 - Role-playing dimensions on Power BI
- 14 - Configuring relationships
- 15 - Working with role-playing dimensions
Conclusion
- 16 - Power BI - Additional resources