Until now, building Business Intelligence 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.
Learning to use Power Query means less time spent manipulating data and more time analyzing it to gain powerful insights and make better decisions.
Power Query will save you hours of time gathering and preparing your data before loading it into your data model.
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?
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.
From there, 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 comprehensive Power Query course anywhere! Plus, everything your learn in applicable to both Excel and Power BI.
First release of the course as the complete Power Query Academy (course was formerly two separate courses: Power Query Essentials and Power Query Advanced).
New lessons added to the course:
New lessons added to the course:
Release of Master Your Data with Excel and Power BI book (formerly titled M is for (Data) Monkey). Course registrants now receive the new second edition instead of the original first edition.
New module added to the course called Allocating Values to Periods, which contains 10 new lessons:
Updates to two existing lessons in the Simple Transformation Techniques module:
Updates made to the Power Query Recipes:
This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.
On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.