Power Query: Beyond the User Interface

Have you already transformed your data (along with your life) by learning Power Query? This book will help you take your data transformation a lot further by teaching you the M language that sits behind the user interface.

By showing you various concepts and examples throughout the book, you’ll learn how to think through the problems and see how to solve them using M. To try to make you feel at home, the book includes a lot of images, concept diagrams, and some silly jokes—as if you and Chandeep were working through the examples together in your living room over coffee.

One of the most important things that Chandeep does is illustrate the intermediate steps during his problem-solving journey. Getting to the end results is important, but understanding how you got there is critical to being able to develop your own solutions in the future, and Chandeep’s explanations will help you do exactly that. From the foundational concepts of tables, lists, and records and how to move between them, to advanced concepts like List.Generate, Chandeep does a great job of explaining the concepts in a layered way, using business-focused examples. He’s even included practice sets and examples for you to hone your skills.

Who This Book Is For?

• Do you already know the “clicks” of Power Query, either in Excel or Power BI?
• Do you already know how to create basic queries that can combine data, remove columns, filter and unpivot rows, etc.?
• Have you come across a few data cleaning problems that have made you scratch your head and wonder, “How am I going to do that?”
• Have you already finished Master Your Data and are looking to take your skills to the next level?

If you were mostly nodding through this list: Congratulations! This book is for you! It will provide solutions to many of the problems that business users struggle with every single day—problems that are clearly beyond the scope of Power Query’s UI capabilities. This book will turn you into an advanced “data monkey”.

Product Details

• Format: PDF
• Publisher: Holy Macro! Books (Digital Version – April 2025)
• Language: English
• ISBN-13: 978-1-61547-167-6

All sales are final; no refunds on digital books are available.