Demo: Explore Adventure Works in Excel by using an OLAP PivotTable report

 Note   The following demo assumes you have a basic understanding of PivotTable reports in Excel 2007. For more information, see Demo: Analyze product sales with a PivotTable report.

Excel 2007 OLAP PivotTable report Play Demo Demo button

(Or Download arrow download the demo.)

(You may experience a delay while the demo is loading.)

This demo uses the fictitious company Adventure Works to show how you can use an OLAP PivotTable report to query large amounts of data in a cross-tabular way with good performance. OLAP, or Online Analytical Processing, is a technology used to organize large business databases into cubes to support business intelligence.

Related Help articles:

Assistance Problems watching the video? Try our troubleshooting tips.

Applies to:
Excel 2007