Microsoft Power Bi Intermediate – Virtual Session

Course Code: XLPOWBI
Duration: ½  Day

Course Aims:

This half day virtual Microsoft Power BI Desktop training course is aimed at anyone looking to use this powerful, flexible, and highly accessible business intelligence tool to connect with and shape the world of data, build robust models, and craft well-structured reports, which can then be seamlessly shared through Microsoft Power BI Service with users.

Course Pre-requisites:

Delegates should have attended the Microsoft Power BI Publishing course or have equivalent knowledge.

Course Content:

Power BI Desktop for Visualisation Workshop

  • Adding visualisations to Report Canvas
  • Managing visualisation relationships
  • Drill Down and Drill Through techniques
  • Use of Hierarchies
  • Importing and using custom Visualisations

Power BI Desktop and Queries

  • Append and merge queries
  • Data transformations
  • Using Applied Steps

Data Modelling

  • Creating relationships
  • One to Many relationships
  • Many to Many relationships

Power BI Desktop and DAX

  • Calculated Columns and Measures
  • Calculated Tables
  • DIVIDE function
  • SUMX and other iterator functions
  • CALCULATE function
  • TOPN function
  • Using a Slicer to return different calculations


  • Publishing dashboards
  • Apps
  • Security

Request Further Information

To find out more about course availability and pricing please complete the form below and we will be in touch.