Power BI Fundamentals

Tuesday, 14 & Thursday, 16 November 2023 | 12:00 PM – 3:00 PM AEDT | Online

Training Overview

Harness the power of your data.

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

We are excited to invite you to our first virtual event with RonInsight’s Power BI expert and trainer Michael Scholtz. 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 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

Who Should Attend

This course is designed for:

Excel Users (time to step up)

Anyone who uses data
and Local Data Gurus

Beginner Level Data Management
and Analytics Community

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

Create fantastic Power BI visuals and present data with style

Harnessing the POWER of Power BI Desktop

Meet Your 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.

Key Sessions

Day 1: Module 1.1Day 2: Module 1.2 Day 2: Module 2.1 Day 2: Module 2.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
  • Visualisation
    • 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 pages

  • 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
    • Creating Dim Dates
    • Using the Advanced editor
  • Bringing it all together, advanced features, publishing and sharing projects
    • Clustering
    • Grouping
    • Using “Analytics” within Visuals
    • “Get more visuals”
    • Adding Buttons and Book marks
    • Booked marked filters
  • Demonstrate new skills in personal project, show & tell


Final Price


per person + GST

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.

Interested In Learning More?

The Data Management & Analytics Community provides a hub for public sector professionals from around the globe to learn, network, collaborate, benchmark, and share best practices with their peers. Become a member today for free and gain access to:

  • Live chats and digital forums
  • Global content library
  • Priority event registration
  • Networking opportunities with peers
  • Complimentary access to exclusive events and insights