Microsoft PowerPivot

PowerPivot is a free Microsoft Excel tool that increases the capabilities of Excel's pre-existing pivot table tool by allowing users to import data from multiple sources.  

PowerPivot allows the user to enter millions of rows of data from multiple sources into a single Excel workbook and create relationships between heterogeneous data. It also integrates with SharePoint, enabling users to share data models and analysis on SharePoint. Data added to the Microsoft PowerPivot spreadsheet is stored in the workbook, regardless of its origin, so users do not have to manage external data connections. PowerPivot supports SQL Azure natively.

PowerPivot also offers a new analytical capability called Data Analysis Expressions (DAX) that allows users to perform more advanced calculations for business intelligence (BI) and busines analytics (BA).

As of this writing, PowerPivot works for all versions of Microsoft Office 2010, but is only available for certain versions of Microsoft Office 2013.

Contributor(s): Jessica Sirkin
This was last updated in February 2014
Posted by: Margaret Rouse
View the next item in this Essential Guide: SQL Server 2012 or view the full guide: Maximizing the benefits of Excel add-ins: PowerPivot and Power View

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Research More Tech Terms

  • Search thousands of tech definitions
  • Browse tech definitions
    Browse Alphabetically:

Powered by

File Extensions and File Formats

File Extension and File Formats List:

Powered by