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
Get PowerPivot for Business Intelligence Using Excel and SharePoint 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.
