PowerPivot an Overview
PowerPivot is a collection of applications and services which is aimed at providing end-to-end solutions for creating and sharing business intelligence using Microsoft Excel. PowerPivot is integrated with an Excel environment and provides a familiar authoring and analytical experience on the client workstation.
PowerPivot for Excel
PowerPivot for Excel is an authoring tool that enables to create PowerPivot data in an Excel workbook. Excel data is used as visualization objects such as PivotTables and Pivot Charts to be presented as PowerPivot data that is embedded or referred to in an Excel workbook (.xlsx) file.
PowerPivot for Excel lets importing, filtering and sorting many millions of rows of data, far beyond the one million row limit in Excel. Sorting and filtering are done at tremendous speed aided by a local Analysis Services VertiPaq processor that runs inside Excel.
More significantly, PowerPivot for Excel can build relationships between data even from completely different data sources by mapping columns that contain similar or identical data. When the relationships are built, something entirely new is created in Excel that can be used later in PivotTables, Pivot Charts, or any Excel data presentation object.
Saved data gets stored inside the Excel workbook, highly compressed, creating a file that is manageable in size for any kind of client workstation.
The user has at the end of the process, at his disposal, a single workbook (.xlsx) file containing embedded data that is extracted and processed by an internal processor, but rendered exclusively through Excel. Compression and processing is done by the Analysis Services VertiPaq engine, while the query processing runs transparently in the background to provide the large-scale data support in Excel.
Who are PowerPivot potentially aimed at?
SQL Server PowerPivot client server applications, support self-service business intelligence that puts forth in use the most powerful analytics within your reach, enabling you to extract the best information and insights from any data source and structure that into numbers and figures that drive objectives, and initiatives and arrive at quick, smart and strategic decisions and accomplish set goals throughout the entire organization.
- PowerPivot for Excel provide these new tools and infrastructure for Excel users who are already used to structuring, analyzing, and calculating multidimensional data in workbooks and PivotTables.
- Database professionals and IT pros who want to delegate business data development tasks to those who are in need of the data most, but want to retain for themselves all the sufficient controls so that data can be secured, monitored, reproduced, and archived.