Stuck with Power Query's User Interface?
Want to go beyond and solve more advanced data cleaning problems?
This book is for YOU!
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 sure want to know your Power Query clicks. 😉 That's it!
In This Book, You’ll Learn
01.
How to think & construct a logical problem solving process. This is the one thing that you'll enjoy the most.
02.
How to solve more advanced data cleaning problems that go beyond the scope of User Interface.
03.
How to make your queries robust & more adaptive to structural changes in your data.
In This Book, You’ll Learn
01. How to think & construct a logical problem solving process. This is the one thing that you'll enjoy the most.
02. How to solve more advanced data cleaning problems that go beyond the scope of User Interface.
03. How to make your queries robust & more adaptive to structural changes in your data.
What is in the Book?
In the initial few chapters, I cover fundamental concepts like Lists, Records, Tables, Manipulating Values etc..
In the later chapters, I cover more advanced problems using iterations, custom functions, nested tables and solutions to a few most common patterns and recipes.
There are also exercises at the end of most chapters to test your understanding.
What is in the Book?
In the initial few chapters, I cover fundamental concepts like Lists, Records, Tables, Manipulating Values etc.. In the later chapters, I cover more advanced problems using iterations, custom functions, nested tables and solutions to a few most common patterns and recipes.
There are also exercises at the end of most chapters to test your understanding.
I made this book special for YOU.
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.
No fluff, no jargons!
Highly practical and useful stuff right from the start.
Relevant Examples.
Throughout the book, I've used highly practical and relatable examples to explain even the most dry concepts and exercises.
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!
I made this book special for YOU.
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.
No fluff, no jargons!
Relevant Examples.
An image can replace a 1000 words.
Pre-order before Feb 7
& get $150 worth of tutorials for FREE!
- Table.TransformColumns
- List.Transform
- Table.Skip
- List.Generate
- List.Accumulate
- List.Select
- Table.Schema
- Table.Profile
- Table.Max
- Table.AddColumn
- How to Create a Calendar Table – Video + M Code
- How to Create a Fiscal Calendar Table – Video + M Code
- Combine Data From Multiple Excel Files
- Fix Messy Data from Multiple Sheets
Step 1: Pre-order or buy the digital copy of the book before Feb 7.
Step 2: Send your purchase receipt to – [email protected]
Step 3: And we’ll send you the bonus material worth $150 for free!
Step 1: Pre-order or buy the digital copy of the book before Feb 7.
Step 2: Send your purchase receipt to – [email protected]
Step 3: And we’ll send you the bonus material worth $150 for free!
I’ve received so much love💖
I’ve received so much love
About Chandeep Chhabra
I am an expert in Data Analysis and Business Intelligence, specializing in Excel and Power BI. I run the YouTube channel "Goodly," with over 100K subscribers and 30K followers on LinkedIn. My channel is known for simplifying complex topics and delivering high-quality content.
Over the past 10+ years, my online courses have received positive reviews and thousands of students have benefited from my approach, which combines clear explanations with practical, real-world examples. I have been a speaker at international Excel conferences like the Global Excel Summit in London and Bulgaria Excel Days in Sofia.
My background includes 4+ years in financial analysis and investment banking. Currently, I am the Founder and Principal Partner at Goodly Insights, a data analytics consulting firm providing Power BI and Excel-based solutions to companies worldwide.
