Model data with Power BI
- Offered byMicrosoft
Model data with Power BI at Microsoft Overview
Duration | 3 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
- Overview
- Course Details
- Curriculum
- Entry Requirements
Model data with Power BI at Microsoft Course details
- Describe Power BI Desktop models
- Choose a Power BI model framework
- Design a data model in Power BI
- Add measures to Power BI Desktop models
- Add calculated tables and columns to Power BI Desktop models
- Learn what a Power BI data model is, which data loading approach to use, and how to build out your data model to get the insights you need
- In this course, you'll learn about the Power BI Desktop model structure, star schema design basics, analytics queries, and report visual configuration
- This course provides a strong foundation on which you can learn to optimize model designs and add model calculations
- Describe model frameworks, their benefits and limitations, and features to help optimize your Power BI data models
- You'll start by creating simple measures, which summarize a single column or table
Model data with Power BI at Microsoft Curriculum
Describe Power BI Desktop models
Introduction
Star schema design
Analytic queries
Configure report visuals
Check your knowledge
Summary
Choose a Power BI model framework
Introduction
Describe Power BI model fundamentals
Determine when to develop an import model
Determine when to develop a DirectQuery model
Determine when to develop a composite model
Choose a model framework
Knowledge check
Summary
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
Exercise - Model data in Power BI Desktop, Part 1
Check your knowledge
Summary
Add measures to Power BI Desktop models
Introduction
Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
Check your knowledge
Summary
Add calculated tables and columns to Power BI Desktop models
Introduction
Create calculated columns
Learn about row context
Choose a technique to add a column
Check your knowledge
Summary
Model data with Power BI at Microsoft Entry Requirements
- There are no prerequisites for this learning path.
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?