Vision
PowerPivot: brief discussion
Written by: Margriet Bruggeman, Nikander Bruggeman.
May 2, 2010
PowerPivot: brief discussion
Excel is a very powerful tool that can be used by end users for analyzing corporate data. Excel also allows you to import data from various data sources, such as a database. The contents of such data sources may be huge. PowerPivot integrates with both Excel and SharePoint and tries to make Excel more scalable, faster and flexible. PowerPivot for Excel literally allows you to import, filter, and sort millions of rows of data, allows you to build relationships between data coming from different data sources, and stores data in a highly compressed file stored on the client.
You can also share PowerPivot workbooks by publishing them to a SharePoint 2010 farm with the help of Excel services and SQL Server PowerPivot for SharePoint. If you do this, you can view such PowerPivot workbooks from within a SharePoint library.