Overview
Online Analytical Processing (OLAP) is a technology that performs multi-dimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.
Key Operations
- Roll-up: Aggregating data.
- Drill-down: Navigating from less detailed to more detailed data.
- Slice and Dice: Selecting specific sub-sets of data.
- Pivot: Rotating the data axes.