Model & metrics

Data models

A model turns one or more tables into a clean set of measures and dimensions. Start simple with a single table; later, use Data Models in the app to join tables, pick columns and shape the model visually.

Defining a metric

A metric is a governed business measure. The simplest metric is an aggregation over a column:

• Count — number of rows (e.g. Orders).
• Sum — total of a numeric column (e.g. Total revenue over amount).
• Average — mean of a column (e.g. Average order value).

Each metric has a format (number, currency or percentage) and an optional business definition — the plain-language meaning that AI agents use to apply it correctly.

Dimensions & filters

Break a metric down by dimensions (country, month, product…) and narrow it with filters (e.g. country = ES). The same metric answers many questions without rewriting SQL.

Governance

Because every consumer queries the same definition, your numbers stay consistent across agents, APIs and BI tools — one source of truth.