PowerPivot for SharePoint supports the Microsoft Excel 2010 workbook, which contains the PowerPivot data model. The users can import this Excel workbook into a PowerPivot gallery in order to publish their reports. As a result, PowerPivot for SharePoint is necessary for the end users as they can view and interact with the reports; also, it's not necessary to install it into every end user's system where the PowerPivot add-in is installed. For these things, the Analysis service farm process in the SharePoint Server takes the workbook, and the memory is used by the analysis service; also, it helps in data aggregation, data processing, and some other features. If a user refers to the previous screenshot, which is the PowerPivot for SharePoint architecture, he/she will find a connection between the Excel workbook and analysis service by the analysis service PowerPivot engine. PowerPivot for SharePoint works based on these concepts.
Importation of the...