Online Analytic Processing

In OLAP cube data can be pre-calculated and pre-aggregated, making analysis faster.

Usually, data is organized in row and column format.

OLAP contains multi-dimensional data, with data from different data sources.

Src:https://www.holistics.io

There are 4 types of analytical operations in OLAP

Roll-up: Consolidation, aggregation. Data from different cities can be rolled up to the state/country level.

Drill-down: Opposite of roll-up.

If you have data by year, you can analyze monthly, weekly, and daily trends.

Slice-dice: Take one dimension of the data from the cube and create a sub-cube.

If data from various products / various quarters are available take one quarter alone and work with it.

Pivot: Rotating the data axes.

Basically swapping the x and y-axis of the data.