Top positive review
Learn Power Pivot for Excel the EASY way and save your sanity!
1 November 2016
This Book is the FIRST step in learning Power Pivot. I know because I learnt the hard way that Rob Collie's book "Power Pivot and Power BI" is not for the uninitiated. If you want to know HOW to build successful Pivot tables in Power Pivot you first need to learn how this software add-in works. It is extremely powerful and just like learning Visual Basic, you need to start at ground level. As Collie's book is about Level 13 and up, you definitely need Matt Allington's book (Learn to Write DAX) first.
It doesn't expect the user to know anything about Power Pivot, and is written in an easy to understand style with excellent explanations and high-lighted notes about how Power Pivot is structured. From how it works through the filter process before it manipulates the Data; this was the most difficult thing to get my head around so I was relieved to find someone who spoke my language. After a near fatal (for my computer) attempt with Rob Collie's book, I am glad I found Learn to write DAX. It uses the same Data Base model as Rob Collie's book, which is a real plus in building confidence and competence, and it was great to be able to make sense of how Collie's Pivot Table examples were built.
Again, its no good going to the 13th floor of the Power Pivot building until you've worked you way through the first 12 floors. Unless, of course, you enjoy being driven insane!