Course Description
Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.
Course Outline
1 - Get data in Power BI
-
Get data from files
-
Get data from relational data sources
-
Create dynamic reports with parameters
-
Get data from a NoSQL database
-
Get data from online services
-
Select a storage mode
-
Get data from Azure Analysis Services
-
Fix performance issues
-
Resolve data import errors
2 - Clean, transform, and load data in Power BI
-
Shape the initial data
-
Simplify the data structure
-
Evaluate and change column data types
-
Combine multiple tables into a single table
-
Profile data in Power BI
-
Use Advanced Editor to modify M code
3 - Design a semantic model in Power BI
-
Work with tables
-
Create a date table
-
Work with dimensions
-
Define data granularity
-
Work with relationships and cardinality
-
Resolve modeling challenges
4 - Add measures to Power BI Desktop models
-
Create simple measures
-
Create compound measures
-
Create quick measures
-
Compare calculated columns with measures
5 - Add calculated tables and columns to Power BI Desktop models
-
Create calculated columns
-
Learn about row context
-
Choose a technique to add a column
6 - Design Power BI reports
-
Design the analytical report layout
-
Design visually appealing reports
-
Report objects
-
Select report visuals
-
Select report visuals to suit the report layout
-
Format and configure visualizations
-
Work with key performance indicators
7 - Configure Power BI report filters
-
Introduction to designing reports for filtering
-
Apply filters to the report structure
-
Apply filters with slicers
-
Design reports with advanced filtering techniques
-
Consumption-time filtering
-
Select report filter techniques
-
Case study - Configure report filters based on feedback
8 - Create and manage workspaces in Power BI
-
Distribute a report or dashboard
-
Monitor usage and performance
-
Recommend a development life cycle strategy
-
Troubleshoot data by viewing its lineage
-
Configure data protection
9 - Manage semantic models in Power BI
-
Use a Power BI gateway to connect to on-premises data sources
-
Configure a semantic model scheduled refresh
-
Configure incremental refresh settings
-
Manage and promote semantic models
-
Troubleshoot service connectivity
-
Boost performance with query caching (Premium)
Course Prerequisites
- Basic understanding of Data Analytics and Power BI
Course Information
Length: 1 day
Format: Lecture and Lab
Delivery Method: n/a
Max. Capacity: 16
Schedule
Contact Us
