PowerBI Essentials for Government

Optimise Adoption | Overcome Resistance | Drive Innovation

Day One: 9 September 2025 | 1:00 PM - 4:00 PM AEST

Day Two: 16 September 2025 | 1:00 PM - 4:00 PM AEST

Virtual

Overview

Microsoft Power BI is a suite of business intelligence (BI) services that allows business users to perform sophisticated data analysis, turning data into actionable insights. In this course we will introduce the Power BI Desktop program and use it to fetch data from a variety of sources and then visually present our analysis in an interactive report. We then publish the report to the online service where we create a dashboard and look at how we use both to derive business insights.

If you have a keen interest in Data and want to find ways of automating the processes of collecting, cleaning and visualising it, this is the course for you! Join us for a fun, in-depth and practical hands-on introduction to self-service Business Intelligence.

Key Learning Outcomes

By participating in this course, you will:

Get and Transform Data: Know how to use Power Query to import data into Power BI
Basic Data Modelling: Understand the fundamentals of relationships and data modelling
Creating a Report: Manage pages, themes and backgrounds
Cell Referencing: Relative/Absolute/Mixed (Using F4)
DAX Essentials: Understand what DAX is and be able to create simple DAX calculations
Visualisations: Know how to create and format visualisations
Power BI Service: Know how to Publish to, share from and work in the Power BI Service
Create Dashboards: Understand the difference between Reports and Dashboards and know how to create a dashboard

Who Should Attend

This course will benefit APS4 to APS6 professionals and their state and local government equivalents who are looking to hone their analytical, visualisation and reporting skills to become better at extracting insights from their data.

Why Attend

Set up a strong foundation in data skills
Interpret data with sophisticated tools
Expand self-service analytics and visualisation offerings
Transform the way to present with powerful visuals

Agenda

DAY 1 9 September 2025 \| 1:00 PM - 4:00 PM AEST
Module 1 – Getting Started with Power BI Desktop	What is Power BI Power BI Licensing Overview of Power BI Desktop
Module 2 – Use Power Query to Get and Transform Data	Data Connection Options Get Data from Excel Introduction to Power Query Get Data from a Folder
Module 3 – Work with the Data Model	Understand Relationships Add and manage Relationships
Module 4 – Introduction to Data Analysis Expressions (DAX)	Use DAX to create Calculated Columns Use DAX to Create Simple Measures
Module 5 – Design and Create a Power BI Report	Set Page and Canvas Settings Add Images Change and Customise Themes Add and Manage Pages
Module 6 – Add and Customise Common Visualisations	Add Map, Treemap & Card Visuals Work with Tables & Matrixes Add Line and Column Charts

DAY 2 6 September 2025 \| 1:00 PM - 4:00 PM AEST
Module 7 –Work with Visualisations	Work with Tool Tips and Cross Filters Focus Mode and Spotlight Sort and Drill Down Customise Visuals
Module 8 – Add Multiple Pages and Custom Visuals	Rename, Add and Duplicate Pages Add Custom Visuals
Module 9 – Filter Visuals, Pages and Report	Use the Filters Pane Work with Slicers
Module 10 – Publish and Work with Reports in the Power BI Service	Publish to the Power BI Service Workspaces & Sharing Options Subscribe and Comment Spotlight and Bookmark Export Data from a Report
Module 11 – Create and Work with Dashboards in the Power BI Service	Report vs Dashboard Create a Power BI Dashboard Work with Tiles and Q&A Customise for Mobile View
Module 12 – Install Apps and work with Power BI Mobile	How to find shared Reports How to find Apps Power BI for Mobile

Nicky Bull
Corporate Consultant
Blue Chameleon

Meet Your Facilitator

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.

Register Early & Save!

*Group Discounts Available - Contact Registrations at training@publicsector.academy or Call on (02) 9057 9070

Standard

$895

1Available

About Us

Public Sector Network is a social learning platform that exists to help government around the globe break down silos, collaborate, and work together for better outcomes for citizens.

PSN’s growing community spans across federal, state, and local government departments, healthcare, and education, allowing members to share information, access the latest in government innovation, and engage with other like-minded individuals on a secure and closed-door network.

PSN Academy is a trusted partner in professional development, dedicated to empowering public sector professionals with the knowledge and skills they need to drive meaningful impact. We deliver innovative training programs and learning experiences that align with the unique needs of government and public service organisations.

Our mission is to build capacity within the public sector by providing high-quality, practical, and accessible learning opportunities. From leadership development and project management to cutting-edge topics like AI, data analytics, and psycho-social risk management, we offer tailored programs that reflect the challenges and priorities of today’s public service.

At PSN Academy, we pride ourselves on delivering content informed by global best practices, guided by the APS and state-based learning frameworks, and facilitated by industry-leading experts. Our flexible delivery options include in-person workshops, virtual training sessions, and hybrid models to suit diverse learning preferences and operational needs.