Power Query Academy

Leveraging Power Query to Get & Transform Your Task Flow

Buy now!

$298.00 Special Offer available for a limited time only! Save $100 off the regular price ($398). Buy $298.00

What is Power Query?

The best tool for business users since Pivot Tables

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.

Course Overview

What is Power Query Academy?

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.

15 Modules

12+ Hours

55+ Videos

Free eBook

Top Support

Updated Content

Example Files

1 Year access


Your registration to Power Query Academy includes:

  • One year of unlimited access to the course materials
  • 15 modules developed by world-class experts
  • 12+ hours of learning broken into more than 55 bite-sized videos
  • Downloadable example files to work through
  • Free digital copy of our book, 'M is for Data Monkey' (2nd edition) - Release date TBD
  • Top support on the course materials for one year
  • Content that is updated every quarter as new features are released
  • Certificate of Completion upon completion of the course

Why this course and not others?

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.

Endorsements

Ken and Miguel's Power Query online training has been invaluable.
Kevin Zandee GT Services
[This training] opened my mind to possibilities I hadn’t even imagined.
Rebekah Heath LexisNexis Risk Solutions
Love your energy and passion to help the students... Thank you!
Krishna Pakala Big 4 Accounting Firm

Curriculum

Introduction

22:00

Importing Basic Data

43:48

Query Settings

38:01

Simple Transformation Techniques

61:13

Combining Data - coming Dec 2017

Miscellaneous Data Sources - coming Dec 2017

Data from Relational Sources - coming Dec 2017

Transformation Patterns - coming Dec 2017

Managing Queries - coming Dec 2017

Power Query Formulas and Functions - coming Jan 2018

M Deep Dive - coming Jan 2018

Parameters and Custom Functions - coming Jan 2018

Advanced M Coding - coming Jan 2018

Calendar Tables - coming Jan 2018

Suggestions from Ken and Miguel - coming Jan 2018

Content Release Schedule

The following table defines the release schedule for all of the content that will become available in the Power Query Academy. Future updates will come every Quarter of the Calendar Year.

Modules 0 - 3

Modules 4 - 8

Modules 9 - 14

Available

To be released on December 27, 2017

To be released on January 27, 2018

Meet your instructors

Ken Puls

Miguel Escobar

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.

Twitter  - Linkedin - Blog

Miguel Escobar

Miguel Escobar

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.

Twitter  - Linkedin - Blog

Special Offer

Don’t miss out on this Special Offer. Sign up now and save USD $100!

Take the Course
00 00 00 00
Take the course

Bonus Material

Free eBook

'M is for Data Monkey' 2nd Edition

$39 value
You will be one of the first to receive a digital copy of the 2nd edition of our best-selling book, 'M is for Data Monkey'.

Free Support

1 Year of trainer support on course materials

$1,200 value
Have questions regarding the topics discussed in the course? Ask the instructors your questions directly about the content!

Sample Files

Download all of the example files

Amazing Value!
Want to follow along and try out the techniques demonstrated for yourself? All of the sample files are available to you!

Frequently Asked Questions

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.

Join the academy now!

Special Offer available for a limited time only! Save $100 off the regular price ($398).

Register Today