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.
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
Greg sets expectations for what “intermediate” Power Query really means, building transformations that are reusable, resilient, and easier to maintain. You’ll preview the skills you’ll develop, from smarter cleanup patterns to reshaping data and working directly with M, so you can apply these techniques to real-world datasets with confidence.
Module 02 - Introduction to the Power Query Editor
Get a focused refresher on the Power Query Editor with an eye toward intermediate workflows. Greg highlights the parts of the interface that matter most as queries get more complex, Applied Steps, query settings, and key transformation menus, so you can navigate faster and understand what Power Query is doing behind the scenes.
Module 03 - Connecting to Data & First Look of the Power Query Editor6 min.
Bring data in and perform an initial review the “right way.” Greg shows how to connect to a source, assess column quality early, and spot common issues before you build dozens of steps. This module sets up the practical environment you’ll use for the rest of the course.
Module 04 - Replace Values & Errors11 min.
Learn how to standardize messy values and handle errors without breaking your pipeline. Greg covers replace patterns, how to treat errors intentionally, and how to prevent small data issues from turning into failed refreshes. You’ll leave with a cleaner, more reliable approach to common cleanup tasks.
Module 05 - Fill Down & Fill Up4 min.
Fill down and fill up are essential for fixing semi-structured data, especially exports with grouped headers or blanks. Greg demonstrates when to use each method, how to avoid accidentally spreading bad values, and how to validate the results so your data stays accurate.
Module 06 - Reference vs. Duplicate10 min.
Understand one of the most important design choices in Power Query, when to reference a query and when to duplicate it. Greg explains how each impacts maintainability, performance, and reusability, and shows patterns for building efficient “base” queries you can build from safely.
Module 07 - Creating DIM Tables with Duplicate6 min.
Put duplication to work by creating clean dimension tables from a shared source. Greg shows how to isolate the right fields, remove duplicates, and shape dimensions that are ready for relationships in the model. This module reinforces how smart query structure supports better data modeling downstream.
Module 08 - Fuzzy Match12 min.
Learn how fuzzy matching helps when your keys don’t match perfectly, like misspellings, inconsistent naming, or formatting differences. Greg demonstrates how to configure fuzzy merge settings, interpret match results, and reduce bad joins. You’ll also learn when fuzzy match is helpful and when it creates risk.
Module 09 - Pivot & Unpivot14 min.
Reshape data like a pro using pivot and unpivot. Greg explains when data is “too wide” or “too tall,” and how these transformations help you build cleaner models and visuals. You’ll practice converting columns into rows, or rows into columns, while keeping the dataset consistent and analysis-ready.
Module 10 - Conditional Columns11 min.
Start building logic directly into your transformations. Greg shows how to create conditional columns based on rules, allowing you to categorize, flag, or standardize records without manual editing. You’ll learn patterns that help you add business meaning while keeping steps readable.
Module 11 - Conditional Columns (Part 2)12 min.
Go deeper into conditional logic with more complex scenarios. Greg covers combining conditions, handling blanks, and building multi-branch rules that reflect real business logic. This module helps you make transformations smarter and less brittle as requirements evolve.
Module 12 - MQuery5 min.
Now you’ll start looking under the hood at M, the language Power Query uses to record transformations. Greg introduces what M is, why learning it improves control and repeatability, and how understanding M helps you troubleshoot and optimize steps more effectively.
Module 13 - Formula Bar & Advanced Editor3 min.
Learn where and how to edit M safely. Greg walks through the formula bar and the Advanced Editor, explaining how to read steps, make small edits confidently, and avoid common mistakes that break a query. This module builds comfort with direct editing so you’re not limited to the UI.
Module 14 - Start Using MQuery8 min.
Begin writing and adjusting M in practical, beginner-friendly ways. Greg demonstrates simple edits that improve clarity, reduce steps, or make transformations more reusable. You’ll learn how small M changes can make your queries cleaner and easier to maintain.
Module 15 - Go Further With MQuery5 min.
Extend your M skills with more advanced patterns that support scalability. Greg shows how to make transformations more dynamic and robust, so your queries hold up as data sources change or grow. This module focuses on building confidence to use M as a productivity tool, not a barrier.
Module 16 - Conclusion1 min.
Wrap up with a recap of the intermediate skills you’ve gained, reliable cleanup patterns, smarter query structure, reshaping techniques, and practical M editing. Greg leaves you with next steps and best practices so you can apply these techniques to your own Power BI projects immediately.
Gregory Trzeciak has his master’s degree in Education from the University of Florida. He has 9 years of teaching experience in high school, college level, and summer programs where he was recognized as a top educator and leader in interactive education. As a trainer at Pragmatic Works, his primary goal is to help individuals gain confidence in using Power BI and the Power Platform. While not in the office, he enjoys fantasy football, walking his dog, and running half-marathons!
