liveBook · Manning

Analytical processing

Also called OLAP

Interactive processing of data through complex queries, transformations, and aggregations to support analysis, reporting, or decision-making.

How 2 Manning books explain it

Cloud Observability in Action

Online analytical processing is a workload pattern involving complex queries over large volumes of historical data, typically with fewer writes than transactional systems.

How it is used
Supports interactive insight extraction from large historical datasets, especially observability data, with relatively few transactions.
How deep it goes
Explains row- and column-oriented layouts and workload fit, but does not develop deeper storage-engine internals.
Examples
Uses ClickHouse, OpenTelemetry logs, Docker Compose, and a time-bounded SQL query as working artifacts.
What you can do after
Operate/configure ClickHouse with an OpenTelemetry Collector pipeline and query recent logs for matching events.

Read how Cloud Observability in Action explains analytical processing →

DuckDB in Action

Analytical processing is computation over data to produce aggregates, transformations, and insights rather than to support operational transactions.

How it is used
Deploys computation for local analytics, preprocessing, reporting, forecasting, and aggregation across device, edge, cloud, and notebook workflows.
How deep it goes
Explains practical SQL workflows through ingestion prerequisites, basic statements, common table expressions, window functions, and OLAP queries.
Examples
Uses log files, sensor readings, and PVDAQ quarter-hour photovoltaic measurements to demonstrate reduction, forecasting, and reporting.
What you can do after
Apply it via DuckDB to prepare, filter, aggregate, query, and report on larger datasets across local and cloud workflows.

Read how DuckDB in Action explains analytical processing →

Also covered in

What to know first

Related concepts

Questions about analytical processing

What is analytical processing?

Interactive processing of data through complex queries, transformations, and aggregations to support analysis, reporting, or decision-making.

Which Manning books explain analytical processing?

Cloud Observability in Action and DuckDB in Action.

What should I know before learning analytical processing?

Manning books that teach analytical processing usually introduce dataset split, Parquet and transactional database system first.

What is the difference between analytical processing and analytical process?

Interactive processing of data through complex queries, transformations, and aggregations to support analysis, reporting, or decision-making. An analytical process is a structured examination of information to derive findings, conclusions, or decisions.

What is analytical processing also called?

Analytical processing is also called OLAP.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.