liveBook · Manning

Analytical processing

As explained in DuckDB in Action

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

Analytical processing computes over data to produce aggregates, transformations, and insights rather than support operational transactions. It enables local preparation, filtering, and analysis without moving sensitive or bulky data elsewhere. section 1.5

Typical workflows include:

  • Reducing log, sensor, health, financial, or home-automation data near where it is stored. section 1.5
  • Running SQL through a CLI, Python client, Java JDBC driver, or other language interface. section 3.0
  • Building queries with common table expressions, window functions, filtering, and aggregation. section 3.0

Household photovoltaic analysis

Quarter-hour smart-meter readings from the PVDAQ dataset can support electricity-use planning, consumption forecasting, pricing, and photovoltaic-grid amortization reports without requiring a full time-series database or live dashboard. section 3.2

How DuckDB in Action covers it

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 it assumes
Assumes data ingestion and data-type knowledge, while introducing SQL query construction from table definition through advanced analysis.
What you can do after
Apply it via DuckDB to prepare, filter, aggregate, query, and report on larger datasets across local and cloud workflows.
How it connects
Connects analytical processing with SQL, OLAP, data ingestion, aggregation, window functions, cloud storage, and DataFrame libraries.
Cover of DuckDB in Action
liveBookmanning.com
Read DuckDB in Action on liveBook Get the book at manning.com

Also explained in

Compare how 2 books explain analytical processing →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of DuckDB in Action. The section links point to the parts of the book it draws on.