Skip to content
BI & Analytics

OLAP Online Analytical Processing

A processing approach optimised for multi-dimensional analytical queries, as opposed to OLTP.

Full definition

OLAP (Online Analytical Processing) is a data-processing approach optimised for complex, multi-dimensional analytical queries — 'what is the margin by customer, by product, by month, compared with the same period last year'. The opposite is OLTP (Online Transaction Processing), optimised for fast individual operations ('record this sale').

OLAP systems organise data into multi-dimensional cubes (time, product, geography, customer — each a dimension) with pre-calculated aggregations. Queries that in OLTP would take minutes or hours respond in seconds. The price is additional storage and the need for a periodic refresh when the source data changes.

Modern OLAP engines (including Qlik Sense behind MyBusiness-ITV) implement this paradigm without requiring rigorous pre-definition of cubes — the user explores dimensions freely, and the engine optimises queries on the fly. Qlik's associative model is especially powerful for OLAP analysis in cases where the relationships between dimensions are not fixed, such as in retail with multi-channel customers.

Talk to a specialist

Let's talk.
We'll come back within 24h with next steps.

No complicated forms. One email or call, a team that knows your sector, and a concrete path forward — whether MULTI, MAXIRETAIL, KORA, PPLPORTAL or infrastructure.

Talk to a specialist

Book a demo

Leave your details and we'll get back to you within one business day with next steps.