Power BI INTERMEDIATE
A Virtual Classroom Training Intensive
Split Over 3 Engaging Sessions – Online | Tuesday 23 – Thursday 25 May 2023
Tues 1:00-3:30pm, Weds 1:00-3:30pm, Thurs 1:00-4:00pm (AEST)
If you have a keen understanding of Power BI and are looking to take the next step in your journey with this powerful analytical tool, this is the course for you!
We are excited to invite you to our first intermediate virtual event with RonInsight’s Power BI expert and trainer Michael Scholtz.
The Power BI Intermediate training course for Government is split over three days and offers a hands-on experience designed to provide government employees with the skills and knowledge needed to effectively use Power BI.
Are you are 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 and is the perfect, most logical step for those with a fundamental understanding of this robust data visualization program.
The course covers topics such as data connectivity, data transformation, visualizations, dashboards and reports, collaboration and sharing, security, customizing Power BI, and best practices for using it in government environments. Participants are expected to have a basic understanding of Power BI and its features, as well as some experience working with data. The course is taught by experienced trainer Michael Scholtz and is an immersive, hands-on experience focused on the practical application of Power BI. By the end of the course, participants will have a comprehensive understanding of Power BI and be able to use it to build effective data-driven insights to support their work.
MEET THE FACILITATOR
Hi, I’m Michael Scholtz the owner and founder of RoninSights and I love Power BI! This unique and robust product is my primary tool in bringing data driven professionals closer to their data; in turn helping them make better data driven decisions. With over a decade of analytical experience, I have created reports across multiple industries spanning from USA, Europe and APAC and now I want to share these skills and Power BI knowledge with you.
I realised that data driven insights might not always apparent to the business, that stakeholders who have the most to gain are not always capable or willing to do the analysis themselves and that those who have the most to gain, might be resistant to changing the status quo.
Turning data into meaningful and impactful insights, enabled me to improve customer experience, grow revenue channels, reduce waste, save time, improve staff/customer retention rates and change the mindset of an entire organisation.
THE COURSE CURRICULUM
This government tailored training taking place over three consecutive business days is designed to help you develop the intermediate skills in bit size chunks; skills that will be directly applicable to your day-to-day business activities. The staggered approach enables you time to digest the information, put it into practice and return the following morning to pick up where you left off, with your new information still fresh in the memory. The final day will culminate in a personal project where you will demonstrate your newly acquired skills and develop your own stunning Power BI report. You can then share these dashboards with teams, business partners and publish them to the web.
The Course will be run on:
Tuesday 23/5/2023 – 1:00 – 3:30pm (AEST)
Wednesday 24/5/2023 – 1:00 – 3:30pm (AEST)
Thursday 25/5/2023 – 1:00 – 4:00pm (AEST)
NOTE: ALL OF OUR FUNDAMENTALS SESSIONS IN THE PAST HAVE SOLD OUT QUICKLY, SO DUE TO POPULAR DEMAND WE HAVE WORKED WITH MICHAEL TO DEVELOP AN INTERMEDIATE ITERATION OF THE POWER BI CATALOGUE, GET IN WHILE YOU CAN!
The course will cover the following topics and more:
- Creating relationships
- Relationships structure, filtering directions
- Unique ways of creating a report look and feel
- Choosing a design template
- Simple DAX (Count, Sum, averages and measures within measures etc)
- Dax intermediate (Calculate and time intelligence formula’s)
- Creating DIM_DATES and Fiscal DIM_DATES from front and back end
- Grouping, merging tables and calculations for data transformation
- M Language for Transforming Data
- Creating Visuals and importing Visuals
- Lay Out Concepts
- Embracing Bookmarks to create something unique
- Pushing visuals further
- Implementing Page Indexing
- Publishing
- Creating a Dashboard
- What can be done online
- Creating a simple App
KEY TAKEAWAYS
Data Transformation: Power BI includes a powerful data transformation tool called Power Query, which allows you to clean, shape, and transform your data into a format that is suitable for analysis and reporting.
Data Visualization: Power BI allows you to create interactive and visually appealing reports and dashboards by utilizing various charts, graphs, and tables to represent data in a meaningful way.
Registration
5% discount will be offered to group registrations of more than 10 learners
10% for group registrations of more than 20 learners
For group discounts please contact us at [email protected]
*Registration for this event is for Public Sector Employees only*
Interested In Learning More?
