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

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

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

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 was very through and very helpful. The course was delivered superbly and I'm very pleased.

David O'Hara - Multibrands UK

Related Courses

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