Online Training

Power BI Intermediate for Government

Uplift your business intelligence and analytical skills and capabilities

25 March & 1 April 2025

9:00 AM – 12:30 PM AEDT

Next intake: 25 March & 1 April 2025 | 9:00 AM – 12:30 PM AEDT

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 delve further into the Power BI Desktop program. It will explore practical solutions for cleaning, transforming, and analysing data as well as some great features for creating effective and secure reports, dashboards, and apps. 

The Power BI Intermediate course is designed for professionals who have a basic understanding of Power BI but are looking to expand their skills and gain deeper insights into their data. It covers advanced data modelling techniques, empowering attendees to optimise the performance and accuracy of their data. 

The course also covers the use of DAX functions and calculations for complex data analysis, allowing attendees to uncover valuable insights and trends in their data.  In addition, attendees will learn how to create interactive and visually appealing dashboards and reports with Power BI’s robust visualisation tools, helping them to effectively communicate their findings to stakeholders. 

With the skills gained from this training, attendees will be able to take their data analysis to the next level, making informed decisions and driving success for their departments and agencies.  

Learning Outcomes

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
View course modules

Level: Intermediate

Some familiarity with topic is recommended

Key Sessions

9.00am 

Welcome and Opening Remarks 

9.05am 

  • Common Transformations 
  • Introduction to the M Language 
  • Merge and Append Queries 
  • Fuzzy Matching 

9.40 am 

  • Add Columns 
  • Unpivot and Group 
  • Data Profiling 

10.15 am 

Break 

10.40 am 

  • Concepts & Best Practice 
  • Relationships and Cardinality 
  • Advanced Modelling Techniques 

11:10 am 

  • Calculated Tables and Columns 
  • Filter vs Row Context 
  • Create and Organize Simple Measures 

11:30 am 

  • Quick Measures 
  • The CALCULATE function 
  • Time Intelligence Functions 
  • CALCULATE with Filter Modifiers 

12:20 pm 

Reflections and Closing Remarks 

12.30pm 

End of day 1 

9.00am 

Welcome and Recap 

9.05am 

  • Geospatial Visuals 
  • Custom Sort Orders 
  • Hierarchies and Drill Downs 

9.40am 

  • KPIs and Gauges 
  • Combo Charts 
  • Small Multiples & Sparklines 
  • Custom Visuals 
  • AI Visuals 

10.15 am 

  • Edit Interactions for Cross Filter 
  • Synchronise Slicers  
  • Create Drill Throughs 

10.40 am 

Break 

11:10 am 

  • Add Conditional Formatting 
  • Create Custom Tool Tips  
  • Add Navigation & Buttons  
  • Work with Bookmarks 

11:30 am 

  • Use the Performance Analyser 
  • Add Row Level Security 

12:00 pm 

  • Workspaces and Sharing Options 
  • Create a Dashboard 
  • Create a Workspace App 
  • Managing Workspace Apps 

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

“The course included simple tips and tricks that will make it easier for me to build reports more efficiently and without errors."

"It covered a lot of territory in a short time but was exactly at the level I needed."

"The presenter allowed plenty of time for questions and ensured people kept up."

"Nicky Bull is an excellent trainer who explained the course material well."

Register Today

Join this training for professionals working within the Public Sector

Pay for individual courses

Extra Early Bird

Ends 17 Jan

$A 595

per person + tax $400 saving

 

Early Bird

Ends 14 Feb

$A 795

per person + tax $200 saving

 

Regular

Ends 24 Mar

$A 995

per person + tax

Additional discounts are available for group registrations of 10 or more. For group or payment enquiries or custom training solutions, please contact [email protected]

Customised in-house options available for teams

Interested in any of our online trainings?

You can also choose to have them delivered in house. We will work closely with our inspiring session facilitators to tailor the content around the key development areas your team are prioritising, shape the learning outcomes around your core departmental challenges and make the most of your L&D and upskilling budget.

Enquire here for more information

Can't see what you need?

Download our training catalogue to review all available topics

Download full catalogue

Get in Touch

Empowering the public sector with meaningful actionable advice to help solve the problems worth solving. If you would like to do an in-house course, please get in touch.

Request the training catalogue

To receive a PDF copy of the Public Sector Academy training catalogue, please submit the details below:

By submitting your email address, you are consenting to Public Sector Network potentially reaching out to you about the academy offering.

Achieve great value with our customised subscription plans