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.
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.
Last updated
