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
Upcoming Course Dates
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.







