Skip to content

Select a date below

Categories:
Topics:

Dates are listed in Pacific Time Zone

= Guaranteed to run date

Description

Print Friendly, PDF & Email

Overview:

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

Prerequisites:

Basic understanding of Data Analytics and Power BI

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)

Additional information

Length

1 day

Guaranteed to run

Yes