This course is designed for participants who have already attended Power BI Introduction training and who wish to develop their skills in analysing and querying data.

You should have attended our Microsoft Power Bi Desktop Introduction course or have equivalent knowledge.


By attending this workshop, you will learn how to use Power BI power tools for slicing, querying, shaping and drilling down in to data. You will get hands-on experience learning these skills and concepts using example data.


Working with Query Editor

  • Transformation tools
  • Create & Use Parameters
  • Writing or Editing M language
  • Custom Functions

Other Power BI Tools

  • Report Drillthrough
  • Row Level Security
  • Bookmarks & Buttons
  • Insert AI Visuals
  • Using Page Tooltips
  • Using bookmarks

 Power BI Service

  • Creating workspaces
  • Datasets
  • Reports
  • Creating dashboards
  • Managing permissions
  • Scheduling auto refresh


  • Using multiple conditions
  • The FIND DAX function
  • The IF DAX function
  • Logical functions IF, AND, OR
  • Dynamic Labels
  • CALCULATE Function
  • Time Intelligence Functions
  • Expression based formatting
  • Using the ALL Function
  • Iterator Functions

 Editing DAX Measures

  • Making DAX easier to read
  • Add comments to a measure
  • Using variables and RETURNS
  • Comments

Visualisations In-Depth

  • Dynamic Titles
  • Expression based formatting
  • Building effective visualisations
Have a question?

Let’s get this conversation started. Tell us a bit about your requirements and we’ll be in touch.

What you need to bring for these courses when delivered as a virtual classroom.

For virtual classroom courses, you will need:

  • Computer with Internet Access
  • Microphone and Headset
  • Webcam
  • Microsoft Teams
  • A dual monitor setup is recommended for IT training
Upcoming Courses
Get in touch via our contact form or call us on 01473 414 414