PowerPivot is a free "Business Intelligence" add-in from Microsoft for Excel 2010 or 2013, for the analysis of data, especially from Microsoft SQL Server. It is available in a 32-bit version for 32-bit Office (the default), and a 64-bit version for 64-bit Office 2010 . Here is Microsoft's description:
Microsoft PowerPivot for Microsoft Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the software users already know and love — Microsoft Excel. You can transform mass quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. You can:
- Process large data sets (often millions of rows) with about the same performance as processing a few hundred rows by leveraging the PowerPivot in-memory engine and its efficient compression algorithms
- Use PowerPivot to directly access trusted premium and public domain data from DataMarket section of Windows Azure Marketplace
- Integrate data from a multitude of sources, including corporate databases, spreadsheets, reports, text files, and Internet data feeds
- Go beyond standard Excel expressions and use PowerPivot’s Data Analysis Expressions (DAX) language to perform powerful data manipulations. Follow relationships between tables as in a database and define sophisticated calculations using familiar and intuitive expressions
- Interactively explore, analyze, and create reports without depending on expert knowledge and specialty training by using native Excel 2010 functionality such as PivotTables, slicers, and other familiar analysis features.
A summary of the specifics of the product.
- Microsoft PowerPivot for Excel
- PowerPivot home page , with links to many videos and tutorials
- PowerPivot for Excel Online Help
PowerPivot requires Microsoft Office 2010 or 2013already be installed, and the bitness of PowerPivot must match the bitness of the Office version installed. This latest version also requires the free Microsoft .NET Framework 4.0 or later, and installs the Visual Studio 2010 Tools for Office Runtime (vstor) if they are needed. Here are specific installation instructions and requirements.
From the Microsoft PowerPivot license statement: "You may install and use any number of copies of the software on your devices for your use solely with Microsoft Office Excel 2010, Microsoft SharePoint Server 2010, and Microsoft Fast Search Server 2010." Office 2013 is a valid alternative.
Same as for college-owned computers: freely downloadable and installable
Lab and Classroom Availability
PowerPivot will generally not be available in labs and classrooms. It can be made available in the ITS Training Room.
Labs and Classrooms
To request this software be installed on a refreshing lab/classroom contact xxx
College Owned Equipment
Look in the KBOX user portal for "Install Microsoft SQL Server 2012 PowerPivot for Excel 32-bit". The 64-bit version, which requires 64-bit Office 2010 or 2013, is made available on request.
There is no protected information for ITS instructions.
Using the PowerPivot home page link listed above, follow its written or video instructions to the Microsoft Downloads site to download and install PowerPivot.
Who To Call
The EIS group in ITS is recommending PowerPivot for various data mining projects, and so many be the best reference for help.
S.Nissen originally authored the Windows information in this article, but after April 1, 2015, Rebecca Barkmeier will be responsible for the packaging of this application for Windows, so all questions should be directed to her.
Questions, Tips and Tricks
The PowerPivot home page whose link is given above is the best place to start, with videos on these topics, which are recommended in this order:
- Introduction to PowerPivot Relationships
- Import DataMarket Data into a PowerPivot Workbook
- PowerPivot for Excel Overview #1
- PowerPivot for Excel Overview #2
- Install PowerPivot for Excel
- Overview of Importing Data into PowerPivot
- Import SQL Server Data into a PowerPivot Workbook
- Add a Calculated Column to a PowerPivot Workbook
- Using Slicers with PowerPivot PivotCharts
- Using Slicers with PowerPivot PivotTables