<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / Power BI / Intermediate Power Query for Power BI

Intermediate Power Query for Power BI

Level up Power Query in Power BI with Greg Trzeciak. Learn intermediate transformation patterns, combining and reshaping data, handling errors and missing values, and organizing queries.

Free Community Plan View Pricing Plans
  • Course Info
  • Instructor
  • What to know beforehand
  • System Requirements

Course Description

In Intermediate Power Query for Power BI, Greg Trzeciak helps you move past basic cleanup and start building more robust, scalable data preparation workflows. You’ll learn how to handle messier, real-world datasets, apply more advanced transformation patterns, and structure queries so they’re reusable and easier to maintain. This course focuses on sharpening your Power Query instincts, not just which buttons to click. You’ll also explore techniques that improve reliability and performance, including smarter combining strategies, better handling of errors and missing values, and organizing queries for larger projects. Greg walks through patterns that help you automate repetitive prep work, reduce manual steps, and keep your transformations understandable for both you and your team. By the end, you’ll be able to build cleaner, more durable Power Query solutions that scale with your reporting needs.

Course Outline ( Free Preview)

Module 01 - Introduction

Module 02 - Introduction to the Power Query Editor

Module 03 - Connecting to Data & First Look of the Power Query Editor 6 min.

Module 04 - Replace Values & Errors 11 min.

Module 05 - Fill Down & Fill Up 4 min.

Module 06 - Reference vs. Duplicate 10 min.

Module 07 - Creating DIM Tables with Duplicate 6 min.

Module 08 - Fuzzy Match 12 min.

Module 09 - Pivot & Unpivot 14 min.

Module 10 - Conditional Columns 11 min.

Module 11 - Conditional Columns (Part 2) 12 min.

Module 12 - MQuery 5 min.

Module 13 - Formula Bar & Advanced Editor 3 min.

Module 14 - Start Using MQuery 8 min.

Module 15 - Go Further With MQuery 5 min.

Module 16 - Conclusion 1 min.

This course includes:

  • 1+ hours of training
  • 16 Modules
  • Intermediate level content
  • Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing