dbt

Consistent metrics for business results

Learn the different ways you can make impact automatic with the dbt Semantic Layer, or get more specifics in our blog post on use cases.

Trusted by the best in data

Thermo Fisher Scientific
Nasdaq
jetBlue
Hubspot
Anheuser-Busch Group
Conde Nast
TaskRabbit
CHG Healthcare
Virgin Media

Write it once, use it anywhere, and trust the results with dbt Semantic Layer

Centralize your metric logic alongside your data models and deliver governed, consistent insights to any BI tool, API, or large language model (LLM).

For business stakeholders

Never second-guess KPI dashboards. Enable self-serve via AI chatbots and no-code interfaces.

For data scientists

Train your ML models and conduct exploratory analytics using governed metrics.

For customers

Embed personalized and meaningful metrics across user experiences.

Reporting & BI

Get accurate data to your boss

Report the right numbers to the board, every time. Build your KPI scorecards from centrally-defined metrics and trust that the data is accurate. Easily explore contextual data like lineage, definitions, and joins so you can always be 100% confident in the metrics you share.

Read more on how we used dbt Semantic Layer to meet users where they are, with trusted data.

Embedded analytics

Power delightful in-app experiences

Include meaningful metrics in your customer experiences. Calculate complex metrics with the dbt Semantic Layer and deliver them as up-to-date, embedded visualizations in your app.

Read how Inventa uses the dbt Semantic Layer to build trust and confidence in their data.

AI & LLM

Turn questions into answers

Query data without a PhD in data engineering. Ask a question like, “What was revenue in Germany last month?” to your preferred LLM and get the right answer lightning fast.

Better yet: ask any permutation of that question (by product, channel, or anything you want) without any additional engineering work—all powered by the centralized, standard metrics in your warehouse.

Self-serve analytics

Don’t gatekeep your data

Allow non-technical users to tap into your metrics. They’ll be empowered to confidently answer their own questions based on the governed semantic building blocks you’ve created.

They get the insights they need, and you can ensure the quality and governance posture of that data without ever fielding an ad hoc request. It’s a win/win.

Exploratory analytics

Surface new insights

Supercharge your data teams with a governed sandbox to explore metrics and unearth new insights. Join data defined in the semantic layer—or anywhere in your warehouse—and sync metrics into your preferred notebook as you collaborate on your next big idea.

  • "When you put everything on dbt, you ensure everyone is seeing the same number. You don’t get that message saying, ‘oh, my director got this GMV number and I’m getting this different one.’"

    Gabriel Marinho Analytics Engineer, Inventa
  • "The dbt Semantic Layer gives our data teams a scalable way to provide accurate, governed data that can be accessed in a variety of ways—an API call, a low-code query builder in a spreadsheet, or automatically embedded in a personalized in-app experience. "

    Hans NelsenChief Data Officer, Brightside Health

    Want more?

    Check out the resources below to learn more about using the dbt Semantic Layer.

    Five use cases for the dbt Semantic Layer

    Learn to use your organizational metrics to build a lasting competitive advantage with dbt Semantic Layer.

    Read the blog

    Join a semantic layer workshop

    Join us for a two-hour course designed to give you a clear understanding of the dbt Semantic Layer.

    Learn more

    Got a question? We’ve got answers.

    Dive deep into the dbt Semantic Layer FAQs and get your questions answered right away.

    Read the FAQs