Online Training
Power BI Essentials for Government
Establish the foundations business intelligence and analytics
11 & 18 March 2025
9:00 AM - 12:30 PM AEDT
Next intake: 11 & 18 March 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 introduce the Power BI Desktop program and use it to fetch data from a variety of sources and then visually present our analysis in an interactive report. We then publish the report to the online service where we create a dashboard and look at how we use both to derive business insights.
If you have a keen interest in Data and want to find ways of automating the processes of collecting, cleaning and visualising it, this is the course for you! Join us for a fun, in-depth and practical hands-on introduction to self-service Business Intelligence.
Learning Outcomes
Online Training
Power BI Essentials for Government
Session details
- Set up a strong foundation in data skills
- Interpret data with sophisticated tools
- Expand self-service analytics and visualisation offerings
- Transform the way to present with powerful visuals
Level: Fundamentals
No previous experience necessary
Key Sessions
- What is Power BI
- Power BI Licensing
- Overview of Power BI Desktop
- Data Connection Options
- Get Data from Excel
- Introduction to Power Query
- Get Data from a Folder
- Understand Relationships
- Add and manage Relationships
- Use DAX to create Calculated Columns
- Use DAX to Create Simple Measures
- Set Page and Canvas Settings
- Add Images
- Change and Customise Themes
- Add and Manage Pages
- Add Map, Treemap & Card Visuals
- Work with Tables & Matrixes
- Add Line and Column Charts
- Work with Tool Tips and Cross Filters
- Focus Mode and Spotlight
- Sort and Drill Down
- Customise Visuals
- Rename, Add and Duplicate Pages
- Add Custom Visuals
- Use the Filters Pane
- Work with Slicers
- Publish to the Power BI Service
- Workspaces & Sharing Options
- Subscribe and Comment
- Spotlight and Bookmark
- Export Data from a Report
- Report vs Dashboard
- Create a Power BI Dashboard
- Work with Tiles and Q&A
- Customise for Mobile View
- How to find shared Reports
- How to find Apps
- Power BI for Mobile
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
Register Today
Join this training for professionals working within the Public Sector
Pay for individual courses
Extra Early Bird
Ends 17 Jan
$495 AUD
per person + tax $400 saving
Early Bird
Ends 14 Feb
$695 AUD
per person + tax $200 saving
Regular
Ends 10 Mar
$895 AUD
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
