Microsoft PowerPivot for Excel 2010, formerly known as Project “Gemini”, is a data analysis add-in that delivers unmatched computational power directly within Excel 2010. PowerPivot gives users the power to create compelling self-service BI solutions. The PowerPivot team just released the November CTP (Community Technology Preview)…

image

PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application users already know and love: Microsoft Excel. It’s the user-friendly way to perform data analysis using familiar Excel features you already know, such as the Office Fluent user interface, PivotTable and, PivotChart views, and slicers. It’s the fast way to generate rich and interactive analysis tools, easily mistaken for IT solutions after weeks of effort. It’s the right way to achieve deeper business insight and shorter decision cycles.

In a nutshell:

  • Take advantage of familiar Excel tools and features
  • Process massive amounts of data in seconds
  • Load even the largest data sets from virtually any source (including Access, Excel, SQL Server…)
  • Use powerful new analytical capabilities, such as Data Analysis Expressions (DAX)
  • Make the most of multi-core processors and gigabytes of memory