What will I learn?

Full Course Details

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

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.
Read More

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
Excel Training Business benefits

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.

Excel Training Business benefits

Power BI Training - People Development

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

Excel Training Business benefits

Flexible Power BI Training Courses

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

Why choose TrainingU?

Excel Training Business benefits


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

Excel Training Business benefits


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

Excel Training Business benefits


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

Your complete training solution

Excel Training Business benefits

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.

Excel Training Business benefits

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.

Excel Training Business benefits

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.

Our Clients

International SOS Pioneer DJ

Enquire & Book Power BI Training

Simply fill out the contact form or call 0333 344 6630 to make an enquiry, book your Power BI training or assess your staff Power BI training levels.