Analytical processing
Interactive processing of data through complex queries, transformations, and aggregations to support analysis, reporting, or decision-making.
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.
Also covered in
What to know first
- dataset splitA dataset split is the division of a dataset into distinct subsets assigned different purposes, such as training, validation, or evaluation.
- ParquetApache Parquet is an open, column-oriented binary file format for storing and processing structured data with schema and metadata support.
Related concepts
- columnar storageused by · Columnar storage is a data layout that stores values grouped by column rather than by row.
- vertical partitioningused by · Vertical partitioning is a technique that divides data or computational structure into distinct portions based on columns, features, functions, or layers.
- energy consumptionuses · Energy consumption is the amount of energy used by a system or process over a period of operation; power consumption is the rate at which energy is used.
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.

