Model data in Power BI
- Offered byMicrosoft
Model data in Power BI at Microsoft Overview
Duration | 6 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Model data in Power BI at Microsoft Course details
- Create common date tables
- Configure many-to-many relationships
- Resolve circular relationships
- Design star schemas
- Discover how context affects DAX measures.
- Use the CALCULATE function to manipulate filters.
- Implement time intelligence by using DAX.
- Optimize DirectQuery models with table level storage.
- Create and manage aggregations.
- In this module, you will learn how to design a data model that is intuitive, high-performing, and simple to maintain
- You will learn about using DAX language to create measures
- Those measures will help you create a wide variety of analytic solutions
- Additionally, you'll learn how to improve performance with your Power Query data retrieval tasks
Model data in Power BI at Microsoft Curriculum
Design a data model in Power BI
Introduction
Work with tables
Create a date table
Work with dimensions
Define data granularity
Work with relationships and cardinality
Resolve modeling challenges
Lab - Model data in Power BI Desktop, Part 1
Lab - Model data in Power BI Desktop, Part 2
Check your knowledge
Summary
Introduction to creating measures using DAX in Power BI
Introduction to DAX
Understand context
Use the Calculate function
Use relationships effectively
Create semi-additive measures
Lab - Introduction to DAX in Power BI Desktop
Work with time intelligence
Lab - Time Intelligence and Measures in DAX
Check your knowledge
Summary
Optimize a model for performance in Power BI
Introduction to performance optimization
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
Check your knowledge
Summary
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?