Glossary

Semantic layer

A layer that defines business metrics and dimensions once, centrally, so every tool and report uses the same numbers.

Also called: metrics layer, semantic model

A semantic layer sits between raw or modeled data and the tools people use to query it, where business concepts, metrics like revenue or churn, dimensions like region or product, and the relationships between them, are defined once in a central, governed way. Consuming tools query these definitions rather than re-deriving their own version of "revenue."

This differs from modeling done only inside a data warehouse: warehouse tables describe structure, while a semantic layer adds business meaning and consistent metric logic on top, and can serve multiple consumers, BI tools, spreadsheets, or a chat interface, from a single definition. It is closely related to work done in dbt and other data modeling tools, and some platforms now ship metric definitions directly alongside transformation code.

Semantic layers matter because they prevent the common failure mode where two dashboards report different numbers for what should be the same metric, because each was built with slightly different filters or joins. They are especially valuable for Self-service BI, where non-technical users query data directly and need trustworthy defaults. Pitfalls include defining metrics ambiguously, letting teams bypass the layer for one-off custom logic, and under-investing in change management when metric definitions evolve.

Last reviewed September 19, 2026

In the index now

Related terms

Data modeling The practice of organizing data into entities, relationships and schemas that make it accurate and efficient to query. dbt (data build tool) An open-source tool from dbt Labs that lets analytics teams write data transformations as version-controlled, tested SQL. Business intelligence (BI) The practice of turning company data into dashboards, reports and metrics that guide business decisions. Self-service BI BI tooling that lets business users build their own reports and explore data without waiting on IT or analytics teams. KPI (key performance indicator) A measurable value tracked over time to show whether a team or process is on track toward a goal. OLAP (online analytical processing) A category of technology optimized for fast, multi-dimensional aggregation and slicing of data for analysis.

Related tools

AtScale Universal semantic layer that models metrics once on top of a cloud data warehouse and exposes them to any BI tool without data movement. Baremetrics Subscription analytics and billing dashboard that turns Stripe and other payment-processor data into MRR, churn and forecasting metrics. ChartMogul Subscription analytics platform that unifies billing data from multiple systems into standardized MRR, churn and cohort metrics. Cube Open-source headless semantic layer that defines metrics once and serves them via SQL, REST, and GraphQL APIs to any BI tool or app. MetricFlow Open-source engine that compiles YAML metric definitions into SQL, and powers the dbt Semantic Layer. dbt Transforms data already in the warehouse with SQL SELECT statements, adding version control, testing, documentation and lineage.

Related guides

How to build a metrics layer Define each metric once, in code, so every tool that queries revenue or churn gets the same number — and govern changes to it. How to build a modern data stack Ingestion, warehouse, transformation, BI and activation — what a data stack needs at each company stage, and what to defer. How to choose a BI tool Pick a BI tool by who builds, who reads, where metrics are defined and what viewers cost, not by the chart gallery in the demo. How to choose a cloud data warehouse Start from your cloud, your pricing tolerance and your workload shape — general BI, high-concurrency apps, or enterprise mixed workloads — not the feature list. How to choose a data transformation tool Choosing between dbt and its rivals comes down to editor vs code, warehouse lock-in, rebuild cost and who is checking the SQL before it ships. How to choose a semantic layer Semantic layers differ by where they sit relative to the warehouse and who they serve — one BI tool, every BI tool, an app, or an AI agent.