It allows you to clean, reshape, and combine your data with ease, no matter where it comes from.
And it comes FREE with the Excel and Power BI software that you already own.
Learning to use Power Query means less time spent manipulating data and more time analyzing it to gain powerful insights and make better decisions.
Until now, building BI solutions has been a painful, repetitive process requiring a great deal of manual effort to clean, filter, and format data before it can even be used.
And updates have been tedious and error prone.
Power Query will save you hours of time gathering and preparing your data before loading it into your data model.
We are Miguel Escobar and Ken Puls, two of the world’s leading experts on Power Query and the partners behind Power Query Training.
Our best-selling book, M Is For (Data) Monkey, has become one of the top-rated resources for going from a Power Query beginner to expert.
Out of the book we developed our popular live online workshops, where we introduced hundreds of data wranglers like yourself to the magic of Power Query.
But demand grew, and people told us they wanted more.
They wanted to go farther, focus deeper on certain concepts, and be able learn at their own pace.
We listened and created a step-by-step program that will change the way you “Get & Transform” data forever.
We’ll walk you through the ENTIRE process of using Power Query to Extract, Transform, and Load your data in Excel and Power BI.
This course is created from a practical point of view, showcasing real-world examples and techniques that you can use right away.
You’ll learn the exact steps, formulas, and tricks from world-class experts that you can use to save hours of time. And the skills you learn here can be used in both Excel and Power BI (and actually anywhere else Power Query lives, such as Flow and Power BI dataflows!)
Finally, you can Master Your Data instead of having it master you!
For subscribing to any of our plans, you’ll receive digital copies of our top-selling book, ‘M is for Data Monkey’, and our handy Power Query Recipes collection.
Unlike other video courses, Power Query Academy never goes stale. Our updates include new features and enhancements for Power Query, allowing you to stay on top of this constantly-evolving tool.
The best part? All of these updates are FREE. You get new content at no extra cost.
We don’t use an outsourced support team. If you need help with anything covered in the course, you can personally ask Ken and Miguel your questions.
Along with the technical support of two of the world’s leading Power Query experts, our helpful team is here to make sure you get the most from the course.
We have a quiz at the end of each module to help reinforce the information covered in the videos and allow you to apply your new knowledge.
Once you have finished the course, you will receive a Certificate of Completion to show off to your family and friends – or to just save for your records.
-said by our students
Is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. He has held the Microsoft MVP distinction since 2006, and has been recognized as a Fellow of his accounting organization.
Is an Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks. He has been recognized as a Microsoft MVP, MCP – MCSA: BI Reporting and a Microsoft Certified Trainer (MCT).
Reviews on the #1 book about Power Query for Excel and Power BI worldwide: ‘M is for Data Monkey’
-Book written by Ken and Miguel
No matter how ugly your data, it needs to be cleaned for analysis, and the goal of our courses is to make you faster at doing exactly that. We don’t care how ugly your data is, or where it lives. As long as you can get access to it, we’re convinced that you can clean it up and import it using Power Query, and that you’ll save yourself time on a regular basis.
How much time? Great question…
Consider this scenario: a regulation changes in your industry, and every company is forced to hire a new full-time employee in order to process the data that now needs to be reported to the government on a monthly basis. Every company, that is, except yours. Why? Because you were able to automate the data processing and reporting using your amazing Power Query skills, reducing the job to 15 minutes per week.
This isn’t a hypothetical scenario, this really happened for one of our clients. An average of 160 person-hours was reduced to a single hour, using Power Query. How amazing is that? Where their competition all ended up adding a full-time employee to their corporate overhead, our client didn’t need to. That means they’ve been able to get a competitive advantage over their competitors based on what they’ve learned from our material.
Or how about the client who was able to take the rent-arrears report which took a full day of manual effort to create every single week? What would you say if you could take a job like that, and reduce it to the click of a single button that now only takes a couple of minutes? Would you like to save 52 person days of manual effort per year? Of course you would! And yes, that truly happened.
Now let’s be fair. It would be irresponsible of us to promise you that you’ll save 52 person-days per year, or a full time employee on an annual basis by learning our techniques. Not everyone will realize those kinds of productivity gains.
But, what we can say is that we routinely get emails from people telling us that they’ve saved 4-5 hours of manual labour per week based on the things they’ve learned from our material. Think about that for a second… What if you saved only 3 hours per week? Multiply that by your hourly rate, and by 50 working weeks per year. It’s a lot of money, isn’t it? And what if you could use that time to learn even more about Power Query and automate other processes as well?
There’s one more thing that we really want you to think about here. Do you enjoy cleaning up the same data on a weekly or monthly basis? Is that satisfying for you? Wouldn’t you be more interested in analyzing that data and drawing conclusions from that data? You know – the job you were actually hired for?
Let us help you!
Our courses are built from a practical point of view, showcasing real-world examples and techniques that you can use right away. You’ll learn the steps, formulas, and tricks from world-class experts that will save you hours of time on a weekly basis. Let us help you get the data-cleaning out of the way, so that you can focus on the satisfying part of the job: providing the insights that you were actually hired to deliver.
This course starts at the beginning, and is intended for people who have never used Power Query at all, those who are self taught and want to ensure they haven't missed anything, or those who just want great coverage of all of Power Query's core features.
You'll learn basic transformation techniques and methods to clean up a variety of common data challenges, as well as how to pull data from various data sources and pull them together into a single refreshable solution that will save you hours of time on a monthly basis.
Do you already know Power Query, but are looking to go deeper? Our Advanced course is all about building on the core knowledge you already have. You'll learn how to unwind difficult data patterns, dive deep into the underlying M language, and complement user-interface-driven actions with a sprinkling of code to build amazing and practical solutions. Power Query formulas, custom functions and even pro tips for future proofing solutions and improving performance; you'll pick up the skills to make you a data ninja.
Simply put: you won't find a more advanced Power Query course anywhere!
Check out all the available options and pick the subscription that suits you best. We created this comparison table so it’s easier for you to see the available content across our courses.
NOTE: all prices are in US dollars; please see the FAQ section below for more information on payment methods, currency, refunds, etc.
|Power Query Essentials||Power Query Advanced||Bundle Option|
$39/year after that
$69/year after that
$99/year after that
|Course Summary||Course Summary|
|Access Length||1 Year||1 Year||1 Year|
|Price for First Year of Access|
|Price for First Year of Access||$120||$270||$350|
|Annual Renewal Fee|
|Annual Renewal Fee||$39||$69||$99|
|Hours of Video|
|Hours of Video||9+||9+||16+
(all from Essentials and Advanced)
|Number of Lessons|
|Number of Lessons||41||36||79
(all from Essentials and Advanced)
|Number of Quizzes|
|Number of Quizzes||7||8||15
(all from Essentials and Advanced)
|Number of Workshop Labs|
|Number of Workshop Labs||3||3||6
(all from Essentials and Advanced)
|Ongoing Support from our Trainers|
|Ongoing Support from our Trainers||✔||✔||✔|
|Access to Discussion Groups|
|Access to Discussion Groups||✔||✔||✔|
|Certificate of Completion|
|Certificate of Completion||✔||✔||✔|
|Content updated and/or added|
|Content updated and/or added||every 4 months||every 4 months||every 4 months|
|Course Curriculum Summary||Course Curriculum Summary|
|Power Query Academy Intro|
|Power Query Academy Intro||✔||✔||✔|
|Power Query Academy Intro|
|Importing Basic Data||✔||✔||✔|
|Simple Transformation Techniques|
|Simple Transformation Techniques||✔||✔|
|Connect to Web Based Data Sources|
|Connect to Web Based Data Sources||✔||✔|
|Connect to Miscellaneous Data Sources|
|Connect to Miscellaneous Data Sources||✔||✔|
|Connect to Data from Relational Sources|
|Connect to Data from Relational Sources||✔||✔|
|Introduction to Conditional Logic|
|Introduction to Conditional Logic||✔||✔|
|Advanced Data Reshaping|
|Advanced Data Reshaping||✔||✔|
|Formulas and Conditional Logic|
|Formulas and Conditional Logic||✔||✔|
|M Language Deep Dive|
|M Language Deep Dive||✔||✔|
|Parameters and Custom Functions|
|Parameters and Custom Functions||✔||✔|
|Advanced M Techniques|
|Advanced M Techniques||✔||✔|
|Date and Time Techniques|
|Date and Time Techniques||✔||✔||Query Optimization|
Yes, you read that right. You can try our free Power Query Fundamentals course with no obligation at all. It contains about 1.5 hours of video content, and will give you a great feel for our style and the material at hand. In this course, you’ll learn how Power Query works, how to pull in data, and refresh and edit queries!
Not at all. If you’ve never heard of Power Query before, our courses will get you up to speed with the most powerful tool in data transformation. And if you’ve already used Power Query, you’ll get a quick refresher on the fundamentals before learning more advanced concepts.
We’ve structured the courses to take you from novice to expert. And wherever you are on your learning journey, you’ll be challenged.
If you prefer, you can start with the Power Query Essentials course and then later upgrade to the Bundle option (see more details in the FAQ about renewing, upgrading, and cancelling subscriptions).
Refunds are not available on course registrations; all sales are final.
You can choose to cancel your subscription at any time, and will continue to have access to the course materials until your expiry date (please see the FAQ regarding renewing, upgrading, or cancelling subscriptions).
Registration and access to the course is intended for one person only and cannot be transferred another user. Logins and downloads are not to be meant to be shared.
We do offer group discounts on registrations of 3 or more people. For more information on group discounts, get in touch through our Contact Us page.
We accept credit card payments through our secure online payment portal, Stripe. If you would like to discuss other payment options, please get in touch through our Contact Us page.
All transactions are charged in US Dollars.
Our system will automatically renew your subscription for another year on your expiry date using the billing information on file. About a month before your current expiry date, you will receive an email from us reminding you that the renewal is coming up and to confirm your billing details.
If you purchase the Power Query Essentials course individually, you may later decide you want to upgrade to Power Query Bundle option. You can change your subscription by going to Billing > Subscriptions and selecting the “Upgrade or Downgrade” button next to your current subscription.
You may cancel your subscription at any time, and you will continue to have access to all of your course materials until your expiry date. After your subscription expires, you will not longer have access to the course materials, including the downloadable M is for Data Monkey book and Recipe Cards.
While our data files can come in a variety of different formats (just like in the real world), the only tool you need to connect to them is Power Query. What that means is you can follow along with our course using any of the following software tools:
Microsoft Excel (Windows versions only)
Yes, the quiz at the end of each module is required. Each quiz contains a set of randomized true/false and multiple-choice questions (usually 10 in total).
You must get at least 80% to pass the quiz. But don’t worry, you can retake the test as many times as you like!
After all the lessons have been completed and quizzes passed, you will receive an email with a link to your Certificate of Completion. You will then be able to download or print a copy for your records.
Yes, we do offer group discounts on registrations of 3 or more people. For more information on group discounts, please get in touch through our Contact Us page.
Please note that group discounts cannot be combined with any other discounts or offers.
Yes, we do have an affiliate program if you would like to sell our courses and other products on your website! For more information, please get in touch through our Contact Us page.
All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.
In just a few minutes, you could be learning our Power Query techniques to skyrocket your productivity.
Click the Sign up button below, pick the plan of your choice, fill out your payment details on the next page, and in a few minutes, you’ll be moving through the first module of the course.
Yes, of course you do! Here are some other ways you can begin to leverage Power Query in Excel and Power BI: