Professional Microsoft PowerPivot for Excel and SharePoint


To make sure our book Professional Microsoft PowerPivot for Excel and SharePoint (written by Siva Harinath, Ron Pihlgren, and myself) is up to date, I’ve added this page to include some of the great reviews as well any errata (i.e. corrections) that we want to call out.  After all, we did rush to get the book out in time for the release of PowerPivot and apologize for the “rough edges” folks are finding. We appreciate you folks who raise these issues and we will work through them to help get you answers and update the errata pages. Thank you all!


Great Reviews of our book

Rob “PowerPivotPro” Collie’s Review | Review

5.0 out of 5 stars Perfect for those deploying/evaluating a full PowerPivot System, August 19, 2010

 Cutting to the chase, the Red book (I’m gonna call it that for short) covers a lot of things …
What the book IS – Consistently readable and info-rich

Teo Lachev’s Review

Overall, I’d highly recommend this book to anyone interested in PowerPivot and self-service BI. The book does a great job explaining the capabilities and limitations of the tool. I couldn’t stop reading it!

Dan English’s Review

 All-in-all I would highly recommend this book to the IT Pro and would give this book 5 out of 5 stars – image.  Definitely worth the $$$.

Bryant Avey Review

5.0 out of 5 stars Good troubleshooting pointers for Installing PowerPivot SharePoint Integration, July 16, 2010

If you’re having trouble installing and configuring PowerPivot for SharePoint 2010, then this is a must have resource and reference book

Kasper de Jonge’s Review

5.0 out of 5 stars Great book, great value when you want to know more on the PowerPivot internals, August 2, 2010

I recommend this book for anyone who wants to start using or consulting PowerPivot at a professional level, it is really full with information and background. I read it in two days while I was on holiday great stuff !

Derek Comingore’s Review

5.0 out of 5 stars Professional PowerPivot Review, August 16, 2010

Professional Microsoft PowerPivot is an excellent manual authored by key members of the Analysis Services & SQLCAT teams. … If you are serious about mastering the new self-service BI technology you should consider the manual as required reading.

Chris Webb’s Review

If you want to learn more about the Sharepoint side of things I can recommend “Professional PowerPivot for Excel and Sharepoint” by Siva Harinath, Ron Pihlgren and Denny Lee…



Below are the corrections concerning our first version of the “Professional Microsoft PowerPivot for Excel and SharePoint” book.  The official Wrox “Professional Microsoft PowerPivot for Excel and SharePoint” Errata page is also linked here.

Page 247

I noticed an error on page 247 of the PowerPivot for Excel and SharePoint book.  The statement is:

The last step — PowerPivot System Service to Analysis Services — is performed using Windows authentication via the Claims-To-Windows Token Service (c2wts)

 This is incorrect – it should be:

The last step — PowerPivot System Service to Analysis Services — is performed using Windows authentication via the PowerPivot System Service’s Windows service account.

Sorry for the confusion!


Concerning the SDRAudit.bak database

WRT the SDRAudit.bak database issue: the tables that are missing aren’t used in later chapters building the healthcare application. The related tables you need to import are only the auditedAction table and the AuditedClassType tables. The other tables were initially considered to be used but later they weren’t. So you can build the app without those tables.

This also affects Chapter 4. On Page 108 (#16), you are asked to create a relationship using the AuditedObject table. This relationship also isn’t needed later in the book.

WRT the SDR_Healthcare.xlsx already having the data loaded: The file (used to create the starting state of the healthcare app) doesn’t contain SDR_Healthcare.xlsx. The various chapter downloads do contain versions of this spreadsheet with data already loaded but that is by design – those chapter downloads are intended to be the state of the workbook at the end of each of those chapters. They are available in case you wanted to play around with those chapters’ results without going through the steps of actually creating the app or for working through the instructions of the following chapters without starting from scratch.


One Comment

  1. […] Side Note: As well, there is an in depth discussion on Changing Passwords in Chapter 9 of Professional Microsoft PowerPivot for Excel and SharePoint. […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s