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
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.
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 blogJoin a semantic layer workshop
Join us for a two-hour course designed to give you a clear understanding of the dbt Semantic Layer.
Learn moreGot a question? We’ve got answers.
Dive deep into the dbt Semantic Layer FAQs and get your questions answered right away.
Read the FAQs