Summary

In this chapter, we have explored not only using PowerPivot as a destination or consumption tier for business intelligence solutions, but also using PowerPivot solutions as data sources. PowerPivot data refresh, combined with a PowerPivot for SharePoint solution, can ensure that the correct, most up-to-date information is reflected in your solutions. Additionally, PowerPivot as a data source can be leveraged for the following:

• Reporting based on existing PowerPivot for SharePoint solutions
• Accessing the data in the PowerPivot Management Dashboard

Using PowerPivot for SharePoint solutions as a data source for PerformancePoint Services