Latest Post:

What is a semantic layer?

Definition

A semantic layer describes the business meaning of data: what an active customer is, how revenue is calculated, which tables relate to each other and what columns contain.

Some semantic layers define reusable calculations and relationships in code. Others provide descriptions and business context within an analytics tool. How consistently those definitions are applied depends on the implementation.

Why it matters

A shared definition can prevent two teams from using the same label for different calculations. Finance might include refunds in revenue while sales reports gross order value; both charts can look reasonable until someone tries to reconcile them. Recording the definitions and relationships makes those differences visible.

The detail to examine is how a tool uses that context. Descriptions can guide people and AI, while reusable calculation rules can apply a definition automatically. Those are different mechanisms, and understanding the distinction helps set expectations.

  • Give important metrics an explicit calculation and time basis.
  • Describe relationships, including whether one record can match several others.
  • Record exceptions such as test accounts, cancellations or currency conversion.

Keep those definitions reviewed as the underlying business and data change.