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.
(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:
Problems watching the video? Try our troubleshooting tips.