Skip to content
BENIBIX Learn

Semantic Layer

Data📊 Analytics & BISemantic Layer

Also known as Metrics Layer, Metrics Store, Semantic Model, Universal Semantic Layer

One place that sets the rule for each number. Every tool gets the same answer.

Think of it like

It is like one word list that all the classes in a school use. A word means the same in every room.

Example

Revenue is set once as paid orders minus refunds. The dashboard, the sheet and the AI helper all show the same figure.

Why it matters

Without it, each tool and each analyst writes revenue their own way. The numbers drift apart, and trust goes.

Definition

A semantic layer sits between the warehouse and the tools that read it. It defines business numbers once, such as revenue or active users. It also names the fields people group by, such as country or month. Every tool that asks for revenue gets the same answer, worked out the same way. The layer turns each request into SQL.
The semantic layer is the middle box. Three tools ask for revenue, and all three get the same number.

Common mistake

Trying to define every number on day one. Start with the ten that people argue about most.

Key takeaways

  1. 1
    Define once. Each number has one rule.
  2. 2
    Many tools. Dashboards, sheets and assistants.
  3. 3
    Writes the SQL. Turns requests into queries.

Compare