The Definitive Guide to Power Query (M)

I have been working with Power BI for 8 years and have been about as deeply immersed in Power Query as one can be for most of that time. I'm only 400 pages in but have already learned several techniques and concepts I didn't know I was missing. This has served to tie together other key concepts and strengthen my skills. While I agree with an earlier reviewer who wrote "This book is geared more for someone familiar with Power Query", somebody new to Power Query who recognizes the importance of learning to use this powerful data transformation tool will find this to be a vital resource. This book stands out among so many technical books in that it functions equally well as one you can read through from front to back while working through the examples and as one you can go to when researching a solution to a specific challenge.

Great book to build thorough understanding of Power Query and M language.

I have several Power BI books but most focus more on Power Pivot and Dax than Power Query. This book is enormous and it's all PQ. I've got the thing bookmarked from front to back. Great reference for problem-solving and detailed PQ knowledge.

Lot of useful information with examples. Great reference

Excelente contenido. A practicar y ver que resulta

As a seasoned Power Query user, I recommend this book to the ones who want to learn Power Query M lanhuage. I just finished the chapter 5 of this book, Understanding Data Type, in which I learned that we can ascribe a data type in certain functions without actually processing a type transformation. This idea is new for me, and by using this we can enhance the performance of query. Looking forward to the following chapters.

As someone deeply immersed in the world of data analysis and Power BI, I've eagerly awaited a comprehensive guide that truly unlocks the potential of Power Query. "The Definitive Guide to Power Query (M)" exceeds all expectations and stands as a monumental achievement in the field. Having had the privilege of interacting with Melissa de Korte, Greg Deckler, and Rick de Groot on several occasions, I can attest to their expertise and dedication to empowering data professionals. Their passion shines through every page of this book, making complex concepts accessible to both novices and seasoned practitioners alike. What truly sets this book apart is its practical approach to mastering complex data transformations. The authors don't just teach you how to use Power Query; they equip you with the skills to tackle real-world challenges with confidence and efficiency. The depth of coverage is unparalleled, providing insights and techniques that I've struggled to find elsewhere. I'd be remiss not to express my heartfelt gratitude to Brian Julius, whose mentorship and guidance played a pivotal role in my journey through the realms of data analysis and Power BI. His expertise and encouragement have been invaluable, and I'm thrilled to see his influence acknowledged in this book. "The Definitive Guide to Power Query (M)" is more than just a reference manual; it's a roadmap to mastery. Whether you're a data analyst, business intelligence professional, or enthusiast eager to harness the power of Power Query, this book is an indispensable companion on your quest for excellence. In conclusion, I wholeheartedly recommend this book to anyone seeking to elevate their data analysis skills and unleash the full potential of Power Query. Melissa, Greg, Rick, and Brian have created a masterpiece that will undoubtedly leave a lasting impact on the data community. Bravo!

The book begins with a brief history on the M Language then moves into the Power Query Editor. It provides you with step-by-step instructions to guide you through examples with practice files. It highlights topics such as Nested Structures, Working with Dates and Times; Splitting, Replacing, and Combing Text, Debugging, Query Optimization, and Extensions to name a few areas. While I’ve used Power Query and M for several years, I recommend this book as there is always more to learn and it can serve as a great reference for both beginners and experienced Power Query users.

This is definitely not a beginner's guide. It really breaks down M from the bottom up. This means it goes beyond the user interface of Microsoft's Power Query Editor. I have been working with Power Query for more than 5 year, but already in the first 100 pages I wrote down a dozen tips and tricks that I had not learned about before. Highly recommended for anyone who needs to understand how to extract, transform and load your data in a Power BI data model to the highest level.

Power Queryに関する解説本を色々読みました。 これまでは「Master Your Data with Power Query in Excel and Power BI」が最も印象に残りました。まだ読んでいない方は、先にそちらを読むことをお勧めします。Power Queryの基本から応用まで、幅広く学べます。 もし「Master Your Data with Power Query in Excel and Power BIの次に、何を読めば良いか」と聞かれたら、この書籍を推薦します。私もずっと探していましたが、やっと出会うことができました。 ▪︎良かった点 M言語について、体系立てて学ぶことができます。英語なので苦労はしますが、日本語書籍でこのレベルのものは、まだ存在しません。まだ読んでいる途中ですが、英語でも読みやすい内容です。 ▪︎気をつける点 内容がM言語に偏っていますので、Power Query 初心者向けではありません。個人的には、日本語解説書→ Master Your Data with Power Query in Excel and Power BI→本書の順番が良いと思います。 私はKindle版を購入しましたが、購入者は手続きを踏めば、PDF版をダウンロード出来るようです。おそらく、書籍版でもPDF版を入手出来ると思います。書籍とデジタルデータ両方欲しい方は、値段は高いですが、まず書籍版を購入することをお勧めします。

The title says it all. This is the DEFINITIVE guide to Power Query M-code. An in depth explanation of how the M-code environment works with real examples. Complex topics made simple and easy to understand. You will become an M-code guru from digesting this book.

The item is very good and as I expected

Un molt bon llibre per aprendre Power Query M o consolidar coneixements. Un llibre molt ben estructurat i amb explicacions clares.