Computer Skills

Microsoft-Power BI Desktop- Level 2


Level – Advanced.

Designed for users ready to deepen their Power BI capability, this course builds on Level 1 and strengthens your ability to work with advanced DAX, time-based analysis and dynamic visualisation tools.


You’ll learn techniques that support richer insights and more flexible reporting.

Location
Date
Duration
Time (AWST)
Address
Participants
Total

What to expect

Power BI’s advanced features allow you to analyse data with greater precision and create reports that communicate patterns over time. This course expands your understanding of DAX by introducing variables, advanced functions and the logic that determines how formulas are evaluated.

You will explore Time-Intelligence functions to analyse trends across periods, compare performance and create meaningful calculations that shift with your data. These skills help you build more robust and adaptable models that reflect real-world reporting needs.

The course also covers advanced visualisation techniques, including report themes, conditional formatting and KPI indicators, so you can present insights clearly and effectively. By the end, you’ll be equipped to create dynamic, interactive reports that elevate your Power BI dashboards.

Is this course for you


This course is ideal for users who are ready to explore the advanced functions of Power BI. While there are no formal prerequisites, it assumes an intermediate understanding of Power BI gained through Microsoft – Power BI Desktop Level 1 or equivalent hands-on experience.

This course is suited to individuals who want to:

  • deepen their knowledge of advanced Power BI features

  • create more sophisticated and interactive reports

  • analyse and model data more effectively

  • gain greater insight from Power BI visualisations

Pre-requisite:
Participants must have completed Microsoft – Power BI Desktop Level 1 before attending this course.

What you will explore

During this training course, you will develop advanced Power BI skills to analyse data more deeply and create highly interactive, insightful reports. The course focuses on building complex DAX formulas, understanding evaluation context, applying time-intelligence functions, and designing dynamic visualisations that highlight performance and trends.

By the end of this training course, you should be able to:

  • Build complex DAX formulas using variables and advanced functions

  • Understand how DAX functions are evaluated

  • Create formulas that analyse data over time using Time-Intelligence functions

  • Create dynamic visualisations using report themes, conditional formatting and KPIs

Where this course can take you


During this training course, you will explore how to build complex DAX formulas using variables and advanced functions, and understand evaluation logic within DAX. You will learn how to apply time intelligence functions for period based analysis and deeper performance insight.

The course also focuses on creating dynamic visualisations using report themes and applying conditional formatting for clarity. You will learn how to use KPI indicators to highlight performance trends and support informed decision making.

Related Results


Level – Advanced.

If you work with long or detailed documents, this course builds the skills to structure, format and manage them with confidence.

You will learn how to keep reports consistent, add references and produce polished, professional outputs.


Level – Fundamental.

If you want your presentations to look clearer and more polished, this course helps you build the practical design skills to create slides that communicate with impact.

You will learn how to structure layouts, use templates effectively and enhance content with data visuals and multimedia elements that support clear, engaging communication.


Level - Fundamental

Build confidence with the core tools of Excel.

If you’re new to spreadsheets or want to feel more sure of your skills, this course gives you the practical foundations to use Excel comfortably in everyday work.

You’ll learn how to design and format spreadsheets, apply basic formulas and present clear, professional information that supports your role.


Level – Fundamental. 

If you’re new to Microsoft Project, this course helps you plan and track work with confidence.

You will learn how to set up schedules, allocate resources and monitor progress so your projects stay organised and on track.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs