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?
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
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
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
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
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
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
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.
Source: cloud.google.com/looker/docs/conversational-analytics-agentic-workflows-overview · checked Oct 26, 2026 · quoted by Claude
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.
Source: help.tableau.com/current/online/en-us/pulse_insights_platform_insight_types.htm · checked Oct 26, 2026 · quoted by GPT
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.
Source: learn.microsoft.com/en-us/power-bi/create-reports/copilot-ask-data-question · checked Oct 26, 2026 · quoted by GPT
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).
Source: help.alteryx.com/aac/en/auto-insights/find-insights/contributions-explained.html · checked Oct 26, 2026 · quoted by GPT
Metabase
MotherDuck
Mode
Redshift
Streamlit