Microsoft SQL Server PowerPivot for Excel

PowerPivot gives users the power to create compelling self-service BI solutions, facilitates sharing and collaboration on user-generated BI solutions in a Microsoft SharePoint Server 2010 environment, and enables IT organizations to increase operational efficiencies through Microsoft SQL Server 2008 R2-based management tools.

You can get the answers you need, gain deeper insight into any business aspect, and compress your decision cycles.

Main features:
- Process large data sets (often millions of rows) with about the same performance as processing a few hundred rows by leveraging the PowerPivot in-memory engine and its efficient compression algorithms
- Use PowerPivot to directly access trusted premium and public domain data from DataMarket section of Windows Azure Marketplace
- Integrate data from a multitude of sources, including corporate databases, spreadsheets, reports, text files, and Internet data feeds
- Go beyond standard Excel expressions and use PowerPivot’s Data Analysis Expressions (DAX) language to perform powerful data manipulations. Follow relationships between tables as in a database and define sophisticated calculations using familiar and intuitive expressions
- Interactively explore, analyze, and create reports without depending on expert knowledge and specialty training by using native Excel 2010 functionality such as PivotTables, slicers, and other familiar analysis features