- Module 1: 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 2: By the end of this module, you'll learn the meaning of time intelligence and how to add time intelligence DAX calculations to your model. These calculations will include year-to-date (YTD), year-over-year (YoY) growth, and others.
By the end of this module, you'll be able to:
- Define time intelligence.
- Use common DAX time intelligence functions.
- Create useful intelligence calculations.
- Module 3: Create calculation groups
After completing this module, you will be able to:
- Explore how calculation groups work.
- Maintain calculation groups in a model.
- Use calculation groups in a Power BI report.
- 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.
- Module 5: 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.
Overview
Syllabus
- Module 1: Module 1: 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 2: Module 2: Use DAX time intelligence functions in Power BI Desktop models
- Introduction
- Use DAX time intelligence functions
- Additional time intelligence calculations
- Exercise - Create Advanced DAX Calculations in Power BI Desktop
- Check your knowledge
- Summary
- Module 3: Module 3: Create calculation groups
- Introduction
- Understand calculation groups
- Explore calculation groups features and usage
- Create calculation groups in a model
- Exercise: Create calculation groups
- 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
- Module 5: Module 5: 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
