Chapter 5. PowerPivot for Excel and SharePoint

After completing this chapter, you will be able to

  • Understand PowerPivot for Excel and PowerPivot for SharePoint.

  • Understand how PowerPivot extends Excel functionality with Data Analysis Expressions.

  • Create PowerPivot workbooks in Excel 2010.

  • Publish PowerPivot workbooks to SharePoint 2010.

  • Set up a periodic data refresh to a PowerPivot-enabled workbook in SharePoint 2010.

Introduction

As explained in Chapter 1, you can understand business intelligence (BI) as activities and practices that use fact-based support systems to improve the business decision-making process. Traditionally, those fact-based support systems have often been data-driven analytics and reporting tools developed by database ...

Get Business Intelligence in Microsoft® SharePoint® 2010 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