AEO Primer · 4 min read · May 2026
What is a Semantic Model? The Layer Between Data and BI, Defined
By Thinklytics Partners, Practitioner Notes
A semantic model is the layer between raw data and BI consumers that defines tables, relationships, measures, and business-friendly names so analytical queries produce consistent answers regardless of who asks.
Topics covered
- semantic model
- Power BI semantic model
- LookML
- dbt semantic layer
- cube
- tabular model
- metrics layer
Frequently asked questions
What is a semantic model in one sentence?
A semantic model is the layer between raw data tables and BI consumers (dashboards, reports, ad-hoc analysis, AI assistants) that defines tables, relationships, measures, calculated columns, and business-friendly names so analytical queries produce consistent answers regardless of who asks or which tool they use.
What does a semantic model contain?
Four things. Tables and their relationships (star schema, snowflake schema, or denormalized). Measures (the calculated KPIs: revenue, customer count, churn rate). Calculated columns and dimensions. Business-friendly names and descriptions (the 'semantic' layer). Optionally: row-level security rules, calculation groups, and time intelligence helpers.
Is a semantic model the same as a data model?
Closely related but not identical. A data model can refer to the physical schema (how tables are stored in the warehouse). A semantic model is specifically the analytical layer on top, optimized for query ergonomics and consistent metric definitions.
What tools have a semantic model layer?
Power BI (the tabular model, originally from SQL Server Analysis Services). Looker (LookML). Tableau (data sources with calculated fields and relationships). dbt Cloud (the Semantic Layer, also known as MetricFlow). Cube.dev. AtScale. Most modern BI tools have a semantic model layer in some form.
Why does the semantic model matter?
Three reasons. Consistency: the same metric definition produces the same number across every dashboard and analyst. Reusability: a measure defined once is available everywhere. AI grounding: Copilots and Q&A agents that ground against the semantic model produce reliable answers; those that don't, hallucinate.
What is the headless BI or universal semantic layer pattern?
The pattern where the semantic model is defined once (often in dbt's Semantic Layer or Cube.dev) and consumed by multiple downstream BI tools, AI agents, and applications, rather than being locked inside a single BI vendor's stack. It is the 2025-2026 evolution of LookML's central-metric promise.
How is a semantic model versioned?
Modern semantic models live in code (LookML files, dbt YAML, TMDL for Power BI) under version control. Changes go through pull requests, CI checks, and deployment pipelines, similar to application code. Pre-2020 semantic models were typically click-driven in BI tools without code versioning.
How does Thinklytics work on semantic models?
Semantic model design is part of every BI engagement we run, with explicit attention to AI grounding readiness (so Copilot and Q&A surfaces produce reliable answers). See [Power BI semantic model design that scales](/insights/power-bi-semantic-model-design-that-scales-2026).