Online Training
Power BI Intermediate for Government
Harness the power of your data
30 September & 1 October 2024
9:00 AM - 12:30 PM AEST
Next intake: 30 September & 1 October 2024 | 9:00 AM - 12:30 PM AEST
Overview
This course focuses on Power BI, a powerful tool for business users to analyse data and turn it into actionable insights. It covers practical solutions for data cleaning, transformation, and analysis, as well as features for creating secure reports, dashboards, and apps. The Power BI Intermediate training is designed for professionals with a basic understanding of Power BI, aiming to enhance their skills and gain deeper insights. The course covers advanced data modelling techniques, DAX functions, and visualisation tools for interactive dashboards and reports. The skills gained will enable informed decisions and success for departments and agencies.
Who Should Attend?
Learning Outcomes
Online Training
Power BI Intermediate for Government
Session details
• Essential for evidence-based decision-making and policy development.
• Facilitates interactive, informative reports and dashboards.
• Enhance cost-efficiency in government operations.
• Create transparent, easily understandable reports and dashboards.
Level: Intermediate
Some familiarity with topic is recommended
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
- Synchronize Slicers
- Create Drill Throughs
- Add Conditional Formatting
- Create Custom Tool Tips
- Add Navigation & Buttons
- Work with Bookmarks
- Use the Performance Analyzer
- 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 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 19 Jul
$A 795
per person + tax $400 saving
Early Bird
Ends 16 Aug
$A 995
per person + tax $200 saving
Regular
Ends 27 Sep
$A 1195
per person + taxUse training credits
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 informationCan't see what you need?
Download our training catalogue to review all available topics
Download full catalogue
