Harinath S., Pihlgren R., Lee D.G.-Y. Professional Microsoft PowerPivot for Excel and SharePoint

Wiley Publishing, Inc., 2010. – 388 p.This book covers the first version of PowerPivot, which ships with SQL Server 2008 R2 and enhances Microsoft Office 2010. It provides an overview of PowerPivot and a detailed look at its two components: PowerPivot for Excel and PowerPivot for SharePoint. It explains the technologies that make up these two components, and gives some insight into why these components were implemented the way they were. Through an extended example, it shows how to build a PowerPivot application from end to end.
This book is for people who want to learn about PowerPivot end to end. You should have some rudimentary knowledge of databases and data analysis. Familiarity with Microsoft Excel and Microsoft SharePoint is helpful, since PowerPivot builds on those two products. Part I of the book is for those who want an introduction to PowerPivot. It provides background on self-service BI and how PowerPivot fits into the picture. It also includes a quick end-to-end walkthrough of the major features in PowerPivot for those who want to get their feet wet.
Part II is for those who want to understand the client half of PowerPivot — PowerPivot for Excel. This includes Excel power users who work with PivotTables day in and day out, and are curious about the additional capabilities PowerPivot can provide to them, as well as BI professionals who want to understand the details of what PowerPivot is and what you can do with it. If you are a business analyst, this section will be particularly relevant for you.
Part III of the book is for those who want to learn about the server side of PowerPivot. This includes IT professionals who want to learn about how to plan for, deploy, and maintain PowerPivot’s server infrastructure. Since PowerPivot builds on SharePoint, SharePoint administrators who are responsible for adding PowerPivot to their SharePoint farm will find a wealth of information in this section of the book.