📊Semantic 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
Common mistake
Key takeaways
- 1Define once. Each number has one rule.
- 2Many tools. Dashboards, sheets and assistants.
- 3Writes the SQL. Turns requests into queries.