- Module 1: Scalable data models enable enterprise-scale analytics in Power BI. Implement data modeling best practices, use large dataset storage format, and practice building a star schema to design analytics solutions that can scale.
By the end of this module, you’ll be able to:
- Describe the importance of building scalable data models
- Implement Power BI data modeling best practices
- Use the Power BI large dataset storage format
- Module 2: Power BI model relationships form the basis of a tabular model. Define Power BI model relationships, set up relationships, recognize DAX relationship functions, and describe relationship evaluation.
By the end of this module, you’ll be able to:
- Understand how model relationship work.
- Set up relationships.
- Use DAX relationship functions.
- Understand relationship evaluation.
- Module 3: Use tools to optimize Power BI performance
After completing this module, you'll be able to:
- Optimize queries using performance analyzer.
- Troubleshoot DAX performance using DAX Studio.
- Optimize a data model using Tabular Editor.
- Module 4: Enforce model security in Power BI using row-level security and object-level security.
By the end of this module, you’ll be able to:
- Restrict access to Power BI model data with RLS.
- Restrict access to Power BI model objects with OLS.
- Apply good development practices to enforce Power BI model security.
Work with semantic models in Microsoft Fabric
Overview
Syllabus
- Module 1: Module 1: Understand scalability in Power BI
- Introduction
- Describe the significance of scalable models
- Implement Power BI data modeling best practices
- Configure large datasets
- Exercise: Create a star schema model
- Knowledge check
- Summary
- Module 2: Module 2: Create Power BI model relationships
- Introduction
- Understand model relationships
- Set up relationships
- Use DAX relationship functions
- Understand relationship evaluation
- Exercise: Work with model relationships
- Knowledge check
- Summary
- Module 3: Module 3: Use tools to optimize Power BI performance
- Introduction
- Use Performance analyzer
- Troubleshoot DAX performance by using DAX Studio
- Optimize a data model by using Best Practice Analyzer
- Exercise: Use tools to optimize Power BI performance
- Knowledge check
- Summary
- Module 4: Module 4: Enforce Power BI model security
- Introduction
- Restrict access to Power BI model data
- Restrict access to Power BI model objects
- Apply good modeling practices
- Exercise: Enforce model security
- Knowledge check
- Summary
