PowerPivot for Excel and SharePoint

Summary

This chapter briefly introduces you to PowerPivot for Excel and PowerPivot for SharePoint. It provides guidance on creating a PowerPivot workbook, importing data from various data sources, and mashing them up using DAX. This chapter also demonstrates how to publish a PowerPivot workbook to SharePoint and how to schedule data refreshes, and it explains how IT professionals can manage PowerPivot for SharePoint by using the PowerPivot Management Dashboard. To learn more about PowerPivot, you can look for books dedicated to PowerPivot for Excel and to PowerPivot for SharePoint. You can also find more information by referencing the following resources:

• The official MSDN blog at http://blogs.msdn.com/powerpivot.

• Rob Collie’s blog at http://www.powerpivotpro.com (for PowerPivot for Excel). Rob Collie was a Program Manager in the Analysis Services team that worked on PowerPivot for Excel.

• Dave Wickert’s blog at http://www.powerpivotgeek.com (for PowerPivot for SharePoint). Dave Wickert is a Program Manager on the Analysis Services team, working on PowerPivot for SharePoint.