Want to go beyond Power Query’s UI?
This book is a treasure trove for anyone looking to master the M language
This guy is a rockstar for me. I am addicted to power query now.
foreword written by the expert himself
Recommended by Ken Puls
Excel MVP & global Power Query expert
"Chandeep does a great job of explaining the concepts in a layered way using practical business focused examples. While the content is fantastic, I also love the style of delivery – if you watched Chandeep's videos online or have met him in person – you'll find that this book is delivered in his voice."
"I found this made it engaging and approachable, a true gift when trying to learn a complex topic. I'll certainly be recommending this title to all my students who want to take the next step in their Power Query journey."
Why Learn {M}
Power Query's User Interface is an awesome starting point for cleaning your messy data.
But soon after it's magic settles down you'll run into problems that are beyond the clicks of the UI and that is where you begin learning M , the language behind Power Query's User Interface.
You don't need to be a coder to learn M but I'm sure you want to know your Power Query clicks. 😉 That's it!
Here's What You'll Learn
- 1.How to think & construct a logical problem solving process. This is the one thing that you'll enjoy the most.
- 2.How to solve more advanced data cleaning problems that go beyond the scope of User Interface.
- 3.How to make your queries robust & more adaptive to structural changes in your data.
- 4.There are also exercises at the end of most chapters to test your understanding.
- Power Query's User Interface
- What Is M, and Why Do We Need It?
- Where Is M in Power Query?
- M Syntax: A Few Basics
- Example 1: Writing a Simple M Query
- Example 2: Writing Another Simple M Query
- Feed Power Query What It Eats
- Order of Evaluation
I made this book special
1.
It's not a boring textbook
I've written this book as if you and I were sitting in your living room and doing a one-on-one training. There are twists and turns, some irritating but important repetitions and a dash of humor.
2.
No fluff, no jargons!
Highly practical and useful stuff right from the start.
3.
Relevant Examples
Throughout the book, I've used highly practical and relatable examples to explain even the most dry concepts and exercises.
4.
An image can replace a 1000 words
I've put in a lot of Images and concept diagrams for the ease of understanding hard things. I mean a lot!
Get The Book
To complement your reading, you can also get 4 hours (150$ worth) of exclusive video lessons, where I walk you through key concepts with practical, real-world examples.
10 Most Important Power Query Function Videos
- 1.Table.TransformColumns
- 2.List.Transform
- 3.Table.Skip
- 4.List.Generate
- 5.List.Accumulate
- 6.List.Select
- 7.Table.Schema
- 8.Table.Profile
- 9.Table.Max
- 10.Table.AddColumn
2 Custom Detailed Function Tutorials
- How to Create a Calendar Table – Video + M Code
- How to Create a Fiscal Calendar Table – Video + M Code
2 Advanced Data Cleaning Case Studies
- Combine Data From Multiple Excel Files
- Fix Messy Data from Multiple Sheets
eBook + Exercise Solution Videos
Total Value: $68.99
Price: $49 + taxes
Save 29%
Best Value
Complete Power Query Book Bundle
Total Value: $266.99
Price: $69 + taxes
Save 74%
People love my book
and you'll too!
How I made this book happen
behind the scenes
After a year of drafts, edits, and re-edits, we sold over 200 copies on the first night.
But here’s how this book actually happened
When I was doing consulting work, I was drowning in messy data, the kind that makes you want to pull your hair out. Half-missing, full of errors, and just plain ugly. I tried every trick I knew, but nothing worked.
Eventually, I had no choice but to dig deeper and learn more advanced ways of cleaning data. That’s when I discovered the M language. The thoughts and notes I gathered along the way became the foundation of this book.
Hi, My name is Chandeep! 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.
Read the First Chapter
