Skip to content
~/reflective_data

analytics-dictionary / term / transformation & metrics

Data mart

A data mart is a focused subset of a warehouse built for one team or subject, like marketing or finance.

Written by Reflective Data experts · updated Oct 5, 2026

Marts present only the tables a team needs, in terms they understand. They reduce confusion and make dashboards faster and easier to build.

In dbt projects, the final layer of models is usually called the marts layer.

related

Data modelingdbtStar schema

// how we can help

We build tested data models and semantic layers, or host them for you. Data build and semantic layers → · Hosted dbt on the platform

more in transformation & metrics

staging-layer.md

Staging layer

The staging layer holds lightly cleaned copies of source tables, one per source table, as the…
dimension.md

Dimension

A dimension is an attribute used to slice or group metrics, such as country, device or…
slowly-changing-dimension.md

Slowly changing dimension (SCD)

A slowly changing dimension is a descriptive attribute, like a customer segment, whose value changes over…
sqlmesh.md

SQLMesh

SQLMesh is a data transformation framework with virtual environments and strong change management.
dbt-test.md

dbt test

A dbt test is an automated check that a model meets expectations, such as unique, not…
dbt-macro.md

dbt macro

A dbt macro is a reusable piece of SQL logic written with Jinja templating.

← full analytics dictionary