O'Reilly logo

Business Intelligence in Microsoft® SharePoint® 2010 by Mariano Teixeira Neto Norman P. Warren John Campbell, and Stacia Misner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required