AI engineering glossary · Data engineering

What is OLAP?

OLAP (also called Online analytical processing): Online analytical processing: workloads that run complex queries summarising large volumes of historical data, such as totals by region and month. Systems for it favour read speed and columnar layouts over frequent single-row updates.

Level: beginnerTopic: Data engineering

OLAP: an example

An analyst asks for total revenue by state and quarter across three years of orders.

Related terms

More Data engineering terms

Where you learn it

OLAP is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.

Before you go

Take the cheat sheet with you

One free PDF: the key AI-engineering terms, formulas and Python idioms. No spam; unsubscribe any time.