PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. Leveraging familiar Excel features, users can transform enormous quantities of data from virtually any source with incredible speed into meaningful information to get the answers they need in seconds.
Using SQL Server PowerPivot for SharePoint 2010 (delivered thru SQL Server 2008 R2 in SharePoint 2010), end users can effortlessly and securely share their finding with others and work seamlessly in the browser with the same performance and features as the Excel client. PowerPivot for SharePoint even helps IT departments improve their operational efficiencies through SharePoint-based management tool called PowerPivot Management Dashboard. IT administrators can track usage patterns over time, drill down to obtain more details, discover mission-critical solutions, and ensure performance by making sure users have the appropriate resources.
For more information visit: