New features in PowerPivot for Excel with SQL Server "Denali"

In the below link we can find a brief overview of some new features that SQL Server Team have introduced with the CTP3:

• Diagram View
• User defined hierarchies
• Perspectives
• Support for Multiple Relationships
• Calculation Area
• Advanced Tab
• Reporting Properties
• New DAX Functions
• Sort by Other Column
• Add Values to Rows and Columns

What’s new in PowerPivot for Excel with SQL Server Code Name "Denali" CTP3

The video below give us a brief overview of 3 key features: Diagram View, user defined hierarchies and perspectives.