Products

Mastering M in Power Query

Push Beyond Power Query’s User Interface &
Solve Tricky Data Cleaning Problems.

You’ll learn to build robust Excel / Power BI models by
creating dynamic queries using the M language.

Enroll Now

Why Should You Learn M?

When I started working with Power Query, I felt as if I had found a “Genie”.

It was way too simple to connect data from multiple sources, clean it up and use that data for further analysis.

The best part – Power Query’s work is reusable. The next time anything changes, just hit refresh.

But as I started to solve more dense / trickier problems my refreshes failed. WHY?

Because something was hard-coded or the query wasn’t dynamic enough to account for the data source change.

My Genie wasn’t good enough anymore, until I powered my Genie with “M” a.k.a. Power Query’s functional language.

Since then using M, I have been able to…

Make my queries super dynamic.
Resolved and reported complex errors.
And (most importantly) build very clean and performant data models.

I’ve come a long way and in the process have built some very sophisticated queries, all thanks to Power Query’s M Language.

M v/s Power Query User Interface

Here is a quick demo of what the M language is capable of doing as compared to Power Query’s User Interface.

But Learning M is Hard!

When I first peeked into Power Query’s Advanced Editor and saw M, I literally said it out loud. “What are these worms floating around?”. It was so intimidating

Here is what makes M hard…

It looks weird and scary with all the possible brackets and special characters; we aren’t designed to look at code like this.
And to an Excel user, it might be very difficult to comprehend concepts like lists, records, tables, data types, and manipulating these objects.

I am here to make learning M easier than struggling on your own.

How my Teaching Method is Different!

➜ No Jargons, just simple English.

I hate jargons and I don’t use them in my course.
In this course, I’ll go the greatest extent to demystify Power Query jargons.

➜ Developing a Problem-Solving Mindset.

Rather than mugging Power Query functions one after the other, I focus on teaching you how to structure and solve problems.
I do teach functions but more importantly, I teach you to develop a problem solving mindset so that you can solve problems beyond the cases discussed in this course.

➜ Case Based Learning.

For almost all the concepts covered in this course, I teach them using a practical problem / case study.
This approach helps to visualize the application of the concept.

sujit3375

Jab promo trailer itna acha hai toh movie kitni achi hogi… All the best Chandeep for upcoming M code. Lots Of Love to goodly

Wiel Souren

Hello everyone, my name is Wiel Souren and I’m living in the Netherlands. At this moment I’m using PQ together with Excel. It is giving me enormous added value in grabbing data and turning these data into information ! I heard Of Chandeep when I searching into YouTube for PQ education films. I really like his manner Of explanation. In order to learn more [and also learn DAX and Power BI] I bought the package DAX and PQ. Reg, Wiel Souren.

emilmubarakshin49

Chandeep you don’t stop amazing us with you briliant ideas. Can I sign up for this course please?

mirrrve1115164

Waiting your real PQ – M course!!

raimundojs9547

You’re the best! Waiting for your M Language Course.

bradj229

I’ve taken a lot of training and read multiple DAX books, bit the way you approach and analyze problems makes me want to purchase your course as well. Not because I haven’t seen the material already, but because I can learn from your unique approach that I haven’t seen others use before. (thought you should know). Thanks!

readistreet9383

Waiting for the M course

Jayo5678

Goodly, you are nothing but a good teacher of Power Query. This video is nothing but full of helpful instructions. I am nothing but a beginner in Power Bi. With all due respect and maybe you have already notice that you like saying in your video the filler word “nothing but”.

McKaySavage

Helpful tip! I really appreciate your focus on sharing M code in little snippets, patterns and challenges. There are a lot of creators producing for JavaScript, Python and Excel, and quite a few for Power BI and Power Query’s point-and-click tools, but you’re in a rare space focusing on coding with it’s M language and that’s great. Thanks man!

Course Outline (Weekly Schedule)

Part 1 – Concepts

These are important fundamentals of how the M language works, explained by solving practical real life problems.

Lessons

TOPIC	VIDEOS	COMPLEXITY
Warm Up \| Week 1	4	●●●●○
Working with Lists \| Week 1	13	●●●●○
Working with Records \| Week 2	8	●●●●○
Working with Tables \| Week 3	3	●●●●○
Navigation in Power Query \| Week 3	1	●●●●○
Manipulating Objects \| Week 4	5	●●●●○
if then else – Simple to Complex \| Week 4	1	●●●●●
Iterations \| Week 5	4	●●●●●
Custom Functions \| Week 6	5	●●●●●
Nested Tables \| Week 7	5	●●●●○
Working with Errors \| Week 8	3	●●●●○
Miscellaneous Tips and Tricks \| Week 9	5	●●●●○
Puzzles \| Week 10	4	●●●●○

Part 2 – Patterns, Recipes and Case Studies (9 Practice Cases)

These are long form case studies that test your understanding of the concepts to solve dense and more difficult problems.

Lessons

TOPIC	VIDEOS	COMPLEXITY
User Controlled Column Renaming \| Week 1	1	●●●●○
Combine Data from Multiple Excel Files \| Week 2	1	●●●●○
Working with Multiple Merged Headers \| Week 3	1	●●●●○
Unpivoting Multiple Column Groups \| Week 4	2	●●●●○
Advanced Error Reporting Technique \| Week 5	1	●●●●○
Remove Top Junk Rows, Unpivot + Combine \| Week 6	1	●●●●○
Stacking and Unstacking Patterns \| Week 7	1	●●●●○
Cleaning up Profit & Loss Statements \| Week 8	1	●●●●●
Custom Patterns for Delimited Data \| Week 9	1	●●●●●

Part 3 – Power Query Functions – 50 Videos

Short videos explaining the most important Power Query functions. | Intermittent ongoing release schedule.

Enroll Now

Hi, My name is Chandeep, I’ll be your Instructor.

I am assuming that you already know me through my Blog or YouTube Channel, but if you are new around here, here are a few things about me.

I stay in Gurgaon India, and used to work as a Financial Analyst for an Investment Bank in Mumbai (India). Back in December 2013 I quit my full time job to start Goodly.

Being an Analyst, I became really good with Excel and I now teach Excel and PowerBI around the world through Online Courses, Blog, YouTube and LIVE Corporate Training Programs.

gennarocimmino

Hi Chandeep (not Goodly)…. 🙂
Thank You for this important information which, indeed, is basic for newbies like me. And especially Kudos! for your ability to “tell” and simplify complicated concepts. See you soon.

Austin

I absolutely love Chandeeps’ channel. But I am still puzzled with one question to which I can’t find an answer no matter how many times I query it: how many caps does Chandeep wear? thank you so much. Your channel is a gold mine.

sebfromgermany3819

Who needs textbooks if you have Chandeep’s tutorials! Cheers mate for this one – it’s excellent

joanstoner6252

Thank you so much for this video. It was more helpful then most of the others I watched!! I understand much better than
before.

cherianiype

This video Goodly is truly awesome man! You’ve very clearly explained the foundations of PQs advanced editor – you’ve helped your viewers digest the elements of the language. Bahut Shukriya, Shukran Jazeelan, Thank you very much! Keep doing this man! Best wishes! Big fan! well done!

reanalytics1863

Your contribution is visible, many are getting salary raises because of the skills you share here. Keep up the great work

Any Questions?

How long is the course?

The course is quite long and will have 80+ videos with an average length of about 12-15 mins. You can see these details in the course outline.

Why are the vidoes shared weekly?

One or modules of the course are released each week to help you keep up with the pace and practice along. Eventually by week 10 you’ll have the access to the entire course for lifetime.

How will I get access to the course?

Once you complete the payment you’ll be emailed the access to the course. The course is self-paced so can watch the videos and practice the exercises at your convenience.

Will I really master M language after this course?

Short Answer – No!

Watching videos is not enough, you have to commit to practice the lessons taught. Redoing it yourself, asking questions. This course will give you a very clear understanding of how M works and how to solve simple to complex problems. Building mastery over it involves practice, which is in your hands!

How can I ask questions?

You can ask questions using the commenting section provided under each video. Additionally, you have the ability to paste your code or insert pictures to explain your problem more vividly.

Will I get lifetime access to the course?

Yes, your access will be active for lifetime.

100% Money-Back Promise!

If you “commit and practice the lessons“, you will see a ton of improvement in learning and being able to solve problems using M.

I expect you to complete all the concept lessons (in the course outline). If you’ve done that and for whatever reason aren’t satisfied with the experience, please drop me an email (within 30 days of your purchase) and I’ll happily refund your full money.

No questions, no grudges!

The money-back guarantee applies only if you complete the concept lessons and request a refund within 30 days of purchase.

1 Course

$229 | INR 12,990

+ applicable taxes

Mastering M – $229

Lifetime Access

Enroll Now

2 Courses Bundle

$428 $359 | INR 21,230

+ applicable taxes

Mastering M – $229

DAX & Data Modeling Course – $199

Lifetime Access for both

Enroll Now

Best Deal

3 Course Bundle

$575 $488 | INR 29,725

+ applicable taxes

Mastering M – $229

Power Query – $147

DAX & Data Modeling Course – $199

Lifetime Access for all

Enroll Now

behzadghah

You broke the M language taboo for me. Thank you

abdulrehman56

Great explanation I watched full video with being a bored for 1 second

martyc5674

Hey Chandeep- this is Gold for anyone learning M.

Push Beyond Power Query’s User Interface & Solve Tricky Data Cleaning Problems.

Why Should You Learn M?

M v/s Power Query User Interface

But Learning M is Hard!

How my Teaching Method is Different!

sujit3375

Wiel Souren

emilmubarakshin49

mirrrve1115164

raimundojs9547

bradj229

readistreet9383

Jayo5678

McKaySavage

Course Outline (Weekly Schedule)

Part 1 – Concepts

Part 2 – Patterns, Recipes and Case Studies (9 Practice Cases)

Part 3 – Power Query Functions – 50 Videos

Hi, My name is Chandeep, I’ll be your Instructor.

gennarocimmino

Austin

sebfromgermany3819

joanstoner6252

cherianiype

reanalytics1863

Any Questions?

100% Money-Back Promise!

1 Course

$229 | INR 12,990

2 Courses Bundle

$428 $359 | INR 21,230

3 Course Bundle

$575 $488 | INR 29,725

See you inside the course! ✅

behzadghah

abdulrehman56

martyc5674

Push Beyond Power Query’s User Interface &
Solve Tricky Data Cleaning Problems.