Microsoft Power BI Advanced - 1 Day Course - Brisbane, Odyssey Training (RACQ Building), Monday, 09. December 2019

This course is ideal for
Power BI users who wish to learn more that focus on building your knowledge and understanding of the DAX language, as well as the Power Query M language. Gain insight into context, and what is the right context to build the visuals in your reports. Extend your knowledge of available visuals, and how to make them more compelling and meaningful.

What you will learn

Advanced Data Refreshing

Advanced Report features

Advanced Power Query M Language

Time Intelligence Functions

Advanced DAX

Advanced Data Source Relationships

Installing Custom Visuals

Topics covered in this training course

Advanced Data Refreshing

Understanding what data can be refreshed

Understanding gateways

Requirements for setting up a gateway

Configuring a gateway

Advanced Report features


custom Tooltip pages

grouping and binning

creating a colour theme/template

Advanced Power Query M Language

advanced Query Editor

create a date table in Power Query

when to use M and when to use DAX

Time Intelligence Functions

Dynamic date ranges

DATEADD Function



Advanced DAX 

measures table

understanding row/filter context

COMBINED function

RANKX Function

FILTER Function


RELATED Function

LOOKUP Function

DAX Text Functions

using variables in DAX Functions

Advanced Data Source Relationship

Bridging Tables

handling bad data relationships

Installing Custom Visuals

aster plot

sankey plot

radar chart

requirements to make custom visuals

Monday, 09. December 2019, Odyssey Training (RACQ Building), Microsoft Power BI Advanced - 1 Day Course - Brisbane

Find more interesting events
Get event recommendations based on your Facebook taste. Get it now!Show me the suitable events for meNot now