Online Training

Power BI Dax

Your key to advanced data calculations

30-31 October 2024

9:00 AM - 12:30 PM AEST

Next intake: 30-31 October 2024 | 9:00 AM - 12:30 PM AEST

Overview

DAX (Data Analysis Expressions) is the calculation language of Power BI. DAX enriches existing data, enabling you to perform sophisticated data analysis. It has the power to unlock insights that would not be possible by just dragging values into visuals.  

This course will enable participants to enhance existing data models and perform advanced data analysis. Mastering DAX will allow participants to uncover insights and trends that are not easily accessible through basic data manipulation. The course covers a wide range of topics from the basics of DAX to advanced filtering and time series intelligence, ensuring a thorough grasp of DAX functionality. 

Participants will also learn to use DAX tools like DAX Studio and DAX Formatter to debug and optimize their queries, making their Power BI reports more efficient and effective. The skills gained from this course will empower attendees to leverage the full power of DAX, making their data analysis more robust and insightful, ultimately leading to better data-driven decisions. 

Who Should Attend?

Professionals from diverse backgrounds who require advanced data analysis skills in their roles
Advanced Excel users who create reports
Data and Business Analysts
Local Data Gurus
All corners of government - Federal, State & Local

Learning Outcomes

Understand the syntax and wide range of functions in DAX
Optimise data models and reporting capabilities in Power BI
Perform sophisticated time series analyses and manipulate data context and refine analysis
Utilise DAX tools like DAX Studio and DAX Formatter

Online Training

Power BI Dax


Session details

  • Uncover insights that basic data manipulation cannot reveal 
  • Build more efficient and effective data models using calculated columns, measures, and advanced filtering techniques 
  • Gain skills to create more informative and visually appealing Power BI reports that provide significant value to stakeholders 
View course modules

Level: Advanced

Familiarity with the topic is required

or

Get this course using subscription credits. Learn more

This course requires 1 credit.

Key Sessions

Meet Your Facilitator

Nicky Bull

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. 

Register Today

Join this training for professionals working within the Public Sector

Pay for individual courses

Extra Early Bird

Ends 16 Aug

$A 795

per person + tax $400 saving

 

Early Bird

Ends 13 Sep

$A 995

per person + tax $200 saving

 

Regular

Ends 29 Oct

$A 1195

per person + tax

Use training credits

Subscription

Pay today using:

1 credit

Subscribe & save with pre-purchased credit. See more

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

Subscription options

Achieve great value with our customised subscription plans.

Become a member today and upgrade to Premium to access training credits and much more...

Starter

10%

discount off course prices

Purchase at least 3 training credits*

Requires commitment to promote Public Sector Network courses internally


  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

Bronze

15%

discount off course prices

Purchase 6-15 training credits*


  • Dedicated account manager
  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

Silver

20%

discount off course prices

Purchase 16-30 training credits*


  • Dedicated account manager
  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

Gold

25%

discount off course prices

Purchase 31-50 training credits*


  • Dedicated account manager
  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

Enterprise

X%

to be discussed

Tailor-made training programs with flexible training credits shareable amongst your team across many courses


  • Learning & development consultant
  • Dedicated account manager
  • In-house training options
  • Premium report
  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

* Most full-day Public Sector Network courses (which may be split over two days) will require one credit, which is valued at approximately $US595 or $A795, plus tax

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