Deliver and succeed with BI
Introducing PowerPivot from Microsoft
PowerPivot refers to a collection of applications and services that provide an end-to-end solution for creating and sharing business intelligence using Excel and SharePoint.
In an Excel environment, PowerPivot provides a familiar authoring and analytical experience on the workstation. In a SharePoint environment, PowerPivot adds server-side applications and features that support PowerPivot data access and management for workbooks that you publish to SharePoint. PowerPivot server components load the data, process queries, perform scheduled data refresh, and track server and workbook usage in the farm.
What is PowerPivot for Excel?
PowerPivot for Excel is an authoring tool that you use to create PowerPivot data in an Excel workbook. You use Excel data visualization objects such as PivotTables and PivotCharts to present the PowerPivot data that you embed or reference in an Excel workbook (.xlsx) file.
PowerPivot for Excel supports self-service business intelligence in the following ways.
- Current row-and-column limitations in Excel are removed so that you can import much more data.
- A data relationship layer lets you integrate data from different sources and work with all of the data holistically. You can enter data, copy data from other worksheets, or import data from corporate databases. You can build relationships among the data to analyze it as if it all originated from a single source.
- Create portable, reusable data. Data stays inside the workbook. You do not need manage external data connections. If you publish, move, copy, or share a workbook, all the data goes with it.
- PowerPivot data is fully and immediately available to the rest of the workbook. You can switch between Excel and PowerPivot windows to work on the data and its presentation in PivotTables or charts in an interactive fashion. Working on data or on its presentation are not separate tasks. You work on both together in the same Excel environment.
PowerPivot for Excel lets you import, filter, sort many millions of rows of data, far beyond the one million row limit in Excel. Sort and filter are extremely fast because the operations are performed by a local Analysis Services processor that runs inside Excel.
More importantly, PowerPivot for Excel lets you build relationships between data that is from completely different data sources by mapping columns that contain similar or identical data. When you build relationships in the data, you create something entirely new in Excel that can be used in PivotTables, PivotCharts, or any Excel data presentation object.
Who is PowerPivot for?
SQL Server PowerPivot client and server applications support self-service business intelligence that puts powerful analytics within your reach, enabling you to find better information and insight into the numbers that drive decisions, objectives, and initiatives throughout your organization.
Together, PowerPivot for Excel and PowerPivot for SharePoint provide new tools and infrastructure for:
- Excel users who know how to structure, analyze,and calculate multidimensional data in workbooks and PivotTables.
- SharePoint users who use team sites and document management features to store information and collaborate with colleagues.
- Database professionals and IT pros who want to delegate business data development tasks to those who need the data most, but want to retain sufficient controls so that data can be secured, monitored, reproduced, and archived.