Develop Dynamic Reports with Microsoft Power BI (DP-605)

Course Outline

Take this 1-day Microsoft Power BI course, Develop dynamic reports with Microsoft Power BI (DP-605), and learn to harness the power of Power BI to transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports seamlessly.

Develop Dynamic Reports with Microsoft Power BI (DP-605) Benefits

In this course, you will learn how to:
- Gain proficiency in retrieving data from diverse sources.
- Learn advanced techniques for cleaning and transforming data.
- Master the art of semantic modeling for optimized report performance.
- Enhance report visualization skills for effective data communication.
- Acquire expertise in report filtering and workspace management for streamlined report distribution.
Training Prerequisites

Basic understanding of Data Analytics and Power BI

Develop dynamic reports with Microsoft Power BI (DP-605) Training Outline

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

Exercise - Prepare Data in Power BI Desktop

Check Your Knowledge

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

Exercise - Load Data in Power BI Desktop

Check Your Knowledge

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

Exercise - Model Data in Power BI Desktop

Check Your Knowledge

Add Measures to Power BI Desktop Models

Create Simple Measures
Create Compound Measures
Create Quick Measures
Compare Calculated Columns with Measures
Check Your Knowledge

Exercise - Create DAX Calculations in Power BI Desktop

Add Calculated Tables and Columns to Power BI Desktop Models

Create Calculated Columns
Learn about Row Context
Choose a Technique to Add a Column
Check Your Knowledge

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

Exercise - Design a Report in Power BI Desktop

Check Your Knowledge

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
Check Your Knowledge

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
Check Your Knowledge

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)
Check Your Knowledge