Online Training

Power BI Intermediate for Government

Uplift your business intelligence and analytical skills and capabilities

June 17 & 18, 2025

11:00 AM - 3:00 PM ET

Next intake: June 17 & 18, 2025 | 11:00 AM - 3:00 PM ET

Overview

Microsoft Power BI is a leading business intelligence (BI) tool that empowers government professionals to transform complex datasets into actionable insights. As data-driven decision-making becomes increasingly critical in federal, state, and local agencies, Power BI provides a robust solution for analyzing, visualizing, and securely sharing data across departments. 

This Power BI Intermediate course is designed for professionals with a foundational understanding of Power BI who are looking to expand their skills in data modeling, reporting, and analysis. The course will explore advanced techniques for cleaning, transforming, and analyzing data, as well as best practices for creating dynamic dashboards, interactive reports, and secure data applications that meet agency needs. 

Participants will gain proficiency in DAX (Data Analysis Expressions) functions to perform complex calculations and uncover deeper insights. Additionally, they will learn how to optimize performance, security, and visualization techniques to enhance data storytelling and support mission-critical decision-making. 

With the skills gained in this training, attendees will be equipped to drive data-informed decisions, improve operational efficiency, and support transparency initiatives within their agencies. 

By attending this course, government professionals will gain the skills and confidence needed to harness the power of data and support agency objectives through actionable insights. 

Learning Outcomes

Perform advanced data transformations, including merging, appending, unpivoting, and grouping data.
Apply the M language to customize data processing and improve automation.
Enhance data quality through fuzzy matching and data profiling techniques.
Build optimized data models that improve performance and accuracy.
Utilize DAX functions, such as CALCULATE and Time Intelligence, for advanced analytics.
Incorporate geospatial visuals, drill-downs, hierarchies, and custom sort orders to enhance reports.
Implement interactive filtering, including synchronized slicers, drill-throughs, and cross-filter editing.
Apply row-level security to restrict data access based on user roles.

Online Training

Power BI Intermediate for Government


Session details

  • Data-Driven Government: U.S. federal, state, and local agencies are rapidly adopting data-driven decision-making strategies. The Federal Data Strategy and the Evidence-Based Policymaking Act underscore the importance of leveraging tools like Power BI to drive transparency, accountability, and efficiency. 
  • Reduce Dependence on BI Teams: According to Gartner, by 2025, 80% of analytics will be performed by business users rather than dedicated data analysts. This shift makes Power BI proficiency a critical skill for professionals at all levels. 
  • Power BI’s Impact on Government: 90% of Fortune 500 companies and a growing number of U.S. government agencies use Power BI for reporting, analysis, and operational intelligence. Its ability to integrate real-time data across systems has made it a key asset for agencies managing complex programs. 
  • Self-Service Analytics for Agencies: Power BI allows agencies to democratize data access by enabling non-technical professionals to generate insights without relying on IT or BI teams. This enhances efficiency and enables faster decision-making. 
  • Move Beyond Static Reports: Instead of relying on Excel spreadsheets and outdated reporting systems, agencies can leverage Power BI to create interactive, real-time dashboards that improve communication with stakeholders and drive better policy decisions. 

 

By attending this course, government professionals will gain the skills and confidence needed to harness the power of data and support agency objectives through actionable insights. 

View course modules

Level: Intermediate

Some familiarity with topic is recommended

Key Sessions

11.00am 

Welcome and Opening Remarks 

Session 1 

Overview of Power BI and Data Transformation 

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

1:00pm 

Break 

Session 2 

Data Modelling in Power BI 

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

3:00pm 

End of day 1 

11:05am 

Welcome and Recap 

Session 1 

Visualizing Data in Power BI 

  • 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 

1:00pm 

Break 

Session 2  

Advanced Features and Power BI Service 

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

3:00pm 

End of day 2 

Meet Your Facilitator

Shannon Lynch

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

What your peers had to say

slide 5 to 7 of 3

Register Today

Join this training for professionals working within the Public Sector

Pay for individual courses

Early Bird

Ends 2 May

$795 CAD

per person + tax $200 saving

 

Regular

Ends 16 Jun

$995 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 training@publicsector.academy

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