Power BI for
Government Fundamentals

April 4 & 11, 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!

connecting to and visualizing data

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 charge in all three levels of government including:

Excel Users and anyone working with data.

Beginner Level Data Management and Analytics Community.

Local Data Gurus

Learning Outcomes

Practical Mastery:

Build your Power BI report for hands-on expertise.

Fundamental Skills:

Explore report and dashboard creation essentials.

Visual Power:

Leverage Power BI Desktop for compelling visuals and impactful data presentation.

Meet Your Facilitator

MICHAEL SCHOLTZ
RoninSight, Founder

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

Early Bird 1


until
January 19, 2024

Save $400

$595 USD

per person + tax

Early Bird 2


until
February 23, 2024

Save $200

$795 USD

per person + tax

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.

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