Power BI Level 3 Advanced Reports - 3-days (24 hours)
Laptops are provided to use with on-site, classroom training
Everyone receives a physical workbook, 24 hours, $225 per person per day

Day 1 - Import Data

Explanation of Power BI and Dashboards

Import data from Excel, text, CSV files, OneDrive, and SharePoint Lists

Connect to Shared Datasets

Import data from multiple files at once

Manually create tables, Create custom columns

Duplicate, Append, Merge queries, Grouping Queries

Change Data Source Settings                                                                                           

Create Dataflows

Day 2 - Model Data

Design a data model

Manage relationships between tables

Hide Items in Report View

Product and corporate hierarchies

DAX Calculated Columns and Measures

DAX measures: SUM, CALCULATE, CALENDAR, CALENDARAUTO, WEEKDAY, COUNTROWS, TODAY, NOW, SAMEPERIODLASTYEAR, DATESBETWEEN, DATESMTD, RELATED, CONTAINS, SUMX, AVERAGEX, DATEDIFF, DATEVALUE, BLANK, ISBLANK, PATH, LOOKUPVALUE, SWITCH, RANKX, ALLSELECTED, ALL, CROSSFILTER, FILTER, SUMMARIZECOLUMNS, TOPN, USERELATIONSHIP

DAX Folders

Move Measures Easily, create Variables in Measures

Profile and Examine Data

Day 3 - Visualize and Share Reports
Create Reports

Making buttons and bookmarks

Sync Slicers

Custom background

Create column charts, decomposition tree, and slicers

Conditional Formatting in Visuals

Create workspaces, settings

Publish reports in Power BI Services

Create Dashboards

Configure Data Gateway

Promote and Certify Datasets

Set Alerts when Reports Change

Personalize Visuals

View lineage

Schedule auto refreshes of datasets

Share reports through Power BI Services, in Teams, SharePoint and Mobile

Row Level Security

Roles in Power BI services