Power Query Academy
Transform your Data into Information and gain a competitive edge
Data Preparation represents 80% of Analysis work…
Cleaning up data can take hours
The dirty little secret of data analysis – the part that no one really wants to talk about – is that data preparation is the bulk of what you do. So how long does it take you on a weekly basis to transform your data into a format that is ready for PivotTables and reports? Minutes, hours, or even longer?
The world is full of hacks to try and speed up this terrible scenario… So what’s your secret? Did you learn a battery of keyboard shortcuts and repetitive actions that you perform regularly? Or maybe you considered investing time to learn to code in Python, R or VBA (Visual Basic for Applications)? The challenge – of course – is that the first has to be replicated each time you clean your data, and the latter involves a HUGE investment in time to gain competence.
There’s got to be a better way, doesn’t there?
The world is full of hacks to try and speed up this terrible scenario… So what’s your secret? Did you learn a battery of keyboard shortcuts and repetitive actions that you perform regularly? Or maybe you considered investing time to learn to code in Python, R or VBA (Visual Basic for Applications)? The challenge – of course – is that the first has to be replicated each time you clean your data, and the latter involves a HUGE investment in time to gain competence.
There’s got to be a better way, doesn’t there?
What if you could Master Data Cleansing and Transformation to Completely Automate your business intelligence and reporting?
Power Query is the most important data analysis tool since PivotTables
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.
Want to Master Power Query to Improve Business and Your Career?
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.
Introducing Power Query Academy
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!
Your subscription to the Academy includes
HD bite-sized videos
Premium content & instructors
Dozens of downloadable files
Workshop Labs
1-year access
Course Certificate
Quizzes
Direct support & discussions
Bonus Rewards!
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.
See Why So Many Have Rated It the Best Power Query Course for the Past 4 Years
Don’t Spend Any More Time Cleaning Data or Building Reports Before You See What We Have to Teach
Always Fresh. Updated Content Every 4 Months
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.
Top Support from the Course Creators
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.
Module Quizzes and Certificate of Completion
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.
The BEST Power Query course on the Planet
-said by our students
Previous
Next
Meet your instructors
Ken Puls, FCPA, FCMA
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.
Miguel Escobar
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).
Here are a few of our qualifications:
What people say about our book
Read More
Now I know what Power Query REALLY is!
I had been wondering for a while (like the past year or so) what Power Query was, but I was not really finding a good, clear answer. When this book became available I got a good, clear answer.
Read More
I would highly recommend this book to anyone in a Data Analyst or Reporting Analyst role.
Read More
For all the Excel users out there that are just discovering Power Pivot, do yourselves a big favor and go ahead and get familiar with Power Query as well - this is a good book to have on your shelf.
Read More
This book is worth every penny. PowerQuery is clear after half this book, and I was able to create massively complex queries that actually work. If you want your life to get easier, buy it.
Previous
Next
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
Our Power Query Academy Courses
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.
Power Query Essentials
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.
39 Videos
6.5+ hours
7 Quizzes
Certificate
Course Content
Power Query Advanced
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!
34 Videos
6.5+ hours
8 Quizzes
Certificate
Course Content
Join the Academy now!
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
|
||||
|---|---|---|---|---|---|---|
|
$120
$39/year after that
|
$270
$69/year after that
|
$350
$99/year after that
|
||||
| Course Summary | Course Summary | |||||
| Access Length | ||||||
| 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 | 8+ | 8+ | 15+ (all from Essentials and Advanced) |
|||
| Number of Lessons | ||||||
| Number of Lessons | 39 | 34 | 73 (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 | ✔ | ✔ | ✔ | |||
| Query Settings | ||||||
| Query Settings | ✔ | ✔ | ✔ | |||
| Simple Transformation Techniques | ||||||
| Simple Transformation Techniques | ✔ | ✔ | ||||
| Appending Data | ||||||
| Appending Data | ✔ | ✔ | ||||
| Merging Data | ||||||
| Merging Data | ✔ | ✔ | ||||
| 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 | ✔ | ✔ | ||||
| Managing Queries | ||||||
| Managing Queries | ✔ | ✔ | ||||
| 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 | |||
| Query Optimization | ✔ | ✔ | ||||
Not convinced yet? Try our FREE course!
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!
Frequently Asked Questions
Commonly asked questions and answers
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 Advanced or Bundle options (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.
Renewals:
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.
Upgrades:
If you purchase the Power Query Essentials course individually, you may later decide you want to upgrade to Power Query Advanced course or the full Bundle option. You can change your subscription by going to Billing > Subscriptions and selecting the “Upgrade or Downgrade” button next to your current subscription.
Cancellations:
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)
- Excel 365 (Windows desktop install as part of an Office 365 subscription)
- Excel 2016-2019
- Excel 2010-2013 with Microsoft’s free Power Query add-in installed
Power BI Desktop
- Power BI Desktop – installed via free download from Microsoft’s PowerBI downloads page
- Power BI Desktop – installed via the Windows Store
- Power BI Desktop – version specific to Power BI Report Server
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.
Tired of Manually Preparing Data and Updating Reports in Excel?
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.
Do I Have Other Options?
Yes, of course you do! Here are some other ways you can begin to leverage Power Query in Excel and Power BI:
- Trial and Error: Not a bad way to learn. But you’ll spend lots of time that you could be investing somewhere else. Ask yourself: “How quickly do I want results?”
- Other Power Query Courses: There are many excellent teachers out there. But how good is the content, how often is the course material updated, and is the trainer there to help answer your questions?
- Hiring a Consultant: Probably the fastest way to get a fully-built solution. But do you want to rely on a consultant every time you have a question, update a report, or build a new data model?