Power Query Advanced

Skillwave · October 1, 2019

What you’ll learn

  • Advanced Transformation patterns for a diverse range of data sets
  • Complex Conditional Logic methods and solutions
  • Building calendar tables for dimensional models using Power Query
  • In-depth understanding of Power Query and the M language
  • Using and creating Parameters and Functions for your custom scenarios with the M language to build portable file solutions
  • Tips to optimize existing queries and future proof new queries

Course Overview

Want to fully master your data and the art of Data Preparation for Excel and Power BI? Then this is the course that you’re looking for.

We’re known for our practical approach in our courses, and this course is no exception. You can expect real-world scenarios and solutions that both of our world-class instructors have created over the years.  This is a course where we focus more and more into the language behind Power Query: the M language.

This course begins with user-interface driven patterns for complex data transformations.  From pivoting a single column of data into a full table, to un-pivoting sub-categorized data and more, you’ll learn some of the coolest tricks of the trade.  You’ll look at automating Power Query refresh in Excel, as well as how to keep your file solution organized.

And then it’s time to take a deep dive into M; the language behind our data Magic. Not only will you learn how to code using the M language, but you’ll also learn the best way to tackle your scenarios using the M language. A completely new way of thinking on how to approach your Data Preparation scenarios.

Of course, no advanced technical course would be complete unless you learned how to apply the theory in real world scenarios.  For that reason, you’ll see lessons on:

  • Driving dynamic file paths for Excel solutions
  • Building fully dynamic calendar tables for Excel and Power BI
  • Future proofing queries against the challenge of dynamic headers

And finally, we show you how we – as experts – set up our Power Query environment to both optimize the development and run time for our solutions.

This course is packed with steps, formulas, and tricks from world-class experts that you can use to save hours of time.  It’s the ultimate training to become a Power Query Ninja.

Who this course is for:
  • People who already have the skills provided in our “Power Query Essentials” course (or equivalent experience)
  • People who are comfortable with Power Query and want to push their skills to the next level
  • People who want total control of their data in Excel or Power BI

What you get with the course

6.5+ Hours of Video Content

Downloadable Files and Handouts

8 Quizzes

'M is for Data Monkey' Digital Book

3 Workshop Labs

Premium Content and Instructors

Support and Discussions Group

Course Certificate of Completion

Power Query Recipes

What our students say about the course

Course Update Log

First release of the course as Power Query Advanced

New videos added:

  • Numbering Grouped Rows (in Advanced Data Reshaping Module)
  • Targeting Errors using the TRY function (in Formulas and Conditional Logic Module)

The Instructors

Ken Puls, FCPA, FCMA

Is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. He has held the Microsoft MVP distinction since 2006, and has been recognized as a Fellow of his accounting organization.

Miguel Escobar

Miguel Escobar

Is an Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks. He has been recognized as a Microsoft MVP, MCP – MCSA: BI Reporting and a Microsoft Certified Trainer (MCT).

Course Content

Expand All

About Instructor


5 Courses

+628 enrolled
Not Enrolled

Course Includes

  • 10 Modules
  • 44 Lessons
  • 8 Quizzes
  • Course Certificate