SQL Server 2012 brings in enhanced data analysis capabilities for both PowerPivot client in the form of the Excel add-in as well as the PowerPivot server-side component in SharePoint. This enables Microsoft Office users to have self-service business intelligence capabilities with merely a few clicks, something which was never there before. Users are now able to integrate data from heterogeneous sources more easily and provide powerful visualization on the data using familiar tools such as Excel and SharePoint, thus enabling the businesses to take correct decisions.
PowerPivot is offered as an add-in to Excel 2010 that allows data integration from any source and syndication, including Open Data Protocol (ODATA) feeds, RDBMS sources, Hadoop, and so on. Using PowerPivot, you could create your own data models from any of the diverse data sources previously mentioned and import large amounts of data into Excel directly. If there is a need to have these data models as a...