Microsoft PowerPivot 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.
"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 PowerPivot for Excel
Using PowerPivot for Excel to give your data meaning
By using PowerPivot 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 PowerPivot Capabilities
Take a Tour of the PowerPivot UI
Watch Videos About PowerPivot Tasks
Top of Page
Top features of PowerPivot for Excel
- Import millions of rows of data from multiple data sources With PowerPivot 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 PowerPivot 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 PowerPivot.
- Security and Management PowerPivot 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: PowerPivot 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
Using PowerPivot for Excel in a SharePoint 2010 Environment
Share your analysis, collaborate with colleagues, and increase the productivity of your team with PowerPivot for Excel 2010 in a SharePoint 2010 environment. After you create a PowerPivot 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 PowerPivot Workbooks
PowerPivot Overview for IT Administrators (If you are an IT administrator and you want to learn about how PowerPivot for Excel and PowerPivot for SharePoint can be used in your organization)
Top of Page
Download the PowerPivot add-in
To download the PowerPivot add-in, click any of the following links:
For detailed information about the Power Pivot add-in and how to use it, see:
PowerPivot for Excel
PowerPivot.com
PowerPivot team blog
PowerPivot for Excel Online Help
PowerPivot Sample Data
Top of Page
