Using PowerBI to communicate effectively with data


PowerBI
Increasingly in today’s business environment we are all required to understand, analyse and present data. Tools such as Excel and Powerpoint are fine when it comes to basic data presentations, but when it comes to greater data challenges we all need more serious tools.
This course is designed to introduce both business and technical audiences to the basics of Microsoft’s PowerBI application. This workshop is intentionally designed to be very interactive and hands-on using a range of real-world examples, supported by clear and easy-to-understand frameworks and tips-and-tricks, that will elevate your practical skills for producing meaningful analysis of today’s data.
Paul will provide expert guidance through the maze of challenges facing all of us when asked to analyse ever-increasing amounts of data being produced for audiences around the world. You will be taken on an engaging journey through entertaining and informative hands-on examples, and gain insights for the real-world application for delivering compelling PowerBI reports that will help answer your critical business questions.

Paul Hodge
University Lecturer & Data Visualisation Evangelist
Paul has a passion for exploring the intersection between data, design, and storytelling. By elevating everyone’s potential to engage, inform, and leverage design principles, Paul believes that we all have the ability to inspire people and share our insights in ways that can improve the world and make it a more interesting place to live in.
Key benefits


Get direct hands-on experience building a fully interactive PowerBI report, using real-world data


Gain unique tips & tricks during this live fully interactive session


Understand why Microsoft’s PowerBI software has become the tool of choice for so many organisations
This masterclass is designed for:
Business professionals in the public sector who have no, or limited, experience using PowerBI, and want to build or elevate their skills. It is highly recommended for people with roles or responsibility for communicating insights or concepts using data.
Important: Set up & technology requirements
You will need to have Microsoft’s PowerBI software installed on your device to participate in the workshop. PowerBI must be installed prior to the workshop and usable.
Who is this workshop NOT for?
This workshop is designed as an introduction. Intermediate to more experienced users of PowerBI are not recommended to attend.

Agenda
Module 1 – Shaping Data
Opening remarks & virtual learning tips
Getting Started
- Getting to know the attendees
- Virtual learning tips
- Confirm attendee setup
Introducing the world of PowerBI
- The PowerBI framework
- Data preparation
- Analysis and modelling
- Presentation and user experience
- Building my first PowerBI report
Morning break
Data Preparation (Part 1)
- Using PowerQuery
- How to append and merge
- Introduction to the M-language
Close of Module One
Module 2 – Modelling & Analysis
Opening remarks & check-in
General discussion & Q&A
Data Preparation (Part 2)
- Basic data profiling
- Changing data types
- Resolving data errors
Data Modelling
- Defining data relationships
- Basic data formatting
- Identifying types of data
- Introducing measures
Morning break
Introduction to DAX (Part 1)
- Calculated measures
- Using measures in Visualisations
- Calculated measures vs. calculated columns
- Calculated Tables
Close of Module Two
Module 3 – Information Presentation
Opening remarks
General Discussion and Q&A
Introduction to DAX (Part 2)
- Understanding context
- Calculating ratios
- Calculating Rolling Average
PowerBI Data Visualisation
- Multi-page reports
- Synchronising slicers
- Editing visual interactions
- Bookmarks
- Page layout
- Publishing to the Cloud
Morning break
Beyond the Basics
- Adding visuals from the Microsoft store
- Advanced visualisation
- Additional resources and references
Close of Module Three & Workshop
Pricing
Save up until 16 February
+GST
Early bird pricing
Save $600
____________
Save up until 8 March
+GST
Early bird pricing
Save $400
____________
Save up until 28 March
+GST
Early bird pricing
Save $200
____________
Standard rates
+GST
An excellent course structured for even the most inexperienced. All participants were encouraged to be engaged with the instructor constantly monitoring each individual person’s progress through the chat in a very supportive way.”
Project Manager
Department of Defence
I totally recommend this course and found the sessions invaluable!! Paul is a great teacher, his style is relaxed and encouraging to learning, especially where a high amount of information is involved and at the end of training sessions you come out with a clear set of practical skills which allows you to confidently put up a PowerBI dashboard.”
Senior Officer
Asset Data & Systems, Environment NSW
I have done two courses with Paul Hodge and The Hatchery this year. Both very professional and more importantly, useful. I now understand how PowerBI works, how to use it effectively, and how to find out more. The Zoom format is very smooth and the half day sessions were timed just right.”
Director
Technology Collaboration and Communication Unit, Australian Criminal Intelligence Commission
The course was fantastic. Very interactive and easy to follow. I feel really confident in being able to generate interactive visualisations using PowerBI after this course. Paul was very engaging, inspiring and highly knowledgeable on the topic and was willing to cover additional content on request.”
Assistant Director
Department of Health & Aged Care
It was a great course. Paul was obviously very experienced and passionate about the topic. The course covered major points well and help was available when issues came up”
Data Analyst
Department of Social Services