Mastering M in Power Query
You’ll learn to build robust Excel / Power BI models by
creating dynamic queries using the M language.
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…
I’ve come a long way and in the process have built some very sophisticated queries, all thanks to Power Query’s M Language.
Here is a quick demo of what the M language is capable of doing as compared to Power Query’s User Interface.
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…
I am here to make learning M easier than struggling on your own.
➜ No Jargons, just simple English.
➜ Developing a Problem-Solving Mindset.
➜ Case Based Learning.
Jab promo trailer itna acha hai toh movie kitni achi hogi… All the best Chandeep for upcoming M code. Lots Of Love to goodly
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.
Chandeep you don’t stop amazing us with you briliant ideas. Can I sign up for this course please?
Waiting your real PQ – M course!!
You’re the best! Waiting for your M Language Course.
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!
Waiting for the M course
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”.
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!
These are important fundamentals of how the M language works, explained by solving practical real life problems.
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 |
●●●●○ |
These are long form case studies that test your understanding of the concepts to solve dense and more difficult problems.
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 |
●●●●● |
Short videos explaining the most important Power Query functions. | Intermittent ongoing release schedule.
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.
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.
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.
Who needs textbooks if you have Chandeep’s tutorials! Cheers mate for this one – it’s excellent
Thank you so much for this video. It was more helpful then most of the others I watched!! I understand much better than
before.
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!
Your contribution is visible, many are getting salary raises because of the skills you share here. Keep up the great work
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.
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.
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.
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!
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.
Yes, your access will be active for lifetime.
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.
+ applicable taxes
Mastering M – $229
DAX & Data Modeling Course – $199
Lifetime Access for both
+ applicable taxes
Mastering M – $229
Power Query – $147
DAX & Data Modeling Course – $199
M Course Note Taking Template – $49
Lifetime Access for all
You broke the M language taboo for me. Thank you
Great explanation I watched full video with being a bored for 1 second
Hey Chandeep- this is Gold for anyone learning M.