Skip to main Content

Microsoft 365 Power BI Level 2

  • Course Code M365PBIL2
  • Duration 1 day

Course Delivery

Public Classroom Price

£425.00

excl. VAT

Request Group Training Add to Cart

Jump to:

Course Delivery

This course is available in the following formats:

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Download Course Details

Course Overview

Top

With PowerBI Desktop, you get a report authoring tool that enables you to connect and query data from different sources using the Query Editor.  From the datasets you build with Query Editor you can add visualisations and create reports.  Reports can then be published.

Course Schedule

Top
    • Delivery Format: Virtual Learning
    • Date: 03 February, 2026 | 9:30 AM to 4:30 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £425.00

    • Delivery Format: Virtual Learning
    • Date: 31 March, 2026 | 9:30 AM to 4:30 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £425.00

    • Delivery Format: Virtual Learning
    • Date: 12 May, 2026 | 9:30 AM to 4:30 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £425.00

    • Delivery Format: Virtual Learning
    • Date: 05 August, 2026 | 9:30 AM to 4:30 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £425.00

View Entire Schedule Dates in Other Countries

Target Audience

Top

The course builds on the skills learnt in our Power BI Fundamentals course and introduces you to more features including data modelling, performance optimization and more complex reporting.

Please note that this course does not cover PowerBI Pro, PowerBI accessed via Microsoft 365 or SharePoint Services.

Show me more

Course Objectives

Top

By actively participating in this course, you will learn about the following:

  • Data Modelling

  • Create Calculation using DAX

  • Perform in-depth Reporting

Show me more

Course Content

Top

Data Modelling

  • Introduction to Data Modelling

  • Joins, Relationships and Cardinality

  • Many to Many Relationships

  • Star Schemas

  • Create a Date Table

 

Create Calculations using DAX

  • Create Calculated Columns

  • Build Quick Measures

  • Use DAX to Build Quick Measures

  • Join Types

 

Reporting

  • Choose Effective Visualizations

  • Import a Custom Visual

  • Interactions and Drill-throughs

  • Configure Conditional Formatting

  • Apply Slicing, Filtering and Sorting

  • Key Perform and Indicators

Show me more

Course Prerequisites

Top

We recommend that you attend our Power BI Fundamentals course or have equivalent skills and knowledge.

Software Requirements for Virtual Classroom

Delegates will need to have an Office 365 subscription with access to Power BI and have the desktop version installed on their PC.  We strongly recommend that delegates also check that their PC meets the Minimum Requirements as outlined on the Microsoft Website in order to run Power BI effectively.

This course is not suitable for MAC users.

Show me more