Two technologies: PowerPivot for Excel= Free add-in to Microsoft Excel 2010. PowerPivot for SharePoint=allows for publishing, access and management of apps directly in SharePoint. PowerPivot for Excel is an free Excel Add-in that allows you to easily access data from diverse data sources, easily mashup data within Excel, process large volumes of data (millions to hundreds of millions of rows), use native Excel capabilities to analyze the data. With PowerPivot for SharePoint – which requires SQL Server 2008 R2 installed with SharePoint 2010 – users can publish their PowerPivot Workbooks to SharePoint in the PowerPivot Gallery. They are easily accessed and rendered via Excel Services; data is refreshed via a pre-determined schedule.