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
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.
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.
Upcoming Course Dates
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.
Head of Analysis large multinational client
Chevron Employee
Other courses you might be interested in
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!