Keep the spreadsheets, fix the chaos
No more manual data prep or inconsistent metrics — with the dbt Semantic Layer, your spreadsheets become trusted, error-free tools.
Data teams around the world love dbt
From simple to complex. Trusted metrics in any sheet.
Say goodbye to static tables. MDX queries and OLAP cubes. With real-time SQL dynamically generated at query time, the dbt Semantic Layer brings up-to-date, centralized data to Google Sheets and Excel, even for your most complex calculations. Move faster, collaborate more effectively, and make smarter decisions.
Easily query right in your sheet
With a built-in intuitive query builder integrated directly into Google Sheets and Microsoft Excel, users can retrieve the metrics they need, apply filters, and enable pivot tables or custom formulas with accurate, up-to-date data — no SQL required.
Trust your analysis with fresh, consistent metrics
Metrics like "Year-over-Year Revenue Growth" are standardized in dbt Semantic Layer, providing a single source of truth for metrics across spreadsheets, reducing errors and eliminating redundancy. Real-time or scheduled updates keep spreadsheets accurate and reliable, saving hours of manual work.
Fast insights, no matter the complexity
Features like common query caching on live data reduce latency and improve speed, allowing teams to quickly generate insights from even the most complex datasets. Spend less time managing data infrastructure and more time on analysis.
See the full picture — from raw data to insights
With the dbt Semantic Layer built on top of dbt models, you get end-to-end lineage with full DAG visibility, tracing every metric back to its source for total transparency, accuracy, and trust.
Learn more about dbt
Five use cases for the dbt Semantic Layer
From AI to BI to embedded apps, learn how to deliver trusted data to any endpoint
Semantic Layer: What it is and when to adopt it
The explosion of data sources can make it harder for employees to find, trust, and use data. Here's how a semantic layer can help
How Bilt Rewards delivered personalized analytics
See how Bilt Rewards used dbt's Semantic Layer to embed personalized insights and enable a more efficient, trusted analytics environment.
Start building with dbt
Streamline your data transformation process, reduce manual errors, and increase productivity with dbt. Sign up today and take your data transformation workflow to the next level.