Power Query Academy

Leveraging Power Query to Get & Transform Your Task Flow

Buy now!

$398.00 Enroll in the BEST Power Query course ever created! Buy $398.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

13+ Hours

73 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
  • 13+ hours of learning broken into 73 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.

Reviews

Pure Excellence!!!

From celeste benitez

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 ...

Read More

Complete and well explained

From Doru Imbroane

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

Great self service training for Power Query

From Micheal Reynolds

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

Great Course!

From Hartmut M. Hilbich

Hi Ken and Miguel, it's a great pleasure to examine your lessons! Clear structured, well explained, best practice. Great course! Kind regards Hartmut

My early opinion of the course

From Judith Calvo

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

Highly Satisfied

From John A Robinson

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.

Power Query Academy

From Mathew Westwood

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

Curriculum

Introduction

26:45

Importing Basic Data

43:48

Query Settings

38:01

Simple Transformation Techniques

61:08

Combining Data

99:15

Miscellaneous Data Sources

73:07

Data from Relational Sources

58:08

Reshaping Tabular Data

40:59

Managing Queries

34:47

Power Query Formulas and Functions

64:40

M Deep Dive

94:48

Parameters and Custom Functions

50:49

Advanced M Techniques

39:56

Date & Time Techniques

40:32

Query Optimization

32:50

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.

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.

Twitter  Linkedin Blog

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.

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.

Join the academy now!

Transform the way you work with data forever with the BEST Power Query course ever created!

Register Today
SUPPORT