/

Semantic Layer

Semantic Layer: Bringing Meaning—and Usability—to Enterprise Data

Intergalactic Data Labs

—

—

12 min read

Table of contents

Summarize

Updated October 2026

A semantic layer gives enterprise data a shared meaning. It records what business terms like revenue, customer, and churn mean, how each is calculated, and who may see it. Every dashboard, spreadsheet, and AI assistant then works from the same definitions, so teams stop arguing about whose number is right and start acting on the same facts.

Business word

What sales often means

What finance often means

What a semantic layer adds

Revenue

Signed bookings

Recognized revenue

Named versions with owners

Customer

Any account in the CRM

An account that paid

One agreed definition

Active

Logged in this month

Paid this month

A written rule and time window

Churn

Lost logos

Lost recurring revenue

Both, labeled and separate

Region

Sales territory

Billing country

A mapping between the two

What does a semantic layer actually do for a business?

A semantic layer turns business language into something software can calculate the same way every time. IBM describes it as enterprise data architecture that simplifies how business users work with complex storage systems (IBM). In practice, it is where your company writes down what its words mean.

Without one, each report holds its own private copy of the logic. A revenue figure in the board deck, the sales dashboard, and the finance spreadsheet may come from three formulas. A semantic layer moves those formulas into one shared place. dbt Labs frames the benefit as different business units working from the same metric definitions, whatever tool they use (dbt docs).

This article is for business readers who want to know why meaning matters. For the technical architecture, components, and an implementation checklist, see what is a semantic layer.

Why does the meaning of data matter more than the amount of data?

Data without agreed meaning produces confident answers that disagree. Most companies already have more data than they can use. What they lack is a shared understanding of what that data says.

The costs are real. Gartner estimates poor data quality costs organizations at least 12.9 million dollars a year on average (Gartner). Much of that cost is not missing data. It is data that means one thing to the team that produced it and something else to the team that used it.

The classic example comes from outside business. NASA lost the Mars Climate Orbiter in 1999 because one piece of ground software used English units while the spacecraft expected metric (NASA). Every number was correct in its own system. The failure was in the meaning between them.

Most business meaning gaps are smaller but more frequent. A pipeline review uses bookings while the forecast uses recognized revenue. A churn chart counts lost logos while the board expects lost dollars. Each gap costs a meeting, a decision, or some trust in the data team.

What counts as meaning in enterprise data?

Meaning is more than a label on a column. For a business term to mean the same thing everywhere, five things have to be written down and shared.

A definition people can read

Every important term needs one plain sentence that a new hire could understand. An active customer is an account with a paid invoice in the last 30 days. If the sentence takes a paragraph, the term probably hides two definitions.

A rule software can run

The written definition must match the formula that systems actually calculate. This is where glossaries usually fail. They describe the term well, but the dashboard still runs an older formula that nobody updated.

Relationships between things

Business terms connect to each other. A customer has subscriptions, subscriptions produce invoices, and invoices roll up to revenue. When those links are explicit, reports join data correctly instead of double counting.

Context and scope

Some definitions only hold in a certain context. Revenue in a regional report may exclude intercompany sales. Churn for self-serve plans may use a different window than churn for enterprise contracts. Meaning includes knowing which version applies where.

An owner and a history

Someone has to decide what a term means and approve changes. When finance changes the revenue rule, every report that uses it should know who changed it, when, and why. Without an owner, definitions drift quietly.

How does a semantic layer turn meaning into something software can use?

A semantic layer stores those five parts as shared, versioned definitions that tools query instead of raw tables. When someone asks for net revenue by region, the layer looks up the agreed formula, picks the right data, applies access rules, and returns one answer.

The person asking does not need to know which tables hold invoices. A sales leader can ask a question in business words and get the number finance would also accept. An analyst can build a new report without rebuilding the revenue formula. An AI assistant can answer a question without guessing which column means revenue.

The same definition also changes in one place. dbt notes that when a metric definition changes, it refreshes everywhere that metric is used (dbt docs). That is the difference between a shared meaning and a set of copies that slowly drift apart.

What changes for business teams when meaning is shared?

Shared meaning changes how meetings, reporting, and decisions work. The effect is less about new dashboards and more about fewer disputes over the ones you already have.

Before shared meaning

After shared meaning

Meetings start by reconciling numbers

Meetings start with the decision

Analysts rebuild formulas per report

Analysts reuse certified metrics

Each BI tool holds its own logic

Every tool reads one set of definitions

New hires learn terms by asking around

New hires read the definition and owner

AI tools guess from column names

AI tools query governed metrics

Self-service becomes realistic too. Business users stop filing tickets for simple questions because the definitions they need already exist and are trusted. The data team spends less time answering the same question in five forms and more time on new problems.

Why does AI make shared meaning urgent?

AI systems read schemas, not your business rules, so they amplify any gap in meaning. A person who knows that revenue excludes refunds will catch a wrong number. An AI assistant usually will not, and it will present the wrong number fluently.

The research is consistent. In a 2023 benchmark, GPT-4 answered 16 percent of enterprise questions correctly over a raw SQL database and 54 percent when the same data carried business context as a knowledge graph (arXiv). An April 2026 study gave Claude Opus 4.7, Claude Sonnet 4.6, and GPT-5.4 a short document defining business measures and rules. Accuracy rose by 17 to 23 points (arXiv).

The business stakes match the research. Gartner found 63 percent of organizations lack, or are unsure they have, the right data management practices for AI. It predicts organizations will abandon 60 percent of AI projects unsupported by AI-ready data through 2026 (Gartner).

Semantic layers now serve AI directly. AI tools such as Claude and ChatGPT can connect to the dbt Semantic Layer through the dbt MCP server and use governed metrics instead of raw tables (dbt docs). For how this compares with retrieval and graphs, see RAG vs knowledge graph vs semantic layer.

Who should own your company's meaning?

Your company should own its meaning, in formats it controls. Business definitions capture how your company actually works, which makes them one of its most valuable assets. If they live only inside one vendor's tool, they are hard to move, audit, or reuse.

Open formats make ownership practical. Apache Ossie, formerly the Open Semantic Interchange, entered the Apache Incubator in July 2026. It offers a vendor-neutral way to describe metrics, dimensions, relationships, and business rules, with more than 50 organizations involved (Apache Ossie). Definitions in a format like that can move between warehouses, BI tools, and agents.

Inside the company, ownership splits two ways. The business decides what a term means, and the data team encodes, tests, and serves it. Some companies also bring in a partner to get the first version built on the stack they already run. Galaxy is one such partner, using internal tooling it plans to open source more of, alongside its open-source data movement engine Filament by Galaxy.

How can you tell your company has a meaning problem?

You have a meaning problem when the same question gets different answers depending on who you ask. The signs usually show up in meetings before they show up in systems.

  • Dueling numbers. Sales and finance bring different revenue figures to the same review.

  • Reconciliation work. Analysts spend days explaining why two reports disagree.

  • Tribal knowledge. Only a few senior people know which table is safe to use.

  • Tool sprawl. Two or more BI tools each hold their own copy of key metrics.

  • AI surprises. An assistant returns a plausible number that nobody can trace or trust.

If you recognize two or more of these, writing down shared definitions will likely pay for itself in avoided rework. For a leader's view of timing, budget, and the first 90 days, see the semantic layer playbook for data leaders.

Where should a business leader start?

Start with the few terms that cause the most arguments, not with a technology choice. The hard part of a semantic layer is agreement, and agreement does not depend on which tool you pick.

  1. List the contested terms. Revenue, customer, active, churn, and pipeline are common starting points.

  2. Name an owner for each. One person per term approves the definition and any change.

  3. Write the definition and formula. Keep the plain sentence and the calculation side by side.

  4. Agree on a reference number. Pick one past period that every new report must match.

  5. Store it where you control it. A version-controlled repository in an open format keeps the meaning portable.

Only then pick where the layer will live. A semantic layer can sit inside your BI tool, your warehouse, or a standalone product. Compare the options in top semantic layer tools. To see how the layer relates to catalogs and metadata, read data catalog vs metadata layer vs semantic layer.

Frequently asked questions

What does semantic layer mean in plain business terms?

A semantic layer is the shared dictionary that sits between your company's data and everyone who asks questions of it. It records what words like revenue, customer, and churn mean, how to calculate them, and who may see them. Every report, spreadsheet, and AI assistant then reads from that same dictionary instead of inventing its own version.

Why do different teams get different numbers for the same metric?

Each team usually writes its own formula. Sales may count bookings, finance may count recognized revenue, and product may count paying accounts. None of them is wrong, but the numbers come from different definitions applied to the same data. A semantic layer names each version, assigns an owner, and makes clear which one appears in which report.

Is a semantic layer only useful for large enterprises?

No. The need shows up as soon as two teams or two tools report the same metric. A 50 person company with one warehouse and two BI tools can already see conflicting numbers. Smaller companies have an advantage because they have fewer definitions to reconcile, so writing them down early costs less than untangling them later.

How is a semantic layer different from a business glossary?

A glossary describes terms in prose for people to read. A semantic layer turns those definitions into logic that software runs, so a dashboard or AI agent actually uses the agreed formula. A glossary tells you what active customer should mean. A semantic layer makes every tool calculate active customer that way every time.

Why does AI need a semantic layer?

AI models read table and column names, not your business rules. In a 2023 benchmark, GPT-4 answered 16 percent of enterprise questions correctly over raw SQL and 54 percent when the data carried business context. An April 2026 study found a short document of business definitions raised accuracy by 17 to 23 points across three frontier models.

Who should own the definitions in a semantic layer?

The business owns the meaning and the data team owns the implementation. Finance should decide what revenue means, and the data team should encode and test it. Each metric needs one named owner who approves changes. Without that split, definitions either drift in engineering backlogs or stay vague in slide decks that no system can read.

Does a semantic layer replace our BI tools?

No. BI tools still draw charts and build dashboards. The semantic layer sits underneath them and supplies the definitions. When the layer is shared, you can use several BI tools, spreadsheets, and AI assistants at once without each one holding its own copy of the revenue formula. That is what keeps the numbers consistent.

How long before a business sees value from a semantic layer?

Value appears as soon as the first contested metrics are defined and reconciled. Most teams start with five to ten metrics that cause the most arguments, such as revenue, active customers, and churn. Once those match across reports, meetings stop spending time on whose number is right. Broader rollout takes longer because agreement, not software, is the slow part.

What is Apache Ossie?

Apache Ossie is an open specification for describing metrics, dimensions, relationships, and business rules in a vendor-neutral format. It was formerly called the Open Semantic Interchange and entered the Apache Incubator in July 2026 with more than 50 participating organizations. It matters because definitions written in an open format can move between tools without being rewritten.

What is the first step toward a semantic layer?

Pick the five metrics that cause the most disagreement and write down, for each one, a plain definition, the formula, the owner, and a reference number everyone accepts. Store those definitions somewhere your company controls, such as a version-controlled repository. That list becomes the seed of the semantic layer, whatever tool you choose later.

More articles

Stay up to date with what we’re building

Stay up to date with what we’re building

Stay up to date with what we’re building

Questions

Answered

FAQ

What does Galaxy do?

What is Filament?

What is enterprise context management?

What does working with Galaxy look like?

How do you handle security and compliance?

Why does Galaxy build in the open?

Own your knowledge stack

Own your knowledge stack

Copyright © 2026 Galaxy. All rights reserved.