Online Training

Power BI Intermediate

Harness the power of your data

26 & 27 June 2024

9:00 AM - 12:30 PM AEST

Next intake: 26 & 27 June 2024 | 9:00 AM - 12:30 PM AEST

Overview

Power BI allows business users to perform sophisticated data analysis, turning data into actionable insights. In this course, we take a deeper dive into the Power BI Desktop programme, looking at 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 training 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. The training 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.

Who Should Attend?

Data Analysts
Business Intelligence Specialists
Power BI Report Creators
IT professionals

Learning Outcomes

Advanced data modeling techniques for optimising performance and data accuracy
Develop an understanding of DAX functions for more complex data analysis
Created of sophisticated interactive reports including some of Power BI’s newest visualisation tools

Online Training

Power BI Intermediate


Session details

  • Become more proficient in analysing data, which is essential for evidence-based decision-making and policy development
  • Create interactive and informative reports and dashboards that facilitate better decision-making
  • More cost-efficient government operations, making it a valuable skill for government employees and leaders
View course modules

Level: Intermediate

Some familiarity with topic is recommended

or

Get this course using subscription credits. Learn more

This course requires 1 credit.

Key Sessions

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

• Add Columns
• Unpivot and Group
• Data Profiling

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

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

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

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

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

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

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

• Use the Performance Analyser
• Add Row Level Security

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

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 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

Early Bird

Ends 10 May

$A 995

per person + tax $200 saving

 

Regular

Ends 25 Jun

$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 5-10 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