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 Down 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:


Help Button Problems watching the video? Try our troubleshooting tips.

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language