Power BI for
April 4 & 11, 2024 | 1:00 PM – 3:30 PM EST | Online
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
Build your Power BI report for hands-on expertise.
Explore report and dashboard creation essentials.
Leverage Power BI Desktop for compelling visuals and impactful data presentation.
Meet Your Facilitator
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.
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
- Interacting with visuals
- Drilling up, down, into and through
- Conditional Formatting
- Filters on this visual
- Filters on this page
- Filters on all page
Navigating the “Power Query Editor”
- Add Column
Common functions and queries
- Enter Data
- Choose Columns
- Remove Columns
- Keep or Remove Rows
- Split Columns
- Merge and Append queries
Transform – When to use “Transform” or the “Add Column” Tab
- Detect Data Types
- Replace Values
- Move Columns
- Merge or split columns
- Date / Time / Duration
Bringing it all Together & Q&A
- Using “Analytics” within Visuals
- “Get more visuals”
- Adding Buttons and Bookmarks
- Booked marked filters