Power Pivot

Power Pivot

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

-----------------------------------------------------------------------------------------------------------------------------------------------------------

Distinct Count - Power Pivot - Excel

A function that calculates a distinct count / unique count

=COUNTROWS( DISTINCT( ‘Table Name’[Field Name] ) )

EDATE - Excel and PowerPivot

Calculates the date a number of months before/after a start date

Type:   =EDATE(date,6) 

Calculates the date 6 months from the start date. To calculate prior dates use -(number of months).
For example, could be used to calculate a maturity a certain number of months from a start date.