PowerPivot Nuggets

I have been working with PowerPivot for about two years now. I still think it is one of the most fascinating pieces of software that Microsoft has ever released. PowerPivot will dramatically change the way we do business intelligence projects in the coming years.

Earlier this month Microsoft released SQL Server Denali CTP3 to the public. Along with the CTP came a new (CTP) version of PowerPivot. This public release is great news because we can finally blog and talk about the cool stuff coming to the next release of PowerPivot.

So what am I announcing today? PowerPivot Nuggets. In the coming weeks I will blog almost daily about one new feature in PowerPivot Denali. No long in-depth articles, but just small nuggets highlighting one new feature.

• PowerPivot Nuggets - Part 1 - The Diagram View
• PowerPivot Nuggets - Part 2 - Hierarchies
• PowerPivot Nuggets - Part 3 - Drill-through
• PowerPivot Nuggets - Part 4 - Perspectives
• PowerPivot Nuggets - Part 5 - Mark As Date Table
• PowerPivot Nuggets - Part 6 - Sort By Column
• PowerPivot Nuggets - Part 7 - Multiple Relationships
• PowerPivot Nuggets - Part 8 - Parent Child Relatio...
• PowerPivot Nuggets - Part 9 - Descriptions
• PowerPivot Nuggets - Part 10 - KPIs
• PowerPivot Nuggets - Part 11 - Add values to rows and columns...
• PowerPivot Nuggets - Part 12 - Measure grid...
• PowerPivot Nuggets - Part 13 - Save PowerPivot workbook as Analysis Services Cube
• PowerPivot Nuggets - Part 14 - Generate a list with all your DAX calculations
• PowerPivot Nuggets - Part 15 - What If Analysis with Slicers
• PowerPivot Nuggets - Part 16 - Berekening Voordeel Alle Aard (VAA) Bedrijfswagens
• PowerPivot Nuggets - Part 17 - Visualize KPI Trends
• PowerPivot Nuggets - Part 18 - SWITCH() and multiple expressions
• PowerPivot Nuggets - Part 19 - Automate PowerPivot Refresh with Excel 2013
• PowerPivot Nuggets - Part 20 - Create Time Dimension Office App