Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics

The author gives an outstanding overview of using modern Excel for analytics. At just over 200 pages (the print edition), the book cannot go into depth on all topics. It gives a broad overview and gets fairly detailed on Power Query and Power Pivot. Given the limited space, on numerous occasions, the author recommends subject specific books for additional details.The author has a wonderful writing style that makes the book an easy read. That is not an easy accomplishment for a technical book. While the book has some great technical information, the strength of the book is the authors ability in explaining an approach to using the tools together in a cohesive strategy. Few if any technical books succeed on this level. I think highly enough of this book that I just order the author's previous book.

Modern Data Analytics in Excel is the book I wish I had when I was starting out: with Excel and as a Data Analyst. It is so clear, easy to follow, and very interesting. I'm so glad George wrote it.For several years I often struggled because I didn't know about Power Query & Power Pivot. But you don't have to. Modern Data Analytics in Excel will get you up and running in no time with these 2 extremely powerful tools. Very much worth the price.

Excel has changed a lot over the past 10 years, particularly for data analysis. For long-time Excel users like me, trying to learn how to use Power Query and Power Pivot is a bit of an uphill battle, especially since we're already comfortable analyzing data through functions (e.g., SUMIFS, AGGREGATE, etc.) and standard Pivot Tables.I've been following the author on LinkedIn for sometime and had been looking forward to this book and it's exactly what I have been looking for. It comes with example files you can download and takes you through Power Query and Power Pivot so you can learn by doing. Highly recommended!

Do you want to become a highly valued team member who is considered a go-to resource for others? Read this book! I say this as a former analyst and former senior leader in a bank. This book will help you advance in your career both technically and as a leader.

The media could not be loaded. The book is average black and white, regular paper- makes it difficult to read diagrams and excel snapshots. And for the price the book does not go into that level of details

This book gives excellent tips to manipulate and analyze data in the latest version of Excel. Easy to follow and makes work much more efficient. I highly recommend it to anyone who works with a lot of data—make your life easier and buy this book.

Another outstanding contribution to the world of data analysis from Stringfest. Concise and well written. Terry

As expected, concise and focused.Very helpful to get the needed overview.Easily read yet packed with actionable info.