request@systematix.co.uk

Call Us On:
0118 324 3000

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.

Learn About Virtual Training ››

Power BI Intermediate

1 Day Course

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

Download PDF 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.

Delivery Options:

At Your Offices

Virtual Online

Training Centres

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

Power BI Introduction

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.

View Course