Power Query Booster (1 day)

Take your Power Query skills to the next level, handling more complex data and reporting scenarios.

Contact Us Today

Improve Your Power Query Expertise for Advanced Data Solutions

Power BI is taking the world by storm, allowing for amazing transformation in the way you use and present data. Power Query is fundamental in shaping data into the ideal layout to simplify reporting and analysis.

This course dives deep into Power Query functionality and the “M” language, providing hands-on experience with practical examples to solidify your understanding. Focused on Power BI Desktop applications, this course will equip you with the skills to handle sophisticated data transformations efficiently.

What you get from this course

  • This intermediate to advanced hands-on course is focused on enhancing your understanding of the amazing capabilities of Power Query and the ”M” language.
  • We recommend you attend our Power BI Essentials course before attending this more advanced session.
  • In this course we focus on the core elements needed to get an in-depth understanding of how Power Query works, and the application of this knowledge on real-world practice examples. While Power Query is also available in Excel this course is focussed on the application of Power Query and the “M” language in Power BI desktop.
  • From this course you get a solid understanding of Power Query functionality, the “M” language, and how to handle more complex data transformations.

Pre-requisites

This is an intermediate to advanced course, and users should already be familiar with basic concepts of Power Query connecting to data sources and loading data into the data model.

If you are not confident with these concepts, then we recommend you attend our Power BI Essentials course before attending this more advanced session.

Full course outline

  • Discover the secrets of data shaping and data modelling that will enable you to simplify your DAX functions and calculate reports faster
  • Learn techniques to clean up very disorganised source data sets.
  • Understand why and how to create bridging tables.
  • Understand the concept of Query Folding. 
  • Understanding the importance of Lists
  • Minimise manual re-work and refresh failures by making steps dynamic instead of hard coding in values.
  • Merges, joins and =#shared
  • Learn Custom Functions while consolidating multiple sheets within an Excel workbook.
  • Merging queries with themselves.
  • Discover Dataflows, when to use them and best practice tips and advice.
  • See how to display events in progress based on a start and end date

We recommended our DAX Booster course to be run in conjunction with this course.  Shaping your data correctly with Power Query is key to simplifying your DAX, then DAX takes over to enrich your reports with dynamic calculations. To have great reports you need a solid understanding of both Power Query and DAX and how they work in tandem. 

We recommended running a coaching day. Bring your own data and apply your skills to work on your own, real-life Power BI project, with the guidance and coaching of our expert facilitator.

You’ll not only practise your newly learned skills, but you’ll also walk away with your own improved data models.

Who Should Attend

  • Power BI users who have reached a stage of understanding the basics and now need to extend their Power Query and “M” knowledge to improve their data model structure and to handle more complex data transformations.
  • Anyone who would like to extend their Power Query knowledge and gain a deeper understanding of how it works.

Delivery Options

In-house

All courses are available for in-house training, providing flexible options to meet your needs wherever you are – Perth, interstate, or internationally. Our in-house courses are designed to maximise value with flexibility, tailored content, and cost savings for your team.

Learn More

Virtual Training

Our virtual training options (in-house training only) bring the same high-quality, live, instructor-led courses directly to your team, no matter where they are located. Our virtual training features the same level of interaction as our in-person sessions, while providing the convenience of learning from any location. This option is ideal for interstate and international clients.

Learn More

Public Courses

Our public courses are located primarily in Perth (with options for interstate and international participants), providing individuals or smaller teams with the opportunity to join our comprehensive training sessions alongside other industry professionals.

Learn More

Upcoming Course Dates

Power BI Essentials (2 days) Face-to-Face Training

February 11, 2025 @ 8:30 am - February 12, 2025 @ 4:30 pm

A$1,499.00 – A$1,699.00

Our Public courses are aimed at smaller groups of 3 – 8 people so that there is more opportunity for the instructor to assist on a 1-1 basis and discuss the attendee’s specific real-world scenarios.

NOTE: For Public Courses a minimum of 3 attendees must have signed up 4 weeks in advance of the course otherwise the course will be postponed, and full refunds offered. The 3rd day option also requires a minimum of 3 attendees to proceed

Why Learn From Access Analytic

Practical

Highly experienced facilitators who actively and regularly consult with clients.

Applicable

Apply what you learn to your job to further your career.

Hands-on

The course is designed to provide maximum hands-on experience.

Passionate

Our facilitators love this subject!

Clear

We specialise in translating complex subjects into concepts that are easy to understand.

On-going help

You can always email the facilitator with any questions.

Comprehensive course notes

Useful working document to support your learning.

Networking

Meet industry peers and hear how they approach this subject.

Our Course Facilitators

Jeff Robson

Masters (Applied Finance), Bachelor of Commerce (Accounting & Information Systems), Certified Information Systems Auditor (CISA), Fellow of the Australian Institute of Management (FAIM), Fellow of the Financial Services Institute of Australasia (F Fin), Member of the Australian Institute of Company Directors (MAICD), Microsoft Excel Expert, International Presenter

Wyn Hopkins

Microsoft MVP, Published Author of “Power BI for the Excel Analyst”, B.Sc. (Hons) Accounting & Financial Management

Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”.

YouTube content creator:  over 5.5 million views and 95,000+ subscribers.

Yury Tokarev

PhD (Finance and Economics), Chartered Accountant with the Australian Institute of Chartered Accounting (CA), Bachelor of Business (Finance and Economics), Microsoft Certified Excel Expert (MCEE)

Our Clients

Client testimonials

We are thrilled to have helped hundreds of businesses in Perth and worldwide over the years.

Other courses you might be interested in

Maximising your excel productivity

Power Query Booster

DAX Booster for Power BI

Power BI Essentials

Power Query in a Day

Power Query & Power Pivot for Excel

Advanced Budgeting & Forecasting

Financial Modelling in Excel Training Course

Learn from highly qualified finance professionals with international experience

Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.

Get Ahead of the Game – Book Your Training Now!