(08) 9383 8000
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.
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
Where this course can take you
Level - Intermediate.
Strengthen your ability to analyse and calculate with Excel.
Designed for those ready to move beyond the basics, this course shows you how to use formulas and functions that make your spreadsheets smarter and easier to work with.
You’ll learn how to structure formulas well, use named ranges and troubleshoot errors so your calculations stay accurate and reliable.
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.
Level – Fundamental.
If you want to create clean, professional documents with ease, this course builds the core skills you need to work confidently in Microsoft Word.
You will learn how to format text, structure pages and use essential tools that make everyday documents easier to produce.
Level - Advanced
Transform raw data into clear insights.
Designed for people who work with large data sets, this course helps you turn complex information into clear, meaningful summaries.
You’ll learn how to build PivotTables and PivotCharts that highlight trends, support analysis and communicate results with impact.