O'Reilly logo

Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Building a PivotTable from an OLAP Cube

Understanding OLAP

So far in this book you have worked with relatively small data sources such as the Northwind sample database that comes with Microsoft Access. In the business world, however, it is common to work with data sources that are much larger: from hundreds of thousands of records to millions, even billions of records. You cannot place such a huge data source on a worksheet, and even trying to manipulate all that data via a regular external data source is extremely time consuming and resource intensive. Fortunately, such huge data sources often reside on special servers that use a technology called online analytical processing, or OLAP. OLAP enables you to retrieve and summarize immense ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required