This course is aimed at experienced Power BI users who want to expand on their knowledge of working with external applications and Power BI.

  • Power Query M Language
  • Advanced DAX
  • Workflows
  • R Script and Python
  • Azure services

Advanced Power Query

  • Using Power Query M Language
  • Handling Pre-Aggregated Data
  • Merging Data
  • Pivoting Data


  • Using Flow or a Third part y tool

Further DAX

  • Advanced DAX formulas and Techniques
  • Time Intelligence workarounds

Data Connections

  • Advanced Data Modelling
  • Use of Azure and effective Data Connections


  • Creating Custom Visuals in Visual Studio
  • Setting up Custom Visuals for Corporate use
  • R script
  • Python
  • It is recommended you have completed the Intermediate Power BI desktop course and have knowledge of working with Azure products, App development with Visual Studio, and Workflows.
  • £495
  • One day trainer led or virtual