Self-Service BI with PowerPivot for Excel 2010
Today I will show to you what I think is one of the most exciting new feature of SQL Server 2008 R2: the PowerPivot – it is indeed an awesome “Power” to have in SQL Server 2008 R2.
PowerPivot for Excel 2010 (formerly known as ‘Project Gemini’) is the complete name of this new feature, and its grand promise is the advent of self-service Business Intelligence. In other words, it has powerful analysis capabilities, is very easy to use, enables you to very quickly and easily get exactly the data what you want to apply those analysis capabilities to.
“Ok Thiago, this name means that we have to use Excel 2010. Why?”