Power BI Advanced

If you've mastered the basics of creating Power BI reports, you may like to find out what else it can do - but you should only consider attending this course if you use Power BI regularly.  Delegates will also learn how to improve the user experience through the use parameter tables, how to customize the data model by including calculated tables; and how to work with advanced visuals and dashboard tiles.

Learn how to create report themes and templates, find out how to use quick measures and bookmarks, delve further into Query Editor and maps, as well as the use of advanced DAX formulas.


What you will learn

•         Create Advanced Power BI Reports

•         Advanced understanding of the data schemas and extracting data

•         Perform advanced transformations of data or any data schema

•         Utilize time-phased data in the creation of complex analyses

•         Create new measures using DAX

•         Explore Data Visualizations

•         Create and publish Reports


Introduction

What you should know

Our project: Creating an advanced Power BI dashboard


Working with Data

Importing online data sources

Uploading from a folder of data 

Querying a database

Importing and transferring data imported from an Excel, CSV, or TXT file


Query Editor 

Introducing Query Editor steps  

Transposing data tables 

Splitting fields and columns         

Formatting data with text formulas

Creating conditional formulas

Creating calculated formulas


DAX Language              

Introducing DAX               

Introducing DAX measures          

Understanding DAX measure logic           

Evaluating DAX measures             

Leveraging the CALCULATE functionality               

Understand how filters work in CALCULATE function       

Leveraging the ALL function

Understanding the FILTER functionality


Introduction to DAX Formulas               

Creating a separate table for measures 

Creating a table using GENERATESERIES formula

Leveraging the POWER function

Leveraging the DIVIDE function

Utilizing the X factor (SUMX, COUNTX, etc.) for ranges

Utilizing quick measures


Advanced DAX Calculations

Creating a date table using a formula

Filtering between tables               

Utilizing IF statements with conditional functions

Introducing the DATEDIFF measure         

Working with disconnected tables           

Leveraging the BLANK function 

Using variables in formulas

DATESBETWEEN and the X functions       

Introducing the DATEADD date calculations         

Introducing the MTD, QTD, and YTD date calculations


Publishing and Sharing

Publish Reports from Power BI Desktop to the Power BI Service

Creating PowerBI dashboards

Print and export Power BI dashboards

Manually Republish and Refresh Your Data

Create a group in Power BI

Introducing Power BI Mobile


Program Details
Duration 2 Days
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom


Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.

Contact