CHAPTER 9. Using cube formulas with the Data Model or OLAP data

In this chapter, you will:

There is a great technique with pivot tables where you convert the pivot table to a series of cube formulas. Originally, this technique was only relevant for someone who had SQL Service Analysis Services installed. But today, one click of Add This Data To The Data Model moves your data set to the Power Pivot engine, and Power Pivot stores data in an OLAP engine. Thus, you can use cube formulas simply by moving ...

Get Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) 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.