DP-605T00 Develop dynamic reports with Microsoft Power BI

Introduction:

Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.

Objectives:

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)

Enroll in this course

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

CAD Canadian dollar