Online Training

Power BI Intermediate for Government

Unlock the full potential of your data

November 19 & 21, 2024

11:00 AM - 1:00 PM ET

Next intake: November 19 & 21, 2024 | 11:00 AM - 1:00 PM ET

Overview

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 modeling techniques, empowering attendees to optimize the performance and accuracy of their data.

The course also covers the use of Slicers, Filters, and Drill-through, 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 visualization
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
Reporting and Performance Specialists
Analysts

Learning Outcomes

Build your own Power BI report and develop a comprehensive hands-on understanding of the software.
Discover the fundamentals around creating and editing reports and dashboards.
Create fantastic Power BI visuals and present data with style.

Online Training

Power BI Intermediate for Government


Session details

• Build and understand Power BI software.
• Understand report creation and editing.
• Create visually appealing Power BI visuals.
• Present data professionally

View course modules

Level: Intermediate

Some familiarity with topic is recommended

Key Sessions

The session will run from 11am to 1pm ET. With a 30 min break and time for Q&A. 

Additional Details:  

  • Hands-On Labs: Hands-on exercises after each topic to reinforce learning. 
  • Q&A Sessions: The schedule will include time for questions and answers throughout each day.

 

  • Review of Power BI and its Components 
  • Data Sources and Connections 
  • Introduction to Query Editor 
  • Data Cleaning and Transformation Techniques 
  • Data Shaping and Transformations (Merging Queries, Grouping and Aggregating Data)

 

  • Best practice for effective Data Modeling
  • Creating Relationships between Tables 
  • Hierarchies and Drill-down 

  • Introduction to Data Visualization Principles 
  • Data Storytelling Principles 
  • Creating Reports in Power BI Desktop 
  • Enhancing Reports with Slicers, Filters, and Drill-through 
  • Introduction to Interactive Reports

  • Usability Enhancements (Themes, Bookmarks, Drill-through) 
  • Introduction to Power BI Service 
  • Publishing Reports to Power BI service • Sharing and Collaborating on Reports

Meet Your Facilitator

Shannon Lynch

PowerBI Coach

With a passion for data visualization and a knack for turning complex information into easily digestible insights, Shannon is the go-to guy for all things Power BI. When he’s not crafting visually stunning dashboards and reports, you can find him sharing his knowledge and expertise as a Power BI trainer and consultant.

Shannon’s unique blend of technical skills and creative flair have made him a hit with clients, who rave about his ability to turn their data into powerful storytelling tools.

Register Today

Join this training for professionals working within the Public Sector

Pay for individual courses

Early Bird 1

Ends 13 Sep

$795 CAD

per person + tax $400 saving

 

Early Bird 2

Ends 11 Oct

$995 CAD

per person + tax $200 saving

 

Regular

$1195 CAD

per person + tax

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