Power Query Course

Learn to Automate Your Mundane Data Cleaning Tasks using Power Query

Join the Course

Stuck in Endless Data Cleanup?

automate it

Nearly 80% of the time is consumed in performing repetitive data cleaning tasks!

The worst part.. you've gotta do this each day, each week, each month in-fact each time you need to create the report.

Data visualization showing 80% vs 20% time allocation

Think how much time they save if you automate the repetitive data cleaning process. Power Query is how you automate it.

Chat interface showing conversation about Power Query

Power Query can help you save time

In the last few years I have taught thousands of people on how to use power query to solve data cleaning and automation problems.

Now it may sound that I am exaggerating but the major benefit that all of my students get is that how much time they save by automating repetitive tasks.

Not just a small improvement. That long cleanup, which used to take 2.5 hours a week, now? Just 5 minutes with a refresh. Amazing, right?

Manual: 2.5 h / week

Refresh: 5 min / week

Here is how Power Query works (automation example)

What's Inside The Course?

Course Outline

6 hrs 25 mins • Video Content

2 Modules • 41 In-depth Lessons

Power Query Fundamentals

In this module you'll learn

How the Power Query interface works and what each part is used for
Different ways to bring data into Power Query - from Excel files, sheets, and even the web
How to clean and reshape data with unpivoting, pivoting, grouping, and date handling
How joins, lookups, and parameters work to connect and automate data

Power Query Fundamentals - Module Preview

Topic

Duration / Videos

Getting Started with Power Query

7:42-Getting Started & Becoming Familiar

15:18-Getting Started & Becoming Familiar - Part 2

Combining Data from Multiple Sources

13:31-Phase 1 - How to Combine data from Multiple Excel files when the data structure is the same

15:12-Phase 2 - How to combine data from multiple excel files when the data structure is uneven - Part 1

8:54-Phase 2 - How to combine data from multiple excel files when the data structure is uneven - Part 2

15:14-Loading and Combining Data from Multiple Excel Sheets - Part 1

5:20-Loading and Combining Data from Multiple Excel Sheets - Part 2

Cleaning and Reshaping Data

5:57-Loading Data from Web

16:13-Working with Dates in Power Query

3:27-Exercise - Clean this Data

12:59-Answer

9:21-Intervention - Errors & things to be cautious about in PQ !

2:31-What is Unpivoting ?

13:54-Answer

7:22-Grouping

6:16-The reverse of Unpivoting - Pivoting

Joins, Lookups

5:24-Joins in Power Query - Part 1

6:10-Joins in Power Query - Part 2

12:15-Application of Join - Vlookup in PQ

11:09-Application of Join - Dynamic Filter in PQ

7:31-Parameters and Templates in Power BI

3:48-Cartesian Join

3:40-Scheduled Refreshes

Introduction to M Language

12:52-M Code and Concepts - Part 1

16:14-M Code and Concepts - Part 2

After finishing module 1

After completing this module, you'll be able to

Combine data from multiple files and sheets, even when structures don’t match perfectly
Turn messy, inconsistent tables into clean, structured datasets ready for analysis
Use joins and lookups to build smarter queries and connect related data

Case Studies

In this module you'll learn

How to handle advanced transformations like complex date logic and multi-header unpivoting
Techniques for managing large datasets with over a million rows
How to combine and restructure data when files and layouts don’t line up neatly
Practical tricks such as referencing previous rows, filtering headers, unstacking rows, and repeating rows

Topic

Duration / Videos

Row and Column Handling Cases

7:25-Refer to Previous Row

11:21-Filtering Headers

7:10-Transpose Rows into Columns

4:44-Combine Duplicate Values in a Single Row

5:26-Repeat Row N Times

Unstacking and Dynamic Path Cases

11:52-Creating Dynamic Data Source Path - Part 1

3:43-Creating Dynamic Data Source Path - Part 2

5:45-Unstack Rows in Columns

16:27-Unstacking Part - 2 When the number of columns for each record are different

Tricky Data Transformation Cases

10:46-Complex Date Transformations

11:39-Working with > Million Rows

3:10-Complex Unpivoting - 2 Headers

13:05-Even more Complex Unpivoting and Combining Data - Part 1

12:21-Even more Complex Unpivoting and Combining Data - Part 2

13:24-Combining Data from Multiple Excel Files - Advanced Part 1

9:00-Combining Data from Multiple Excel Files - Advanced Part 2

After finishing module 2

After completing this module, you'll be able to

Tackle messy, irregular datasets with confidence using advanced Power Query skills
Reshape even the most complex tables, from multi-level headers to unstacked rows
Work efficiently with very large datasets without breaking your queries
Build flexible, dynamic solutions that adapt to new files and changing structures
Solve real-world scenarios that go beyond the basics and mirror actual business challenges

Join the Course

Take a Look Inside

a little sneak peek

I teach the way I'd like to learn

practical & straight to the point

No Jargons, just simple English

I hate jargon, and I don’t use it in my courses. I go to great lengths to make tough concepts easy to understand.

Developing a Problem-Solving Mindset

Rather than memorizing functions and steps, I focus on teaching you how to structure and solve problems. You’ll learn to develop a problem-solving mindset so you can tackle challenges beyond the examples in this course.

Case Based Learning

All the concepts covered in this course are taught using a case study method. This approach helps you to visualize the applications of various concepts.

@ashu10111988

Learning from you is soooooooo easy. Absolutely the greatest Power BI teacher on the Internet. 👍👍

@goodguywins

To explain such a complex topic in such simle and understandable way, bravo! Great job, thanks Chandeep for such quality content!

@mogarrett3045

Bro you're always doing great things.....keep it up!

Join the Course

Hi, I'm Chandeep!

your instructor

My superpower is taking complicated stuff and explaining it in a way that actually makes sense.

Most people know me through my YouTube channel Goodly, where over 120K subscribers follow along as I break down tricky Excel and Power BI concepts into simple, practical lessons. My channel has grown into a community of learners who appreciate clear explanations and content that actually solves real problems.

Alongside YouTube, I've been teaching through online courses for more than 10 years, with thousands of students benefiting from a style that mixes clarity with hands-on, real-world examples. I also conduct live and in-person corporate training programs for companies around the world.

Over the years, I’ve had the chance to speak at international events like the Global Excel Summit in London and Bulgaria Excel Days in Sofia. I even wrote a book on M language, which has been picked up by thousands of readers globally, something I’m still amazed by.

With 20+ years in this field, I've seen more messy data than I care to admit. These days, when I'm not teaching, I run Goodly Insights, a data analytics consulting firm providing Power BI and Excel-based solutions to companies worldwide.

Daniel Cordido

"After watching thousands and thousands of YouTube videos, I finally came across your channel,. Buddy, you're like the Leila of Power Query! Very plain English and good examples/exercises/challenges."

Daniel Cordido

"After watching thousands and thousands of YouTube videos, I finally came across your channel,. Buddy, you're like the Leila of Power Query! Very plain English and good examples/exercises/challenges."

Abhishek Ravindran

"This top-notch course definitely gives you better ROI than any other course out there. Without falling for analysis paralysis, do enroll on this course and thank me later."

Daniel Cordido

"After watching thousands and thousands of YouTube videos, I finally came across your channel,. Buddy, you're like the Leila of Power Query! Very plain English and good examples/exercises/challenges."

Abhishek Ravindran

"This top-notch course definitely gives you better ROI than any other course out there. Without falling for analysis paralysis, do enroll on this course and thank me later."

Simranjeet Singh

"Hi, I am Simraneet from UK. I'm thoroughly impressed with your expertise in M language and DAX. I've decided to enroll in all of your courses."

Frequently Asked Questions

your common queries

Become an Insider!Start Your Learning Journey!

Single Course

Power Query Course$149

$199$149 + taxes

Save $49 (25%)

Lifetime access

Best Value

Goodly Insider

Power Query$149

DAX & Data Modeling$249

M Language$249

Power BI Beginner's $39

DAX Function Library$99

Power Query Function Library$99

$884$499 + taxes

Save $385 (44%)

Not available right now

Lifetime access

Wall of Love

stories of growth

You’ll be learning alongside people from all over the world

Join the Course

Help Chandeep Sleep Peacefully at Night

promise!

If you don't like my course or feel you didn't get value from it, just let me know within 30 days of purchase what you didn't like and I'll refund your full payment. No awkward chats, no hoops to jump through, no hard feelings.

Okay, technically, that means I'll ask you one question - "What could I have done better?" But that's only to make the course stronger, not to make your refund difficult. And yes... your feedback helps me sleep better too.

Chilaw

"Love your content and your courses - the best money I've spent in a long while and highly recommended to anyone who really wants to learn or just level up Excel, Power Query, and DAX skills."

Chilaw

"Love your content and your courses - the best money I've spent in a long while and highly recommended to anyone who really wants to learn or just level up Excel, Power Query, and DAX skills."

Michael F.

"I have some notions in M language, but it is hard to find a structured course to move to the next level, that's why I bought yours, which seems to address a lot of fundamental concepts with a hands-on twist."

Chilaw

"Love your content and your courses - the best money I've spent in a long while and highly recommended to anyone who really wants to learn or just level up Excel, Power Query, and DAX skills."

Michael F.

"I have some notions in M language, but it is hard to find a structured course to move to the next level, that's why I bought yours, which seems to address a lot of fundamental concepts with a hands-on twist."

Ashlee Huff

"I thought I was a PQ expert, but Chandeep has humbled me after watching just a few YouTube videos. So I've come to learn from the master. Thank you so much for the courses"

Power Query Course

Stuck in Endless Data Cleanup?

Power Query can help you save time

Here is how Power Query works (automation example)

What's Inside The Course?

Power Query Fundamentals

In this module you'll learn

After finishing module 1

After completing this module, you'll be able to

Case Studies

In this module you'll learn

After finishing module 2

After completing this module, you'll be able to

Take a Look Inside

I teach the way I'd like to learn

No Jargons, just simple English

Developing a Problem-Solving Mindset

Case Based Learning

Hi, I'm Chandeep!

Frequently Asked Questions

How long does Power Query take to learn?

Can I use Power Query in Excel too?

Do you also teach M language in this course?

Do I get a certificate after completing the course?

Become an Insider!Start Your Learning Journey!

Single Course

Goodly Insider

Wall of Love

Help Chandeep Sleep Peacefully at Night