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.
This course is ideal for participants who:
- Already have basic experience with Power BI or other reporting tools
- Want to build more advanced dashboards and visualisations
- Need to analyse and interpret data to inform decision-making
- Seek practical techniques to optimise reporting and share insights effectively
Who Should Attend?
This intermediate-level course is designed for APS 4–APS 6 / EL 1 professionals (or state, territory and local government equivalents) who want to enhance their analytical, visualisation, and reporting skills, and improve their ability to extract actionable insights from data. Relevant roles include:
Data, Reporting and Insights Officers
Business Analysts
Program or Project Officers
Policy Officers
ICT and Digital Officers supporting analytics or dashboards
Finance, Procurement or Planning Officers
Service Delivery and Operations Officers
EL 1 team leaders overseeing reporting, data analysis, or dashboards
Learning Outcomes
By the end of this course, you will be able to:
Perform advanced data transformations, including merging, appending, unpivoting, and grouping data.
Apply the M language to customise data processing and improve automation.
Enhance data quality through fuzzy matching and data profiling techniques.
Build optimised data models that improve performance and accuracy.
Utilise DAX functions, such as CALCULATE and Time Intelligence, for advanced analytics.
Incorporate geospatial visuals, drill downs, hierarchies, and custom sort orders to enhance reports.
Implement interactive filtering, including synchronised slicers, drill-throughs, and cross-filter editing.
Apply row-level security to restrict data access based on user roles.
Online Training
Power BI Intermediate for Government
Session details
- In its first combined data and digital strategy, which outlines its blueprint for the use and management of data and digital technologies through to 2030. The Australian Government highlights the importance of data and digital foundations. For many, Power BI Intermediate is a step to advancing your business intelligence and analytical skills and capabilities
- The role of data in making decisions has also grown, along with the sophistication of the tools that provide ever-increasing possibilities for interpreting data. As a result, it is no longer sustainable to rely on BI team for your insights, everyone needs to become an analyst
- Power BI enables government agencies to expand self-service analytics and visualisation offerings
- Power BI has positively transformed the way many organisations work with powerful visuals and in real-time, instead of a static Excel document
Available Course Schedule(s)
27 & 28 October 2026
Facilitated by: Nicky Bull
Some familiarity with topic is recommended
Key Sessions
Welcome and Opening Remarks
- 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
Reflections and Closing Remarks
End of day 1
Welcome and Recap
- 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
Break
- 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
Reflections and final questions
End of day 2
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
Extra Early Bird
Ends 14 Aug
$A 595
per person + tax $400 savingEarly Bird
Ends 11 Sep
$A 795
per person + tax $200 savingRegular
Ends 26 Oct
$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