Analytics in Action

How to build a Powerpivot in Microsoft Excel 2010

The Powerpivot addin in Excel 2010 makes it easy to build reports with  incredibly  large volumes of  underlying data data. OLAP cube technology from SQL server  is now included within Excel 2010 with the Powerpivot addin. This means it now possible to slice and dice millions of rows of data with lightening speed. This represents a paradigm shift in how data can be manipulated and managed using Excel. This video  outlines how to import data into excel and build a Powerpivot in Excel 2010.


admin