Microsoft PowerPivot for Microsoft Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the software users already know and love -- Microsoft Excel. You can transform mass quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. You can process large data sets 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, and follow relationships between tables as in a database and define sophisticated calculations using familiar and intuitive expressions.
