Power Pivot - Excel

A free Microsoft Excel add-in which significantly increases the capability of Excel.

Providing a smart and effective tool for data analysis and business intelligence.

Its benefits include:

Work Faster

• Ability to handle up to 100 million rows of data
• Faster information processing via in-memory engine and compression algorithms

Integrate data from multiple sources

• Data can be fed from several sources and analysis performed across multiple tables
• Ability to create joins between tables, cleaner and faster than lookups
• Functionality to pivot over multiple data tables at once

Increased functionality

• DAX  Data Analysis Expressions Language
• A new formula engine with additional functions, for example the Distinct count calculation

>MS Business Intelligence Tool – PowerPivot - http://www.microsoft.com/en-us/bi/powerpivot.aspx