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
MICHAEL SCHOLTZ
RonInsights
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
- 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
Registration
Final Price
$1195
per person + GST
Interested In Learning More?
