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