THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Book Review: Microsoft PowerPivot for Excel 2010: Give Your Data Meaning

I'm loving my Kindle. I seem to be getting through books so much faster. One book that I recently read was Book Review: Microsoft PowerPivot for Excel 2010: Give Your Data Meaning by Marco Russo and Alberto Ferrari.

I really liked this book. It provided quite good coverage of PowerPivot use in Excel 2010 and also spent some time mapping the use of PowerPivot to organizational requirements. Marco and Alberto provided more coverage of DAX (Data Analysis Expressions) than I have seen anywhere else, particularly in relation to the CALCULATE verb.

If I have any criticism of the book, it's probably just the order of the chapters. I can imagine that many people won't want to delve so deeply into DAX and may stop reading before they get to the later chapters. I'd like to have seen much of the DAX material at the back of the book as a type of "advanced DAX topics" section, given that the remainder of the book doesn't really depend upon it.

I was left feeling that there's a need for another type of DAX book, much like the book that Art Tennick wrote for MDX: Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008. In that book, Art provides a large number of "recipes" for how to achieve common tasks with MDX. I'm sure that's also needed for DAX.

Anyway, Marco & Alberto's book is definitely recommended.I'd give it 8 out of 10. (And a big thumbs up to the publisher for making a Kindle version available too).

Published Wednesday, June 01, 2011 4:22 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Tony McGee said:

I just finished watching some great presentations from Marco & Alberto at SQLBits 8 in the UK - BISM Introduction & PowerPivot Advanced Data Modelling - so nice to hear a good review of this book as it's next on my list.

http://sqlblog.com/blogs/marco_russo/archive/2011/05/28/bism-introduction-and-powerpivot-advanced-data-modeling-sqlbits-video-available.aspx

June 1, 2011 5:30 AM
 

Marco Russo (SQLBI) said:

Greg,

thank you for the feedback!

I'm interested to go more in detail about the order of the chapters: what you would have anticipated? Except the SharePoint chapter, the other depends on chapter 6, unless you want just the solution to a specific problem, even if the goal of the book is not intended to be a set of recipes (I agree it would be interesting!). The intent is to explain DAX and how to leverage DAX and data modeling in PowerPivot in order to solve real world problems.

Anyway, I'd like to get more details to better understand how to improve v2... :)

Marco

June 1, 2011 3:35 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement