dbt Semantic Layer for Excel

The dbt Semantic Layer enables your data teams to define crucial business metrics in code, share insights about metric behavior, and ensure all downstream tools align with the single source of truth for metric logic and definition. With the dbt Semantic Layer for Excel add-in, your analysts and data consumers can pull accurate metrics directly from the source of truth in dbt, generating insights with confidence. This add-in features a custom menu for code-free query-building, allowing data consumers to populate Excel with data from the dbt Semantic Layer by selecting from their defined metrics and dimensions.

To use this add-in, you must have a dbt Cloud enterprise or teams account with the Semantic Layer enabled. You can create a free trial account, or talk to a dbt expert to get started.