With PowerPivot, Microsoft brings the power of Microsoft's business
intelligence tools to Excel and SharePoint users. Self-service business
intelligence today augments traditional BI methods, allowing faster
response time and greater flexibility. If you're a business
decision-maker who uses Microsoft Office or an IT professional
responsible for deploying and managing your organization's business
intelligence systems, this guide will help you make the most of
PowerPivot.
Professional Microsoft PowerPivot for Excel and SharePoint describes
all aspects of PowerPivot and shows you how to use each of its major
features. By the time you are finished with this book, you will be well
on your way to becoming a PowerPivot expert.
This book is for people who want to learn about PowerPivot from 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.
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 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.
The companion Web site includes all the sample applications and reports
discussed.
