Meaning of OLAP (Online Analytical Processing)

Simple definition

OLAP allows fast, multidimensional analysis of large datasets, often in cubes.

Used in BI dashboards and reporting for slicing and dicing data.

A retailer compares sales by region, time, and product category in an OLAP cube.

For repeated, multidimensional queries with high performance needs.

Slice, dice, drill-down, roll-up, and pivot.

They require preprocessing and may struggle with unstructured data.

L’article Harriet Oughton | From music teacher to Rails World Conference MC est apparu en...

Discover what it’s really like to join a Data Analytics bootcamp through alumni stories and...

Three leading experts walk into a room in Tokyo to talk about keeping AI safe....

Become a data master

Free Data Courses