The long awaited book from Ken Puls and Miguel Escobar has just been released in digital edition. I read this book over the weekend and wanted to share my experience with anyone considering buying this book or wanting to learn more about Power Query.
This book is 220+ pages of Power Query information that covers the length and breadth of what you need to know to use this great Excel tool from Microsoft. Ken and Miguel have structured the chapters in a way that builds from the simple introductory topics up to some of the more advanced (but still easily learnable) techniques that can only be accessed when you get into the M programming language (also called the Power Query Formula Language).
Here are a few of the highlights for me from the book.
- Easy to read and has a well structured chapter layout building from the basics to the advanced.
- Broad coverage of some of the less obvious features (such as default settings) that can improve the user’s experience in using Power Query.
- Lots of tips and techniques that will help you become a super user; like pointer queries, import from named range, dynamic headers to name a few.
- And still more tips and information about “gotchas” like accidentally corrupting the data model or the dangers of the “any” data type. It explains the potential problems and how to avoid them.
- A great section on how to go about un-pivoting complex nested tables, and another on how to get data from a web page when the data itself is not in a table format.
- The book explains the differences in the UI across Excel 2010, Excel 2013 and Excel 2016.
- There are lots of comparisons between Excel functions and the equivalent Power Query functions. Given most of us already know the Excel functions, this makes it really easy to understand the new Power Query syntax.
- And finally, the book is well indexed in the table of contents and also in the Index at the back of the book. This makes the book ideal to keep as a reference guide for when you need a refresher later.
M is for Data Monkey is available for purchase and immediate download from my Online Store here.
If you want more information about Power Query, you can also read my book review of Chris Webb’s book that I wrote in July 2015.
If you prefer instructor lead learning, I have a comprehensive online training course on Power Query and the M Language. The course consists of 7.5 hours of video instructions and guides that will teach you how to use Power Query from the UI as well as using the M Language.