Power Pivot Add-in

Microsoft Power Pivot for Excel is an add-in that you can use to perform powerful data analysis in Microsoft Excel 2010, bringing self-service business intelligence to your desktop.

"Power Pivot 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 of Page Top of Page

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

Top of Page Top of Page

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:

Sharing Power Pivot Workbooks

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)

Top of Page Top of Page

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:

Power Pivot for Excel

Power Pivot.com

Power Pivot team blog

Power Pivot for Excel Online Help

Power Pivot Sample Data

Top of Page Top of Page

 
 
Maikakapit sa: