Download the 2007 Office release

 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.

Play Demo 

(Or 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:

• Overview of Online Analytical Processing (OLAP)
• Connect to (import) an OLAP database
• Connection properties
• Create, edit, and manage connections to external data
• Select data in a PivotTable report
• Display or hide ScreenTips and properties in a PivotTable or PivotChart report
• Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

 Problems watching the video? Try our troubleshooting tips.