7 of 7 people found the following review helpful
This review is from: Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning (Business Skills) (Paperback)
Marco and Alberto explain PowerPivot in an amazing way. Their book is well structured, highly instructive, and very informational. A lot of times they point out useful, specific info. For example, quote "The only interesting function in the group of A-suffixed functions is the COUNTA one. It returns the number of cells that are not empty and works on any type of column". Things like that saves my time. I don't have to meticulously go through the whole list. The book explains difficult concepts in an easy-to-understand way. For example, it explains (de)normalisation in data modelling brilliantly. The book enables us to quickly understand the points by following the examples.
The book is particularly useful for people who never used PowerPivot and just started learning it. It explains, step by step, how to retrieve the data and produce reports, including creating dashboards and data models. I have used PowerPivot and SSAS, so for me the most useful chapters are chapter 4 (evaluation context), chapter 9 (data model patterns) and the DAX function reference in the appendix. I will use this book as reference. I particularly like the eBook which comes with the book. It enables me to read on the train without the heavy book in my bag.