PowerPivot is not new to you, it's just an extension of what you already know Remember, its Excel with PowerPivot, built by Microsoft. It's not a brand new tool set, it just makes Excel more powerful.
The size of a data set is no longer an automatic disqualifier of Excel as a tool for analyzing and reporting on it. You truly can take your Excel abilities up to the industrial scale.
It reduces the time you spend applying spreadsheet logic to other data sets, and maintaining sets of workbooks that all do basically the same thing. With better data capacity and performance, its suddenly an option to put everything into one master file and then filter as needed to focus on specific corners of the business.
Professional grade formula’s in PivotsThe feature that lets you add formulas (calculated fields) to your pivots has never been improved, it has remained limited, with nowhere near the richness of the formulas you can write in the regular Excel grid.
However, with PowerPivot, the engine has been revised and retrofitted so that you can use Excel formula syntax against it.
It's as if the Excel team spent years improving the Pivot calculated fields feature, and then sprung it on us all at once!
Ian Littlejohn worked as a Management Consultant for 15 years and is passionate about teaching business people to analyze data and understand business data.