|Self-Service BI with PowerPivot for Excel 2010|
|Written by Thiago Zavaschi|
|Saturday, 23 January 2010 00:47|
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?”
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- List of suggested datasets to test PowerPivot
- Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
- Learning PowerPivot and DAX
- DAX cheat sheet
- Using Power Pivot and Power View for Profit Analysis