Ask and analyze · Analysis

Which BI tools' AI explains why a number changed?

3 of 15 tools do, according to their public docs, and 6 partly.

Yes: BigQuery, Tableau, Alteryx. Partly: Databricks, Snowflake, Omni, Hex, Sigma, Looker.

The question we asked: Can the AI identify what contributed to a change, with calculations a person can check?

Prompt your agent about thisClaudeChatGPT
Grading standard

yes: the built-in assistant breaks a change down into contributing segments or factors and shows the contribution of each, with the calculation a person can check, for example a table of segments with their share of the change. A key-driver function the assistant is documented to use counts; one only a user calls in SQL does not. Naming likely causes, or describing that a number rose or fell, without contributions is partly.

Databricks

Partlypreview
Quoted from Databricks’s docsGenie analyzes the selected change and returns an explanation with the top contributing factors.
Source: docs.databricks.com/aws/en/dashboards/genie-spaces · checked Oct 26, 2026 · quoted by Claude
Claude partly (preview) · GPT partly (preview) · Gemini partly

Snowflake

Partly
Quoted from Snowflake’s docsReach for Deep Research when you need to understand why something happened, when the answer likely spans multiple tables or domains, or when you want a citable report you can hand to stakeholders.
Source: docs.snowflake.com/en/user-guide/snowflake-cortex/snowflake-cowork · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Omni

Partly
Quoted from Omni’s docsPipeline and revenue narratives — "Write a short update on how we're tracking against this month's revenue target and which segments are driving the change"
Source: docs.omni.co/ai/routines · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Hex

Partly
Quoted from Hex’s docsI set the date input to last quarter, why is revenue down?
Source: learn.hex.tech/docs/explore-data/chat-with-app · checked Oct 26, 2026 · quoted by GPT
Claude partly · GPT partly · Gemini partly

Sigma

Partly
Quoted from Sigma’s docsExtract factual information from your data, identify the drivers behind a metric, detect anomalies and get guided next steps, segment your data into meaningful groups, or ask questions that generate charts you can explore in a workbook.
Source: help.sigmacomputing.com/docs/ask-natural-language-queries-with-assistant · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

BigQuery

Yes
Quoted from BigQuery’s docsConversational analytics supports the following AI and ML functions in response to chats with data agents and data sources, and in verified SQL queries that you create.
Source: docs.cloud.google.com/bigquery/docs/conversational-analytics · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Looker

Partlypreview
Quoted from Looker’s docsYou can also specify whether you want the workflow notification to include results from Gemini-powered Key driver analysis, which provides insight about why the change that triggered your workflow occurred.
Claude partly (preview) · GPT partly (preview) · Gemini yes (preview)

Tableau

Yes
Quoted from Tableau’s docsShows values for dimension members that changed the most in the same direction as the observed change in the metric.
Claude yes · GPT yes · Gemini yes

Power BI

No
Quoted from Power BI’s docsCopilot can't currently answer questions that require generating new insights, such as anomaly detection, forecasting, or finding key influencers.
Claude partly · GPT no · Gemini no

Metabase

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found

Alteryx

Yes
Quoted from Alteryx’s docsLet’s take a look at this example, where we see Loyalist customers had contributed to a 0.31 increase in the overall average price for that month (0.2 increase).
Claude partly · GPT yes · Gemini yes

MotherDuck

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found

Mode

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found

Redshift

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found

Streamlit

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found