Ask and analyze · Analysis
Which BI tools' AI can compare what-if scenarios?
0 of 15 tools do, according to their public docs, and 2 partly.
Partly: Databricks, Sigma.
The question we asked: Can the AI calculate and compare what-if scenarios, each with its changed assumptions stated?
Grading standard
A user can define more than one what-if scenario with the AI, the changed assumptions of each scenario are stated explicitly, and the AI calculates results for each that can be compared side by side. A single what-if answer, or scenarios without stated assumptions or calculated results, is partly.
Databricks
Partlypreview
Quoted from Databricks’s docsRun advanced analyses, such as statistical analysis, forecasting, and what-if scenarios.
Source: docs.databricks.com/aws/en/genie-one/code-execution · checked Oct 26, 2026 · quoted by Gemini
Snowflake
Omni
No
Quoted from Omni’s docsDemo of an Anaplan-style scenario planning app built in Omni using Blobby.
Source: docs.omni.co/demos/2026/20260807 · checked Oct 26, 2026 · quoted by GPT
Hex
Sigma
Partly
Quoted from Sigma’s docs Perform scenario analysis for strategic planning: An agent can analyze possible scenarios that could affect the product supply chain by generating what-if scenarios based on user inputs and data, running scenarios using external models defined in Python code or stored procedures. When performing scenario analysis, the agent can state assumptions and uncertainty, and evaluate the output of a possible scenario compared with real outcomes provided in an input table.
Source: help.sigmacomputing.com/docs/sigma-agents · checked Oct 26, 2026 · quoted by GPT
BigQuery
Looker
Tableau
Power BI
Metabase
Alteryx
MotherDuck
Mode
Redshift
Streamlit