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 O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.