Microsoft Power BI Desktop Intermediate

Course Overview

Microsoft Power BI Desktop Intermediate

Course overview

Develop further knowledge of Power BI examining how to connect to data, view report data and use bookmarks. Additionally, time will be spent looking at row level security, publishing and an introduction to DAX.

Course content

Connecting to data:

• Importing from folders
• Creating dependent and duplicate data sources
• Creating aggregated (grouped) data sources
• Import, direct query and dual mode
• Pivoting data
• Creating custom calculations

Viewing Report Data:

• Data drill-through
• Grouping data
• Creating spotlights and focus

Using report bookmarks:

• Creating bookmarks
• Inserting buttons
• Using buttons and bookmarks to create different views

Row Level Security:

• How to set up row level security

Publishing and the Power BI Service:

• Power BI dashboards
• Sharing dashboards and reports
• Scheduling report refreshes
• Security for row level security reports
• Creating apps

DAX:

• Calculate function
• The importance of a date table
• Time Intelligence
• Using DAX for conditional formatting
• Using variables in DAX