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 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. We’ll show you 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

Bundle Offer:

For the ultimate Power Query training package, our Power Query Bundle gives you access to everything in this course, plus full access to both the Power Query Fundamentals and Power Query Essentials courses as well. The Power Query Bundle is the best value for those who truly want to master Power Query! Check out our subscription options and pricing on the main Power Query Academy page.

What you get with the course

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

New videos added by Matt Allington:

  • Advanced Data Reshaping Module
    • A Hacker’s Approach to Numbering Grouped Rows
  • Managing Queries Module
    • Adding Comments to Tables
    • Bonus Tips for Working with Queries
  • Advanced M Techniques Module
    • Managing Changes to Columns
    • Creating Audit Queries and Alerts

The Instructors

This course is developed by Ken Puls, Miguel Escobar, and Matt Allington three of the world’s leading business intelligence experts. Read more about each of our trainers by clicking on their profile links below.

Course Content

Expand All

About Instructor

Skillwave

Your #1 resource for training on Power BI, Power Query, Power Pivot, and Excel.

5 Courses

+645 enrolled
Not Enrolled

Course Includes

  • 11 Modules
  • 45 Lessons
  • 8 Quizzes
  • Course Certificate