banner image

Power BI Intermediate

1 Day Instructor-led
course icon

Course Information

Overview

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.

Prerequisites

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
Fri, 29 Jul 2022
£445
Fri, 19 Aug 2022
£445
Fri, 30 Sep 2022
£445
Fri, 28 Oct 2022
£445
Fri, 25 Nov 2022
£445

Private Courses

We can arrange your own private Power BI course.

Tailored

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

Really good course. lots of hands on practice and clear explanations.

fiona dawe - Covetrus Global Software Services

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

Nathan Lewis - Lincolnshire County Council

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

This course was great, the trainer was very knowledgeable and has improved my knowledge considerably. The facilities are fantastic. Thank You!

Kurtis Fleming - HM Revenue & Customs

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

Related Courses

Next on Thu 14 Jul
Format:
Virtual or Classroom
Length:
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 Fri 29 Jul
Format:
Virtual or Classroom
Length:
1 Day
On this course you will learn how to gather more insight from your data by using data slicers and drill down techniques.
Format:
Virtual or Classroom
Length:
1 Day
This one-day course focuses on importing data from a variety of sources, creating reports and configuring online interactive dashboard.
Next on Thu 21 Jul
Format:
Virtual or Classroom
Length:
2 Days
Learn to use DAX the native language of Power BI & Power Pivot and write formulas for common and advanced business scenarios.