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."
Mastering {M} in Power Query
Push Beyond Power Query's User Interface & Solve Tricky Data Cleaning Problems using the M-Language.
Simranjeet SinghSimranjeet 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."
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."
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."
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."
Why your queries keep breaking?
and it's frustrating!!
When I first started working with Power Query, it felt like magic – like I had found a Genie. With just a few clicks, I could connect data from multiple sources, clean it up, and get it ready for analysis.
The best part? Power Query's work is reusable. Change the source, hit refresh, and everything updates. At least… that's what I thought.
But once I started dealing with bigger, messier problems, my queries began to fail. WHY?
Because something was hard-coded, or the query just wasn't dynamic enough to handle changes in the data source. Suddenly, my Genie wasn't good enough anymore, until I powered it with "M" a.k.a. Power Query's functional language.
Since then, using M, I've been able to:
- Make my queries super dynamic
- Resolve complex errors
- And (most importantly) build clean, high-performing data models
I've come a long way, and along the way I've built some very sophisticated queries, all thanks to Power Query's M language.
See it in action
What's Inside The Course?
Course Outline
19 hrs 39 mins • Video Content
3 Modules • 153 In-depth Lessons
1
Core Concepts
In this module you'll learn
- The fundamentals of how lists, records and tables work and how to use them in the correct way to shape and clean data.
- Once the basics are clear, we will move into advanced topics such as iterations, the each keyword and how to write your own custom functions.
- You will learn a step-by-step approach that takes you from understanding the basics of M syntax to solving complex data problems.
After finishing module 1
After completing this module, you'll be able to
- Get comfortable understanding M syntax.
- Create custom Power Query Functions.
- Have a solid grasp on advanced topics like manipulation, iterations, Nested Tables, working with errors etc.
- Create dynamic and robust queries.
2
Case Studies
In this module you'll learn
- How to apply Module 1 concepts to real-world complex data problems.
- Through case studies, you will learn to solve messy data problems such as renaming columns dynamically, unpivoting datasets, and combining data from multiple files and sheets without manual work.
- Build reusable solutions for common problems
After finishing module 2
After completing this module, you'll be able to
- Take a messy, overwhelming dataset and know exactly how to untangle it.
- Break a big, confusing problem into clear, bite-sized steps you can actually solve
- Build repeatable solutions so you never waste time on the same cleanup twice
3
Power Query Function Library
In this module you'll learn
- The most important functions in Power Query and what they do.
- Practical uses of each function with real examples
- Common mistakes and “gotchas” to watch out for
- How to move beyond syntax and apply functions to your own data the right way
Before this course, my queries kept breaking with every little change. M felt scary at first, but Chandeep made it simple. Now I can fix errors, build dynamic queries and my refreshes just work - no stress, no wasted hours. Honestly, this course took me way beyond what the Power Query UI could do.
Cristian Angyal
Financial Analyst
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.
@ashu10111988Learning from you is soooooooo easy. Absolutely the greatest Power BI teacher on the Internet. 👍👍
@goodguywinsTo explain such a complex topic in such simle and understandable way, bravo! Great job, thanks Chandeep for such quality content!
@mogarrett3045Bro you're always doing great things.....keep it up!
I always stayed away from M because it felt like a mystery. But with Chandeep’s clear explanations, I finally got comfortable. Now I understand M better, I’m no longer scared of it, and I can actually use it with confidence. That was my goal, and this course helped me reach it. Highly recommended.
Ytzen Terpstra
Financial Analyst
Hi, I'm Chandeep!
your instructor
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
your common queries
Become an Insider!Start Your Learning Journey!
Single Course
M Language $249
Power Query Function Library$99
$348$249 + taxes
Save $99 (28%)
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%)
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"