9. Working with and Analyzing OLAP Data
In This Chapter
Understanding the Structure of an OLAP Cube
Understanding the Limitations of OLAP Pivot Tables
Introduction to OLAP
Online analytical processing (OLAP) is a category of data warehousing that enables you to mine and analyze vast amounts of data with ease and efficiency. Unlike other types of databases, OLAP databases are designed specifically for reporting and data mining. In fact, there are several key differences between standard transactional databases, such as Access and SQL Server, and OLAP databases.
Records within ...
Get Excel® 2016 Pivot Table Data Crunching now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
