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



drill-through


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


SAMEPERIODLASTYEAR Function


PARALLELPERIOD Function



Advanced DAX 


measures table


understanding row/filter context


COMBINED function


RANKX Function


FILTER Function


CROSSFILTER 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