analytics-dictionary / term / bi & reporting

Pivot table

A pivot table summarises data by letting you drag fields into rows, columns and values.

Written by Reflective Data experts · updated Oct 5, 2026

It is one of the most familiar tools for ad hoc analysis, available in spreadsheets and BI tools. It makes it quick to compare metrics across dimensions.

Behind every good pivot is a clean, well-defined table.

Ad hoc analysis Dimension Metric

// how we can help

We build BI and dashboards people actually use, on the tools you have or the right new one. BI & reporting services → · Explore on the platform

Self-service BI

Self-service BI lets business users explore data and build reports themselves, without waiting for analysts.

drill-down.md

Drill-down

Drill-down lets you move from a summary to the underlying detail, for example from country to…

metabase.md

Metabase

Metabase is an open-source business intelligence tool for simple, self-serve exploration of data.

jupyter-notebook.md

Jupyter Notebook

Jupyter Notebook is an open-source tool for writing and running code, such as Python, alongside text…

live-connection-vs-extract.md

Live connection vs extract

A live connection queries the warehouse every time a dashboard loads; an extract is a stored…

embedded-analytics.md

Embedded analytics

Embedded analytics puts charts and dashboards inside your own product or customer portal.

← full analytics dictionary