Chapter 9. PowerPivot for Excel

IN THIS CHAPTER

• Overview of PowerPivot

• Installing PowerPivot

• Using PowerPivot

• Getting the Data

• Preparing the Data

• Presenting the Data

One of the more exciting recent additions to the Microsoft business intelligence (BI) suite is a technology known as PowerPivot. I use the word technology because PowerPivot is not a new product so to speak, but rather it is a new capability for very powerful data analysis, and it impacts Excel, SharePoint, and SQL Server. PowerPivot is available as a standalone add-in to Excel, and is also available as a SharePoint service. This chapter explores PowerPivot for Excel.

Overview of PowerPivot

Business users, and in particular business analysts, need to be able to process ...

Get Microsoft SharePoint 2010 Business Intelligence Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial