Log On/Register  

855.838.5028

Mastering Power BI

Duration: 2 Days
Course Price: $1,295

Take your Power BI skills to the next level. Create stunning dashboards that link to many reports. Drill down into your data with intelligent visuals and slicers. Create insightful business models with DAX expressions, and master Time Intelligence. KPI's, Pivot Tables, and custom visuals deliver your message efficiently and professionally. Learn how to create a well-designed report or dashboard using all Power BI has to offer.  

 

Target Audience: Power BI users who want to take their understanding to the next level.  

Take your Power BI skills to the next level. Create stunning dashboards that link to many reports. Drill down into your data with intelligent visuals and slicers. Create insightful business models with DAX expressions, and master Time Intelligence. KPI's, Pivot Tables, and custom visuals deliver your message efficiently and professionally. Learn how to create a well-designed report or dashboard using all Power BI has to offer.  

 

Target Audience: Power BI users who want to take their understanding to the next level.  

Prerequisites: Power BI Essentials, or general understanding of the topics covered. Excel Day 2 or a general understanding of Pivot Tables. Excel Day 3 or a general understanding of Excel Functions.  

 

Software: Excel 2013 or later 

Advanced Data Modelling 

Concepts 

  • Pivot Table filtering 
  • How the DAX engine works 

Using ALL with CALCULATE 

Disconnected Tables & Slicers 

Threshold Slicers 

Order of Operations of "PowerPivot" engine 

Time Intelligent DAX Functions 

Conditional DAX Functions 

CalculationX Functions 

Text Functions 

Top 10 Lists 

Pattern Matching with Wildcards 

Relationships Complicated Relationships 

  • Differing Granularities 

Connecting to Various Database Sources 

  • SharePoint 
  • Azure 
  • Local on Prem SQL 

 

Advanced Querying 

Creating Index Columns 

Conditional Columns 

Query Parameters 

Using M Language for Advanced Querying 

  • Custom Functions 

Un-Pivot Data 

Grouping Data 

Aggregating Data 

Re-Using Query Script 

 

Advanced Visualizations 

Power BI's Custom Visuals 

Advanced Mapping Strategies 

Editing Interactions 

Using the R Language Platform 

Publishing Excel items to Power BI Online  

  • Pivot Tables 
  • Charts 
  • KPIs 

Using OLAP Toolsin Pivot Tables 

Extracting Pivot Generated Data 

Re-Using Pivot Functions Elsewhere 

 

Distribution 

Mobile Device Report Design 

Using Content Packs 

Page Level Filters & Row Level Security 

Sharing with QR Codes 

Alerts and KPI's 

Publishing to Various Places" 

  • SharePoint 
  • WebPage 
  • Hosting on your Desktop 
  • Local Intranet / Shared Drives 

 

 

 

 

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):