Problem
The Databricks marketing analytics team started with one analyst, one marketing table fed by a 30-join query and about 100 Tableau dashboards. The same KPI showed different values on different dashboards, because each analyst re-implemented business concepts as SQL filters. A business-unit deep dive took about a week and 15 to 20 hand-built slides. AI pointed at the dashboards only repeated the numbers, since the data had no business context.
Example from the article: the same "Active Pipeline" showed as $42M (stage >= 2), $58M (stage >= 1) and $51M (custom filter) on three dashboards, and a stakeholder asked in Slack which was correct before a leadership quarterly business review (QBR).
Solution in brief
Rebuild the data foundation first: medallion layers with a golden contact table, an identity crosswalk and one engagement table. Define each KPI once as a Unity Catalog metric view, so every consumer calls MEASURE() instead of repeating filters. Then add a virtual context layer with agents that tag people and content.
Questions this case answers
- How to make one business metric return the same value in every dashboard and every AI agent when its definition is re-implemented as filters in many queries
- How to give an LLM agent the business meaning of a metric so it can explain a movement instead of repeating the number
- How to make one KPI show the same number on every dashboard and in every AI agent
- How to stop metric drift when business definitions are re-implemented as SQL filters in each dashboard
Tools and methods
- Medallion architecture — bronze, silver (engagement, contact, identity crosswalk), gold
- Unity Catalog metric views — one governed definition per measure, used via
MEASURE() - LLM persona classifier and look-alike model — persona for contacts without a usable title
- Vector search and contextual tagging — content and OKR context
- AI judges — monitor agent output quality
- Genie, Genie Code, Databricks Apps — natural-language access, reports, one dashboard app
Google or a one-time email code. No password.