Excel® 2016 Pivot Table Data Crunching

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

9. Working with and Analyzing OLAP Data

In This Chapter

Introduction to OLAP

Connecting to an OLAP Cube

Understanding the Structure of an OLAP Cube

Understanding the Limitations of OLAP Pivot Tables

Creating an Offline Cube

Breaking Out of the Pivot Table Mold with Cube Functions

Adding Calculations to 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 ...

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