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.
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.
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 – Intermediate.
If you want your documents to look more polished and professional, this course helps you build the skills to manage layouts, visuals and formatting with confidence.
You will learn how to work with tables, images and diagrams to create clearer, more engaging documents.
Senior leaders do not need to become technical experts in AI, but they do need to understand what it can do, where it may create risk and how to guide its use across their organisation.
You will explore AI in a business context, including common applications, ethical considerations, privacy, accountability and workforce impacts.
Level - Advanced
Automate your spreadsheets with confidence.
Designed for users ready to move beyond formulas, this course shows you how to automate everyday tasks with simple VBA programming.
You’ll learn how to record and edit macros, build reliable routines and create customised solutions that save time and improve accuracy."