Overview
Australia’s public sector faces a significant challenge in managing data assets amid rising demands for digital transformation.
In 2026, the Australian Government reported 103 in‑flight major digital projects across 43 agencies, with a total budget commitment of AUD $9.7 billion, including AUD $5.9 billion spent on digital technologies. With programs and services operating at this scale, the efficiency and accuracy of business intelligence (BI) systems become critical. Inconsistent reporting, manual data preparation, and unclear metrics make it harder to track performance, surface risks early, and support timely decisions.
This challenge is further amplified by the size of the public sector workforce. In June 2025, the Australian Bureau of Statistics reported 2,597,300 public sector employee jobs (about 2.6 million). This means even small improvements in reporting efficiency and data confidence can have wide operational impact, making foundational Power BI skills data preparation, modelling, and building shareable reports and dashboards increasingly important across government teams.
Microsoft Power BI is a business intelligence tool that helps people analyse data and turn it into clear, useful insights. In this course, you’ll use Power BI Desktop to connect to data from different sources, shape and model it, and build interactive reports. You’ll also publish your work to the Power BI Service, where you can share reports and create dashboards to support day-to-day decisions.
Join us for a practical, in-depth, and hands-on introduction to self-service Business Intelligence and streamline how you collect, clean, and visualise data.
Who Should Attend?
Excel users looking to move into Power BI reporting Data, business, and reporting analysts Managers and team leaders who rely on data for decision-making Government professionals across local, state, and federal agencies Staff responsible for dashboards, performance reporting, or business insights
Learning Outcomes
By the end of this course, you will be able to:
Use Power Query to automate data preparation – Import, clean, and transform data from a range of sources efficiently in Power BI.
Understand core data modelling concepts – Learn the fundamentals of relationships and model structure to support accurate analysis.
Learn DAX fundamentals – Use Data Analysis Expressions (DAX) to enrich data and create basic calculations and measures.
Create effective Power BI visualisations – Build clear, engaging visuals and format reports for professional presentation.
Use the Power BI Service confidently – Understand the difference between reports and dashboards and learn how to publish and use them in the Power BI Service.
Online Training
Power BI Essentials for Government
Session details
Why Attend
- Extract insights from data to make more informed, data-driven decision
- Present complex data in a comprehensible manner, making it easier to communicate findings and trends
- Develop centralised data reporting methods and easily share information across your organisation.
- Automate data-related processes, saving time and resources for other essential tasks.
9 & 10 September 2026 Course Registration
3 & 4 December 2026 Course Registration
No previous experience necessary
Key Sessions
Day 1- Welcome and Housekeeping
Getting Started with Power BI Desktop
- What is Power BI
- Power BI Licensing
- Get Started with Power BI Desktop
- Options and Settings
- Get Data from Excel
- Work in the Table View
- Get Started with Power Query
- Clean and Transform Data
- Get Data from other sources
- Introduction to the Data Model
- Understand Cardinality and Relationships
- Add and Manage Relationships
- Understand Star-Schema
- Work with Calendars
- Create Table Visuals
- Add Data to the Visuals
- Change Calculation Options
- Change Sort and Sequence
- Work with Matrix Visuals
- Understand DAX calculations
- Create Calculated Columns
- Work with Date and Logical functions
- Create Simple Measures
- Troubleshoot and Modify DAX Measures
12.25pm Reflections and Q&A
12.30pm End of day 1
Design and Create a Power BI Report
- Good Design for Power BI Reports
- Set Page and Canvas Settings
- Add Static Elements
- Change and Customise Themes
- Add Doughnut, Map & Treemap Visuals
- Work with Line and Column Charts
- Use Tool Tips and Cross Filters
- Customise Visuals
- Use Card Visuals to show key metrics
- Customise Card Visuals
- KPI and Gauge Visuals (if time)
- Use the Filters Pane
- Work with Slicers
- Manage Interactions
- Publish to the Power BI Service
- Workspaces & Sharing Options
- Spotlight and Focus Mode
- Export Data from a Report
- Export Reports
- Share Reports in the Service
- Report vs Dashboard
- Create a Power BI Dashboard
- Work with Tiles and Q&A
- Update Reports and Dashboards
12.20pm Reflections and final questions
12.30pm 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
Early Bird
Ends 24 Jul
$A 695
per person + tax $200 savingRegular
Ends 8 Sep
$A 895
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