Microsoft Power BI Training Courses | TrainingU Power BI Intermediate

What will I learn?

Delve deeper into each of the steps necessary to create Power BI reports covered in the one day foundation.

We take a closer look at:

connecting to and tidying up your data
the data model
DAX measures
report visualisations
filtering and interactivity
the role of the Power BI Service.

To attend you should have completed our Power BI Foundation course or have equivalent experience and have a basic understanding of each of the steps to create Power BI reports and dashboards.

Book Power BI Intermediate Training

For companies who need to train groups of staff either remotely or in-person.

Two day course
Up to 10 delegates
Flexible in-house training dates

Face-to-face training
In-house or a venue of choice
Virtual training option

Enquire & Book

MEET THE TRAINER

Paul Watson

Paul brings a wealth of understanding and knowledge, specialising in technical training and development in Excel, Power BI and Access. His knowledge with IT systems has been gained both academically and through more than 20 years practical experience in the industry. His strengths are demonstrated as both an IT trainer and as a developer.

Full Course Content

Day 1
Data Sources, Query Editor and Data Modelling

Import from various Data Sources
Use the Query editor
Transform & Clean Imported Data
Remove Errors, Metadata, Rows & Columns
Understand & Change Data Types
Import Files from a Folder
Append Multiple Tables
Unpivot Data
Create Calculated Columns
Understand Applied Steps & Define ‘M’
Change the Data Source
Using Model View & Table Relationships

Get to Grips with DAX Formulas & Filter Context

Measure versus Calculated Columns
DAX Object Naming & Syntax
Importance of the Data Model for DAX formulas
Understand how DAX Measures Evaluate
Impact of Filtering on DAX Measures
Key DAX functions

DAX Functions and Time Intelligence

CALCULATE Related Functions
Modify Filter Context in a DAX Formula
Dates Table
DAX Time Intelligence Functions
Modify the Dates Table for Reporting Year

Day 2
Using Visualisations and the Report Canvas

Settings and Options for Key Visualisations
Interaction of Visualizations
Maps
Text boxes, Lines and Shapes
Conditional Formatting
Multiple Pages in Reports
Filtering Options – Context, Slicers & Filters
Hierarchies and Drill down
Change the Default Date Hierarchy

Techniques & Settings to Maximise Visuals Impact

Use Drill Through
Creating Custom Groups
Understand Bookmarks
Use Buttons to Hide Tiles & Modify Presentation
Page Settings and Properties
Create and Customise Tooltips

The Power BI Service (Online)

Navigate the Service Environment
Understand Workspaces
Power BI Reports versus Dashboards
Manipulate Reports
Create Reports from New & Existing Data Sets
Build a Dashboard from Published Reports
Share Reports & Dashboards
Create and Share Apps
Analyse a Data Model in the Service
Show Results in an Excel PivotTable
Refresh Data
Update Reports, Dashboards & Apps

Enquire & Book

Power BI Training – Business Benefits

By investing in people, you can give your team all the necessary skills they need to help support your organisation’s goals.

Power BI Training - People Development

Completing our Power BI training course will give you additional skills you need to help support your career development.

Flexible Power BI Training Courses

Online or face-to-face in-house training
Individual delegates or group training
Flexible dates to fit schedules

BOOK YOUR POWER BI TRAINING

Why choose TrainingU?

Passionate

Established over a decade ago by a team of knowledgeable training experts, we are passionate about delivering excellent training that makes a real difference.

Experienced

All our trainers are qualified and experienced Power BI trainers that will deliver the highest level of training to you and your team.

Collaborative

Working together with our clients, understanding their needs and desired learning outcomes, to deliver a personalised learning solution.

Your complete training solution

Before Training

Our Skills Assessment will ensure staff attend the correct level of training. Based on results, we will organise the training sessions required, who will take them and the level to best match the skills needed.

During Training

We provide first class training with highly experienced trainers. Courses include lots of exercises, practise and interactivity throughout, maximising learning whether delivered online or at your offices.

After Training

We will grant you organisation free access to our suite of online Power BI resources. In addition, we provide free post training support to ensure your staff utilise their new skills effectively.