banner image

Power BI Intermediate

1 Day Instructor-led
course icon

Course Information


This course is designed for existing users of Power BI user who wish to develop their skills in analysing and querying data. Students will learn how to use Power BI power tools for slicing, querying, shaping and drilling down in to data. Participants will get hands-on experience learning these skills and concepts using example data based on real world scenarios.


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

Course Outline

1. Working with Query Editor
  • Transformation tools
  • Create & Use Parameters
  • Writing or Editing M language
  • Custom Functions
2. Other Power BI Tools
  • Report Drillthrough
  • Row Level Security
  • Bookmarks & Buttons
  • Insert AI Visuals
  • Using Page Tooltips
  • Quick Measures
3. Power BI Service
  • Using the Workspace App
  • Create Workspace
  • Assign User Access
  • Develop the Workspace App
  • Share Content Using the App

Dates & Prices

Attend one of our public Power BI courses:

Small Class Sizes

Maximum of 6 students per course.

Reference Manual

High quality reference manual supporting the topics covered.

Post Course Support

Unlimited post course email support on the course topics.

Delivery Options:
Choose a location...
1 Day Course
Mon, 22 Apr 2024
Fri, 24 May 2024
Mon, 24 Jun 2024
Mon, 22 Jul 2024
Fri, 23 Aug 2024

Private Courses

We can arrange your own private Power BI course.


Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

This has been by far one of the most useful and well planned/executed training courses I have ever attended. For this to have been achieved remotely just adds to how impressive it was managed.

Trevor Stratton - Lincolnshire County Council

Course was well adjusted to consider the business perspective - considering commonly needed calculations, time based data analysis etc.

Suvi Salminen - Crane CPE

Very good course. I've been using the software constantly in the last three months and still learnt a lot.

George Martin - NHS North of England

The trainer demonstrated a deep and knowledgeable understanding of the software and was able to simplify its complexities.

Nathan Lewis - Lincolnshire County Council

As usual a first class training course.

Wendy Thomas - Aldi Stores Ltd

The trainer was an amazing lecturer and the vba course was very usefull and well structured. Thank you.

Veronika Panton - Haven Power

Related Courses

Next on Mon 20 May
Virtual or Classroom
2 Days
This Introduction course is designed for those looking to create interactive dashboards, charts and range visualizations that display data in a user-friendly way.
Next on Mon 22 Apr
Virtual or Classroom
1 Day
On this course you will learn how to gather more insight from your data by using data slicers and drill down techniques.
Virtual or Classroom
1 Day
This one-day course focuses on importing data from a variety of sources, creating reports and configuring online interactive dashboard.
Next on Tue 23 Apr
Virtual or Classroom
2 Days
Learn to use DAX the native language of Power BI & Power Pivot and write formulas for common and advanced business scenarios.