Online Training

Power BI for Government – Intermediate

“A great mix of theory and practical application. A great selection of practical tools to takeaway and use”

July 16 & 23, 2024

1:00PM - 5:00 PM EST

Next intake: July 16 & 23, 2024 | 1:00PM - 5:00 PM EST

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

Course Inclusions

  • 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
    • Harnessing the POWER of Power BI Desktop. Create
    fantastic Power BI visuals and present data with style

Learning Outcomes

Construct your Power BI report, gaining a comprehensive, hands-on understanding of the software.
Explore the fundamentals of crafting and editing reports and dashboards.
Unlock the potential of Power BI Desktop, creating compelling visuals and delivering data with style.

Online Training

Power BI for Government – Intermediate

Session details

This two-day training course will enable you to enhance your skills on Power BI, allowing you to create interactive and visually appealing dashboards and reports, among other advanced tools that Power BI offers.

View course modules

Level: Intermediate

Some familiarity with topic is recommended

Register Now Pricing options

Key Sessions

Day 1: An in-depth exploration of Power BI nuances with the agenda encompassing strategic discussions on relationship building, innovative report design, and a comprehensive dive into essential DAX applications. This is followed by hands-on applications, featuring the creation of DIM_DATES and Fiscal DIM_DATES, adept use of M Language for data transformation, and mastery of visuals and layout concepts. The day concludes with a dynamic Q&A session, ensuring participants are well-prepared for the advanced topics awaiting them.

Day 2: Explore advanced data manipulation with sessions on grouping, merging tables, and crucial calculations. Dive into transformative tools like “Transform” and the “Add Column” tab, covering key applications such as detecting data types and formatting. The afternoon focuses on integrating advanced features, including clustering, analytics within visuals, and enhanced interactivity with buttons and bookmarks. The day concludes with a practical session, letting participants showcase their skills through personal projects and engaging show-and-tell presentations.

Uncover the principles and techniques behind establishing robust connections within your datasets, laying the groundwork for insightful data analysis and visualization.

Understand the structural dynamics of your datasets and gain mastery over filtering directions. This session empowers you to fine-tune data interactions, ensuring a precise and insightful analytical experience.

Uncover innovative techniques to design visually compelling and distinctive reports. Learn to customize the look and feel of your reports, making them not just informative but visually engaging.

This session equips you with the skills to make informed decisions in aligning your data stories with visually appealing templates

Explore fundamental functions like Count, Sum, Averages, and the art of crafting measures within measures. This hands-on module equips you with the foundational skills to perform basic calculations and enhance your analytical capabilities using Data Analysis Expressions.

Advance your DAX expertise in our Power BI Intermediate training with the “DAX Intermediate” module. Delve into the intricacies of Calculate and Time Intelligence formulas, mastering advanced techniques for precise data analysis.

Learn advanced techniques to seamlessly group and merge tables while mastering crucial calculations for transformative data outcomes.

  • Detect Data Types
  • Replace Values
  • Move Columns
  • Format
  • Merge or split columns
  • Date / Time / Duration

• Clustering
• Grouping
• Using “Analytics” within Visuals
• “Get more visuals”
• Adding Buttons and Bookmarks
• Booked marked filters

View Training Guide

Meet Your Facilitator

Michael Scholtz

Founder & CEO, RoninSights

Meet Michael Scholtz, the passionate owner and founder of RoninSights. With over a decade of analytical experience spanning the USA, Europe, and APAC, Michael is dedicated to utilizing Power BI as a primary tool. His mission is to bring data-driven professionals closer to their data, facilitating better decision-making. Michael specializes in Business Analytics, Content Marketing, Social Media Marketing, Digital Marketing, Lead Generation, and Email Marketing. Recognizing the challenges in translating data insights, he aims to share his expertise and Power BI knowledge. Through his journey, Michael has transformed data into impactful insights, leading to improved customer experiences, revenue growth, waste reduction, time savings, and enhanced staff/customer retention rates. Join him in changing organizational mindsets through meaningful data analysis at RoninSights.

 

Register Today

Join this training for professionals working within the Public Sector

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