Mars Dauer

BI copilots can answer questions about what's on screen: filters, dimensions, chart values. But ask "why is this number wrong?" or "where does this column come from?" and they hit a wall. They can't see past the dashboard. Integral Ad Science built an AI agent that goes deeper. Directly within the BI layer, it connects to your dbt project through MCP and validates findings in Databricks SQL (Unity Catalog) via the Databricks SQL MCP server. The agent extracts context from the report, reads compiled SQL, traces column-level lineage from mart to source, explains the business logic in each transformation, and confirms what the data shows in the warehouse. For analysts, it eliminates hours spent following DAGs and reading model code. For business users, a persona switch delivers clear, natural language answers. Mars Dauer will show how MCP makes this possible across dbt and Databricks and share an end-to-end investigation, from BI report to root cause to Jira ticket, all in one chat.