Power Pivot Add-in
Microsoft Power Pivot for Excelis an add-in that you can use to perform powerful data analysis in Microsoft Excel 2010, bringing self-service business intelligence to your desktop.
"PowerPivot will bring a lot more freedom to our information workers because they will have powerful, easy-to-use data analysis tools right on their PCs…without having to come to the IT department for help..."
Ayad Shammout, Lead Technical Database Administrator, CareGroup Healthcare System
In this article
Introduction to Power Pivot for Excel
Using Power Pivot for Excel to give your data meaning
By using Power Pivot for Excel, you can transform enormous quantities of data with incredible speed into meaningful information to get the answers you need in seconds.
-
Take advantage of familiar Excel tools and features
-
Process massive amounts of data in seconds
-
Load even the largest data sets from virtually any source including databases, data feeds, Reporting Services, and text files
-
Use powerful new analytical capabilities, such as Data Analysis Expressions (DAX)
For more information, see:
Learn About Power Pivot Capabilities
Take a Tour of the Power Pivot UI
Watch Videos About Power Pivot Tasks
Top features of Power Pivot for Excel
-
Import millions of rows of data from multiple data sources With P Power Pivot for Excel, you can import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions—
all without requiring IT assistance.
For more information, see Create Your First Power Pivot Workbook.
-
Enjoy fast calculations and analysis Process millions of rows in about the same time as thousands, and make the most of multi-core processors and gigabytes of memory for fastest processing of calculations. Overcomes existing limitations for massive data analysis on the desktop with efficient compression algorithms to load even the biggest data sets into memory.
For more information, see Creating Reports, Charts, and PivotTables.
-
Virtually Unlimited Support of Data Sources Provides the foundation to import and combine source data from any location for massive data analysis on the desktop, including relational databases, multidimensional sources, cloud services, data feeds, Excel files, text files, and data from the Web.
For more information, see Adding Data to Power Pivot.
-
Security and Management Power Pivot Management Dashboard enables IT administrators to monitor and manage your shared applications to ensure security, high availability, and performance.
For more information, see Excel Window: Power Pivot Features.
-
Data Analysis Expressions (DAX) DAX is a new formula language that extends the data manipulation capabilities of Excel to enable more sophisticated and complex grouping, calculation, and analysis. The syntax of DAX formulas is very similar to that of Excel formulas.
For more information, see:
Data Analysis Expressions (DAX) Language
Data Analysis Expressions (DAX) Survival Guide
Data Analysis Expressions (DAX) Function Reference
Using Power Pivot for Excel in a SharePoint 2010 Environment
Share your analysis, collaborate with colleagues, and increase the productivity of your team with Power Pivot for Excel 2010 in a SharePoint 2010 environment. After you create a Power Pivot workbook, you can share it with others in all of the normal ways that you share files. However, by publishing the file to a SharePoint server, you can gain many benefits. Your analysis renders in a browser window where other users can continue to analyze the data.
-
Work seamlessly via Web browser. Access your workbook applications directly in the browser without having to download the workbooks with all their data to every workstation. Enjoy the same performance and features as the Excel client.
-
Collaborate on analytics solutions. Turn your workbooks into shared applications accessible virtually anytime and from any location. Benefit from all the features that make SharePoint so effective, such as role-based security, workflows, versioning, and automatic data refreshing, and even reuse your shared workbook applications as data sources in new analysis.
For more information, see:
Power Pivot Overview for IT Administrators (If you are an IT administrator and you want to learn about how Power Pivot for Excel and Power Pivot for SharePoint can be used in your organization)
Download the Power Pivot add-in
To download the Power Pivot add-in, click any of the following links:
For detailed information about the Power Pivot add-in and how to use it, see:
