Online Training
Power BI DAX for Government
Empowering Data-Driven Decisions for Government with DAX in Power BI
8 & 15 April 2025
9:00 AM - 12:30 PM AEDT
Next intake: 8 & 15 April 2025 | 9:00 AM - 12:30 PM AEDT
Overview
DAX (Data Analysis Expressions) is the calculation engine behind Power BI, enabling public sector professionals to harness the full potential of their data for informed decision-making. By enhancing existing data models, DAX provides powerful tools for advanced analytics, uncovering trends and insights that go beyond standard reporting capabilities.
This course is specifically designed to equip government professionals with the skills needed to analyse complex datasets, optimise resource allocation, and support evidence-based policy decisions. From foundational concepts to advanced techniques, participants will gain the ability to perform detailed filtering, time series intelligence, and performance optimisation to address unique challenges in the public sector.
Learning Outcomes
Online Training
Power BI DAX for Government
Session details
- Improve service delivery through actionable insights
- Enhance accountability and transparency for stakeholders
- Long-term planning capabilities supported by data-driven analysis
Level: Intermediate
Perfect for intermediate to advanced Excel users, this training empowers you to unlock powerful insights and take your data analysis and reporting skills to the next level.
Key Sessions
|
9.00am |
Welcome and Opening Remarks |
|
9.15am |
What is DAX
|
|
9:45am |
Working with DAX functions
|
|
10.40am |
Break |
|
11:00am |
Calculated Columns vs Measures
|
|
11:30pm |
Aggregators and Iterators
|
|
12.20pm |
Reflections and closing remarks |
|
12.30pm |
End of Day 1 |
|
9.00am |
Welcome and Recap |
|
9:10am |
DAX Tools for troubleshooting and error handling
|
|
9.40am |
Scalar vs Tabular Functions
|
|
10:10am |
Modifying filter context with CALCULATE
|
|
10.40am |
Break |
|
11:00am |
CALCULATE Modifiers
|
|
11:50pm |
Time Series Intelligence
|
|
12.20pm |
Reflections and final questions |
|
12.30pm |
End of Day 2 |
Meet Your Facilitator
Nicky Bull
Corporate Consultant | Blue Chameleon
Nicky brings over 15 years of expertise as a computer programmer and analyst, complemented by 10 years of instructional design and training experience. As a lecturer at Macquarie University and creator of the popular Excel for Data Analytics Specialisation on Coursera, Nicky has empowered thousands to harness the full potential of data tools.
What your peers had to say
Register Today
Join this training for professionals working within the Public Sector
Pay for individual courses
Extra Early Bird
Ends 14 Feb
$A 990
per person + tax $400 saving
Early Bird
Ends 14 Mar
$A 1190
per person + tax $200 saving
Regular
Ends 7 Apr
$A 1390
per person + taxAdditional 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 informationCan't see what you need?
Download our training catalogue to review all available topics
Download full catalogue
