Leveraging Power Query to Get & Transform Your Task Flow
Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model.
The sad reality is that not all data is stored in nicely curated databases, and even when it is, the data analyst often doesn’t have access. Instead, we must piece together data provided in text files, Excel files, web pages, and even the body of emails to build the business intelligence solutions we need.
Until now this has been a painful, repetitive process with a great deal of cut and paste effort to clean, filter, and format data before it can even be used, and updates have been tedious and error prone. That ends right now!
If you need to learn one new tool today, Power Query is it.
With Power Query Academy, you’ll learn how to clean, reshape, and combine your data with ease, no matter where it comes from. Converting ASCII files into tables, combining multiple text files in one shot, and even unpivoting data is not only simple, but an investment in the future. You will save yourself hours of time gathering and preparing your data, and instead refresh your dashboard or report with a single click the next time you need it!
Power Query will change the way you "Get & Transform" data forever, and the skills you learn here are transferable between both Excel and Power BI.
Power Query Academy grew out of our popular live, online Power Query workshops. Due to the success of the workshops, demand grew for a video option catering to those who could not join us live for two days of training.
Power Query Academy will introduce you to the magic of Power Query and transform the way you work with data forever. What you learn here will save you hours of time that you can then use to explore your data, gain powerful insights, and make better decisions.
Ken Puls and Miguel Escobar, both top Power Query experts, will guide you as you learn to master this powerful tool, walking you through how to extract, transform, and load data in Microsoft Excel and Power BI Desktop.
Your registration to Power Query Academy includes:
For the past several years, Power Query Training has offered the best live online workshops available and we have trained hundreds of people from around the world. Like our workshops, this course is created from a practical point of view, showcasing real-world examples and techniques that you can begin to use right away.
‘M is for Data Monkey’ is the top-selling Power Query book on the market and is considered a leading reference guide. Written by two world-class professional who are renowned Power Query experts, this book is dedicated to teaching how to use Power Query's incredible user interface, and also understanding and working with "M", the language that runs under the hood of the Power Query engine. As part of your registration to Power Query Academy, you will receive a digital copy of the newly released second edition.
Awesome course with great examples and clear explanations. This is one of the best courses I have done. I got the book on a recommendation and I have recommended to many more users. When I realiz...Read More
Awesome course with great examples and clear explanations. This is one of the best courses I have done. I got the book on a recommendation and I have recommended to many more users. When I realized the authors were running a course it was an easy decision to subscribe. Great investments. The delivery platform has a few bugs but the course is awesome. Great job. Keep up the good work.Read Less
I give this course 5 stars. Gentlemen, you really outdid yourselves this time! This course is literally for everyone, from someone who's never heard of Power Query before to advance users s...Read More
I give this course 5 stars. Gentlemen, you really outdid yourselves this time! This course is literally for everyone, from someone who's never heard of Power Query before to advance users seeking a refresher course. There's something here for everyone. There isn't one video on this course that I saw that I didn't say WOW, so that's how this can be done better!! I learned SOOOO much. You have no idea. Now I can do my job quicker and more efficiently. And it’s all thanks to you guys. I cannot thank you enough for putting this course out there, and helping me and the Excel community around the world. A world of thanks!!! CBRead Less
The course provides many useful techniques which I started using right away in my work. After watching some videos, I immediately revised my existing power query files incorporating the tricks le...Read More
The course provides many useful techniques which I started using right away in my work. After watching some videos, I immediately revised my existing power query files incorporating the tricks learned from the course material. I would never have discovered the techniques contained in this course material on my own. Thank you for putting these materials together.Read Less
Found modules to lead me a step at a time to understand Power Query. Modules make it simple to go back and review. Look forward to getting to each new module. I just completed the videos (which...Read More
Found modules to lead me a step at a time to understand Power Query. Modules make it simple to go back and review. Look forward to getting to each new module. I just completed the videos (which means I am half done, now I have to redo the videos and practice each video). I purchased the original "M is for (Data) Money" but never seemed to be able to work my way through the material without getting stuck (or not motivated enough to keep going). I found the videos kept me motivated and help me understand the issues I had in the original book.Read Less
This is a great course to get from beginning to very accomplished. Mr. Puls and Mr. Escobar do a great job presenting the information in small pieces. You will be able to apply their methods to dev...Read More
This is a great course to get from beginning to very accomplished. Mr. Puls and Mr. Escobar do a great job presenting the information in small pieces. You will be able to apply their methods to develop some very advanced solutions. I suggest that if you want to learn the M language (Power Query) then this class and their book are great places to start.Read Less
Power Query is a most necessary tool for all analysts. Although, at first sight, it appears daunting, due to a new syntax (that elusive "M" language), Ken and Miguel do a good job explaining it wit...Read More
Power Query is a most necessary tool for all analysts. Although, at first sight, it appears daunting, due to a new syntax (that elusive "M" language), Ken and Miguel do a good job explaining it with a step-by-step approach. I personally like the "nothing is too complicated" attitude of the tutors and eventually came to appreciate its validity. Once the foundation is laid by this course, practice will make perfect.Read Less
Hi Ken and Miguel, it's a great pleasure to examine your lessons! Clear structured, well explained, best practice. Great course! Kind regards Hartmut
Hi Ken and Miguel, it's a great pleasure to examine your lessons! Clear structured, well explained, best practice. Great course! Kind regards HartmutRead Less
Awesome course--clear explanations and great handouts. I especially like the M is for Data Monkey book. Well worth the money I spent for this course Cheers--Judith
Awesome course--clear explanations and great handouts. I especially like the M is for Data Monkey book. Well worth the money I spent for this course Cheers--JudithRead Less
Before Power Query Academy - I learned very much piecemeal. The course is clear, clean, well presented, well thought out, has a lovely clear logical style... in addition the support they provide i...Read More
Before Power Query Academy - I learned very much piecemeal. The course is clear, clean, well presented, well thought out, has a lovely clear logical style... in addition the support they provide is quick, considered and helpful. I would like to thank both Ken and Miguel for creating this course. I look forward to future content, and their new bookRead Less
Is a Chartered Professional Accountant, blogger, author and trainer from Canada with over 20 years of business experience. Ken has a passion for teaching people how to build business intelligence, specifically focusing on Excel and Power BI. He gets most excited about the topics he knows will save you time and make you more efficient.
He has held the Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories, and has been recognized as a Fellow of his accounting organization and as one of the “Top 20 Under 40” Business and Community Leaders on Vancouver Island.
Panamanian consultant and an Excel specialist become a BI specialist using the latest Microsoft tools for BI: Power BI. He is the co-author of 'M is for Data Monkey' and 'Magic Tricks for Data Wizards', blogger and also Youtuber of tricks for Excel.
He is the Managing Director and Lead Consultant for Powered Solutions and one of the founders of the Power Query Training project which is the # 1 worldwide site for Power Query related resources.
He has been recognized as a Microsoft Most Valuable Professional (MVP), is a Microsoft Certified Professional (MCP - MCSA: BI Reporting), and is one of the international pioneers in Power Pivot, Power Query and Power BI.
No, prior experience with Power Query is not necessary. However, we do recommend having a good working knowledge of Excel.
You will need Excel 2010 or newer, and any version of Power BI Desktop.
Upon registration, you will have unlimited access to the course materials and trainer support for one year.
The Power Query Academy provides support to its students by providing:
Dedicated support forums for questions directly related to the course content. These forums are monitored by our team and we will respond to all questions in these forums within 3 business days.
A General Discussion forum where students can ask questions on applying these techniques to their own data. Please note that support for this forum is provided as or when time allows for our team. We may simply offer suggestions, provide answers, or let the community answer them (as our time allows). This forum makes a great practice ground to try applying your skills to other data sets, and allows you to get help with your own data if you are not in a hurry.
A support ticket system to ask questions related to technical problems (getting the course player to work, etc.).
Consulting services if you cannot wait for the community forum or have data that you cannot share publicly.
Wherever possible, we encourage you to post sample data sets in the General Discussion forum dedicated to applying techniques to your data sets. This area is intended to be the place that the community can help each other by collecting samples to challenge your skills, and also provide a means to get help with applying the course techniques to your data. We are firm believers that practice makes perfect, and it’s by sharing that we can all help each other improve.
All the sample files are downloadable, but the video files are not. The videos can be watched online as many times as you like for one year.
We accept payments through Credit Cards. If you would like to discuss other payment options, please click the support button at the footer of this page
No, registration and access to the course is intended for one person only. Logins and downloads are not to be meant to be shared. However, we do offer group discounts on registrations of 3 or more people. For more information on group discounts click on the support link at the footer of this page to contact us.
Yes, group discounts are available for registrations of 3 or more people. For more information on group discounts contact us by clicking on the support link at the footer of this page.
Yes, once you complete the course you will receive a Certificate of Completion for your records.
The course content will be updated quarterly based on new features and updates released that pertain to Power Query.
Refunds are not available on course registrations; all sales are final. Registration and logins cannot be transferred another user.
We're currently aiming at having a pre-release copy for all members of the academy during the first Quarter of the year 2018.
Yes, we do! Contact us using the Support button in the footer of this page to request more information.
Yes, we have a special rate for registrants of our other workshops and courses. Contact us using the Support button in the footer of this page to request more information.