Power BI for
Government Fundamentals

January 16 & 23, 2024 | 1:00 PM – 3:30 PM EST | Online

Training Overview

If you have a keen interest in Excel and are looking to upskill in the world of Power BI, this is the course for you!

Power BI Fundamentals for the Public Sector is Not Just a Training Session Government Overview.

We are excited to invite you to our virtual event with Power BI expert and trainer Michael Sholtz. No matter if you are the resident data guru in your business or just learning the ropes, please consider joining us for this comprehensive look at the Power BI Fundamentals.

Are you interested in connecting to and visualizing data? With Michael’s expert guidance, you will discover how to use this unified, scalable platform for self-service and Business Intelligence.

This program is a thorough, hands-on experience offering a practical look toward gaining deeper, more meaningful data insight

Who Should Attend

This course is designed for heads, directors, assistant directors, managers, and team leaders in charged in all three levels of government including:

Excel Users who want to step up; Anyone who uses data

Beginner Level Data Management and Analytics Community

Local Data Gurus

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.

Harnessing the POWER of Power BI Desktop.

Create fantastic Power BI visuals and present data with style.

Meet Your Facilitator

MICHAEL SHOLTZ

Michael Scholtz is the owner and founder of RoninSights, and he has a profound passion for Power BI. This unique and robust tool serves as his primary instrument for bringing data-driven professionals closer to their data, thereby assisting them in making more informed decisions based on data. With over a decade of analytical experience, Michael has crafted reports across various industries, spanning regions such as the USA, Europe, and APAC. Now, he is eager to share this wealth of knowledge in Power BI and data analysis with you.

Michael recognized that data-driven insights may not always be apparent to businesses. Stakeholders who stand to benefit the most from these insights may not possess the capability or willingness to conduct the analysis themselves. Additionally, those who could gain the most might resist changing the established status quo. By translating data into meaningful and impactful insights, Michael has successfully improved customer experiences, expanded revenue streams, reduced waste, saved time, enhanced staff and customer retention rates, and transformed the mindset of entire organizations.

Michael Scholtz’s expertise extends beyond data analysis, encompassing a wide range of areas including Business Analytics, Content Marketing, Social Media Marketing, Digital Marketing, Lead Generation, and Email Marketing, making RoninSights a valuable resource for comprehensive data-driven solutions.

Key Sessions

Day 1: Module 1Day 2: Module 2

Connecting with your data sources – “Get data”

  • Discuss common data sources: General, Text, Currency, Decimal number, Whole number, Percentage, Scientific
  • Common data types
  • Formatting data types
  • Creating data tables on the go or pasting data into Power BI

Using the “Data” tab
Bringing “Fields” onto the canvas
Adding pages

Visualizations

  • Interacting with visuals
  • Drilling up, down, into and through

Formatting visuals

  • Font
  • Colours
  • Conditional Formatting

Using Filters

  • Filters on this visual
  • Filters on this page
  • Filters on all page

Navigating the “Power Query Editor”

  • Home
  • Transform
  • Add Column
  • View

Common functions and queries

  • Home
  • Enter Data
  • Choose Columns
  • Remove Columns
  • Keep or Remove Rows
  • Sorting
  • Split Columns
  • Grouping
  • Merge and Append queries

Transform – When to use “Transform” or the “Add Column” Tab

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

Bringing it all Together & Q&A

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

Pricing

Regular Price

Limited slots

$995 USD

per person + tax

Additional discounts are available for group registrations of 10 or more.
For group discount inquiries, payment inquiries, or custom training solutions please contact [email protected]

* Registration for this training is exclusively for professionals currently working within the Public Sector.

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.