Overview
Australia’s public sector is navigating a critical inflection point: according to the Organisation for Economic Co-operation and Development (OECD), government digital and ICT investment is projected to grow by 8.4% annually between 2024 and 2027.
With this rapid expansion of data systems, agencies at federal, state, and local levels must manage increasingly large and complex datasets while maintaining performance, security, and governance standards. Amid rising public expectations for transparency, efficiency, and evidence-based policy, simply having data isn’t enough — how it’s analysed, modelled, and communicated matters deeply.
This Power BI Intermediate course is designed precisely for that next phase of maturity. Building on foundational proficiency, you’ll deepen your expertise in advanced data modelling, complex DAX calculations, and high-performance Power Query transformations. You’ll also explore secure data-sharing structures, role-based access, and governance practices tailored to public-sector requirements — helping your agency embed consistent, reliable analytics that support open data initiatives and performance reporting.
Now is the time to level up. Strengthen your Power BI capability, support smarter governance, and equip your team to deliver mission-critical insights that drive better outcomes, greater accountability, and a truly data-driven public service.
Learning Outcomes
By the end of this course, you will be able to:
Advanced data transformations, including merging, appending, unpivoting, and grouping data.
Understand and apply the M language for customised data transformations.
Improve data quality by leveraging fuzzy matching and data profiling techniques.
Explore advanced modelling techniques to structure data effectively for analysis.
Solve complex problems using DAX functions such as CALCULATE and Time Intelligence.
Incorporate geospatial visuals, hierarchies, drilldowns, and custom sort orders into reports.
Optimise interactive filtering through synchronised slicers, drill-throughs, and cross-filter editing.
Implement row-level security for tailored data access.
Online Training
Power BI Intermediate for Government
Session details
Advance your business intelligence and analytical skills and capabilities
- Enhance decision-making skills with sophisticated tools for data interpretation
- Expand self-service analytics and visualisation offerings
- Work with powerful visuals in real-time instead of static excel document
Take Skills Self-Assessment
05 & 07 May 2026 Course Registration
27 & 28 October 2026 Course Registration
Some familiarity with topic is recommended
Key Sessions
- Common Transformations
- Introduction to the M Language
- Merge and Append Queries
- Fuzzy Matching
- Add Columns
- Unpivot and Group
- Data Profiling
- Concepts & Best Practice
- Relationships and Cardinality
- Advanced Modelling Techniques
- Calculated Tables and Columns
- Filter vs Row Context
- Create and Organize Simple Measures
- Quick Measures
- The CALCULATE function
- Time Intelligence Functions
- CALCULATE with Filter Modifiers
- Geospatial Visuals
- Custom Sort Orders
- Hierarchies and Drill Downs
- KPIs and Gauges
- Combo Charts
- Small Multiples & Sparklines
- Custom Visuals
- AI Visuals
- Edit Interactions for Cross Filter
- Synchronise Slicers
- Create Drill Throughs
- Add Conditional Formatting
- Create Custom Tool Tips
- Add Navigation & Buttons
- Work with Bookmarks
- Use the Performance Analyser
- Add Row Level Security
- Workspaces and Sharing Options
- Create a Dashboard
- Create a Workspace App
- Managing Workspace Apps
Meet Your Facilitator
Nicky Bull
Corporate Consultant | Blue Chameleon
Nicky Bull is a dynamic corporate trainer and consultant. She has 15 years of commercial experience as a computer programmer and analyst, and over ten years designing and delivering a range of educational programs. She lectures accounting students at Macquarie University and is the creator of the highly acclaimed Excel for Data Analytics Specialisation on the Coursera platform.
Nicky is passionate about learning and enabling people to use technology confidently and effectively in their workplace. She holds a BSc Hons in Computer Science, a BA in English Literature, and a Postgraduate Certificate in Education.
What your peers had to say
Register Today
Join this training for professionals working within the Public Sector
Black Friday Sale
Ends 12 Dec
$A 595 + 15% OFF
per person + tax Use Code: BF15OFF for savingExtra Early Bird
Ends 20 Feb
$A 595
per person + tax $400 savingEarly Bird
Ends 20 Mar
$A 795
per person + tax $200 savingRegular
Ends 4 May
$A 995
per person + taxFor group or payment enquiries or custom training solutions, please contact [email protected]
Can't see what you need?
Download our training catalogue to review all available topics