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