Skip to main content

Microsoft Power BI Desktop Advanced

Course Overview

Microsoft Power BI Desktop Advanced

Develop knowledge of the more advanced features of the Power BI service, Power Queries, Data Modelling, DAX and advanced techniques.

Course Content

Power BI Service

  • Dataflows
  • Datamarts

Power Query

  • Parameters in Power Query
  • Functions in Power Query

Data Modelling

  • Handling many to many tables
  • Handling tables with multiple relationships
  • Optimising your data model

DAX

  • Creating dynamic titles
  • Using the DAX query view
  • Advanced DAX functions
  • Using parameters to control reports
  • Calculations groups

Advanced techniques

  • Using field parameters to create dynamic visuals
  • Report backgrounds
  • Using buttons and bookmarks to create dynamic tooltips
  • Report layout considerations

Located at: Online and face-to-face

Course Start: View dates

Course length: 1 day

Course Code: STT0060

Course Fees and Funding

How much does the course cost?

  • Open participant course: £250 per person maximum 10 people
  • Closed company course: £1,200 per course maximum 10 people

Other funding information

Course Content

Other Resources

The course information on this page was last updated 08 April 2026.