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.
Ken and Miguel's Power Query online training has been invaluable.
[This training] opened my mind to possibilities I hadn’t even imagined.
Love your energy and passion to help the students... Thank you!
Modules 0 - 3
Modules 4 - 8
Modules 9 - 14
To be released on January 27, 2018
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.
Miguel has been recognized as Microsoft Most Valuable Professional (MVP) and has maintained the Microsoft Certified Professional (MCP) for Excel since 2014 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.
You can ask as many questions as you want for one year through our online learning platform. Our trainers provide support for questions regarding the topics covered and example files used in the course. For external queries to the course materials and examples, (i.e. for personalized queries using examples with different data than those shown in the course) we provide limited support which is at the discretion of Power Query Training.
Our commitment is to answer the questions received through the online learning platform within 72 hours, but for more complex queries, or those requiring a greater commitment of time for analysis and data collection, we will offer a series of suggestions to reach the expected solution. We will also provide the option to escalate the question to our consulting team to receive a formal quote for any requested customization.
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 PayPal and 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.