"Microsoft PowerPivot enables powerful self-service ad-hoc
analysis of extremely large data sets all within the comfortable and easy to use Excel 2010 environment. You can perform server-less, in-depth, multidimensional, OLAP-style
and columnar analysis, as well as create your own column and table-focussed calculations. Acquiring data from
external sources, including the amazing ability to "parse" existing graphical and textual reports generated by other systems (such as SAP) has never been easier."
For more information, check out this course on Microsoft Virtual Academy: