dbt

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.

Trusted by the best in data

Hubspot
jetBlue
BHP
Nasdaq
Vestas
Domain

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

Read the blog

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

Read the blog

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.

Watch the session

Start building with dbt Cloud

Streamline your data transformation process, reduce manual errors, and increase productivity with dbt Cloud. Sign up today and take your data transformation workflow to the next level.

Promote collaboration
Enhance data accuracy
Increase productivity

Great data professionals never work alone

Every industry leader understands one thing: you need the right network to grow. The dbt Community connects you with 70,000+ data professionals—people who share your challenges, insights, and ambitions.

If you’re looking for trusted advice, expert discussions, and real career growth, this is the place for you.

Solve your toughest challenges

Join today and get real-world advice from experienced pros.

Expand your network

Foster connections with meetups, local groups, and like-minded peers.

Advance your career

The dbt community is full of learning opportunities and shared job postings.