Microsoft Power BI Advanced Training Course

Course Code: M365PBIA   Duration: 1 Day   Price: £395+VAT

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.


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.

Learning Objectives

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

  • Data Modelling
  • Optimizing Model Performance
  • Create Calculation using DAX
  • Perform in-depth Reporting

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

Course Contents

Data Modelling

  • Introduction to Data Modelling
  • Joins, Relationships and Cardinality
  • Many to Many Relationships
  • Star Schemas
  • Create a Date Table


Optimize Model Performance

  • Performance Optimization
  • Performance Analyzer
  • Review Performance Results
  • Optimize Direct Query Models
  • Create and Manage Aggregations


Create Calculations using DAX

  • Create Calculated Columns
  • Build Quick Measures
  • Use DAX to Build Quick Measures
  • Join Types.



  • Choose Effective Visualizations
  • Import a Custom Visual
  • Interactions and Drill-throughs
  • Configure Conditional Formatting
  • Apply Slicing, Filtering and Sorting
  • Key Perform and Indicators

Head Office

Skilltec Training

58 New George Street
City Centre
01752 227330

Follow us on:

Payment methods:

Registered in England 06131527

Registered address: 58 New George Street, Plymouth, PL1 1RR