Holy Macro! Books Master Your Data with Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow

Love the way its structured, easy to follow, and the links to online files to follow along with are super useful. Im only about half way through and have already picked up enough to have implemented several time saving data cleaning processes in my day job.

This book clearly sets out the basics - such as a definition for 'binary' data type - it just means its a file. It gives step by step instructions for each example and has downloadable example files to practice. While it covers basic items thoroughly, it also gets into much more advanced stuff, such as query folding, MCode and parameters. Even those quite familiar with PQ will find this book a great source. I recommend it for those new to PQ and for more advanced users.

It is a well thought out guide with great examples to help you learn. Each Chapter builds on the skills learned, I wish I had known about Power Query much sooner in my Accounting Career. Thanks Ken and Miguel for all your efforts, it’s a game changer.

What to say… first edition was amazing, second even better. For everyone that are into Excel, Data, this is must have!!!!

I waited this book for two years, pre-ordering in 2019 I believe, and it did not disappoint. In addition to the enhanced beginning level it now covers, this book also gets into understanding M coding better, which helps readers at intermediate level tremendously. By "enhanced beginning level", I meant it looks at generating queries in a holistic way, i.e. building complex queries from the ground up. This book is best fit for PQ users who have a few years of working experience of using PQ.