Ramblings of a data dork: from BI and Big Data to Travel and Food
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!
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
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!
All-in-all I would highly recommend this book to the IT Pro and would give this book 5 out of 5 stars – . Definitely worth the $$$.
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
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 !
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.
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.
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 AppendixA.zip 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.