Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

banner image

Power BI Intermediate

1 Day Course
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. Slicers
  • Interactive Slicers
  • Date Slicers – Dropdowns and Searches
  • Number Slicers with Value Ranges
  • Date Slicers with Relative Filters
  • Create Reusable Field Hierarchies
  • Record Grouping and Binning in Visualizations
  • Analytics Lines in Visualizations
  • Insight – Explain Increase/Decrease
  • Forecast
  • Create Measures
  • Create a KPI Visualization
2. Drill-down
  • Drill Visualizations to see underlying Data
  • See Records
  • Date Hierarchies
  • Page Drillthrough Filters
  • Show Values As and Quick Measures
  • Clustering
  • Creating Role Based Views
  • Data Categories, Geo-Data and Maps
3. Querying and Shaping the Data
  • Common Activities using Query Editor
  • Filters
  • Using Delimiters
  • Transforms
  • Pivot and Group By
  • Creating Custom Calculated Columns
  • Adding Conditional Columns
  • Columns From Examples
  • Introduction to DAX Expressions
  • Histograms
4. Reports and Output Options
  • Report Elements and Options
  • Working with Pages
  • Keyboard Shortcuts and Navigation
  • Selection Pane
  • Lock Objects
  • Adding Graphics
  • Report Level Filters
  • Bookmarks
  • Spotlight
  • Report Themes
  • Export Power BI Data to CSV
  • Create a Power BI Template

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

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

Very good introduction. Well paced and suited a range of experience levels.

Felicity Howdle - Health Education 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

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

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

Related Courses

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