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
Mon, 22 Apr 2024
£445
Fri, 24 May 2024
£445
Mon, 24 Jun 2024
£445
Mon, 22 Jul 2024
£445
Fri, 23 Aug 2024
£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

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

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

I found the course very relevant to a lot of the day-to-day work I do.

Sian Stephenson - Aldi Stores Ltd

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

Nathan Lewis - 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

Fantastic tutor. Great course! Thank you.

Joel Weaver - Science Ltd

Related Courses

Next on Thu 18 Apr
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 Mon 22 Apr
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 Tue 23 Apr
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.