Ask and analyze · Analysis

Which BI tools' AI can forecast, with its assumptions shown?

1 of 15 tools do, according to their public docs, and 7 partly.

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

The question we asked: Can the AI produce a forecast and expose the assumptions behind it?

Prompt your agent about thisClaudeChatGPT
Grading standard

The AI creates a forecast and exposes its horizon, inputs and assumptions so the result can be challenged. A forecast that does not expose its assumptions is partly. The AI itself must produce the forecast, so a classic forecasting feature it does not drive does not count, and a horizon with a confidence range but no stated inputs is partly.

Databricks

Partly
Quoted from Databricks’s docs"Generate a forecast of product demand for the next 6 months from the @inventory dataset, including confidence intervals."
Source: docs.databricks.com/aws/en/notebooks/ds-agent · checked Oct 26, 2026 · quoted by GPT
Claude partly (preview) · GPT partly · Gemini partly (preview)

Snowflake

Yespreview
Quoted from Snowflake’s docsCoCo infers everything else (task type, target column, evaluation metric, train/test split strategy) and asks you to confirm before proceeding.
Source: docs.snowflake.com/en/developer-guide/snowflake-ml/agentic-ml · checked Oct 26, 2026 · quoted by Claude
Claude yes (preview) · GPT yes (preview) · Gemini yes (preview)

Omni

Partly
Quoted from Omni’s docsThe Omni Agent will generate a new query if needed, analyze the query results, and generate a statistical forecast based on historical patterns in the data.
Source: docs.omni.co/ai/forecasting · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Hex

Partly
Quoted from Hex’s docsBuild me a 12-month ARR forecast.~5 credits
Source: learn.hex.tech/docs/administration/credits · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Sigma

Partly
Quoted from Sigma’s docsAn agent can run forecasting calculations based on the contents of an input table and informed by policy documents in an external system, then present results in a structured format for review and approval.
Source: help.sigmacomputing.com/docs/sigma-agents · checked Oct 26, 2026 · quoted by Gemini
Claude partly · GPT partly · Gemini partly

BigQuery

Partly
Quoted from BigQuery’s docs- "Using SQL, forecast the future traffic of my website for the next month based on bigquery-public-data.google_analytics_sample.ga_sessions_. Then, plot the historical and forecasted values."
Source: docs.cloud.google.com/bigquery/docs/colab-data-science-agent · checked Oct 26, 2026 · quoted by GPT
Claude partly · GPT partly · Gemini partly

Looker

Partly
Quoted from Looker’s docsIn contrast to standard SQL-powered BI experiences, Advanced Analytics supports a wide variety of data analytics—from basic computations and charting to more advanced tasks like time series forecasting.
Claude partly · GPT partly · Gemini no

Tableau

Partly
Quoted from Tableau’s docsShows the expected values for a metric for the remainder of the period, along with a forecast confidence range.
Claude partly · GPT partly · Gemini partly

Power BI

No
Quoted from Power BI’s docsThis question asks for forecasting, which isn't currently supported.
Source: learn.microsoft.com/en-us/power-bi/create-reports/copilot-ask-data-question · checked Oct 26, 2026 · quoted by Claude
Claude no · GPT no · Gemini no

Metabase

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

Alteryx

No
Quoted from Alteryx’s docs- Auto Insights does not do predictive modeling or forecasting–predictive modeling requires business acumen, knowledge, judgment, and overlays. However, if you have your own forecast scores, you can upload them into Auto Insights to trend and analyze.
Source: help.alteryx.com/aac/en/auto-insights/prepare-data.html · checked Oct 26, 2026 · quoted by GPT
Claude nothing found · GPT no · Gemini no

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