Ask and analyze · Analysis

Which BI tools' AI can clean and reshape data?

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

Yes: Databricks, Snowflake, Hex, Sigma, BigQuery, Tableau, Alteryx. Partly: Omni, Power BI, MotherDuck, Mode.

The question we asked: Can the AI clean or reshape data while leaving inspectable transformation logic?

Prompt your agent about thisClaudeChatGPT
Grading standard

The AI can clean or reshape data and leaves transformation steps, code or another inspectable artifact behind.

Databricks

Yes
Quoted from Databricks’s docsAuthoring a new pipeline: Genie Code can help with all steps of creating a new medallion architecture pipeline, from ingesting data, to standardizing and cleaning the data, to transforming and analyzing the data.
Source: docs.databricks.com/aws/en/ldp/de-agent · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Snowflake

Yes
Quoted from Snowflake’s docsUse CoCo to explore, clean, and transform raw data into ML-ready inputs.
Source: docs.snowflake.com/en/developer-guide/snowflake-ml/agentic-ml · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Omni

Partly
Quoted from Omni’s docsCreate new SQL tabs, or update the SQL on a SQL tab you're currently viewing. Not available through the API, MCP, or the Slack agent, or to topic-restricted users.
Source: docs.omni.co/ai/queries · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT yes · Gemini partly

Hex

Yes
Quoted from Hex’s docsThe agent is capable of creating Python cells, SQL cells, Markdown cells, Pivot cells, Input parameters, Single value cells, and Chart cells.
Source: learn.hex.tech/docs/explore-data/notebook-view/notebook-agent · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Sigma

Yes
Quoted from Sigma’s docsThe formula assistant evaluates your description of calculations, data references, manipulations, and other context, then suggests a formula to achieve the desired output.
Source: help.sigmacomputing.com/docs/use-ai-with-formulas · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini partly

BigQuery

Yes
Quoted from BigQuery’s docsThis document explains how to clean and transform your data within BigQuery data preparations using SQL code suggestions from Gemini.
Source: docs.cloud.google.com/bigquery/docs/data-prep-get-suggestions · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes (preview)

Looker

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

Tableau

Yes
Quoted from Tableau’s docsTableau Agent performs the steps for you, building out your flow and adding the changes to the Changes pane.
Source: help.tableau.com/current/prep/en-us/prep_einstein.htm · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Power BI

Partlypreview
Quoted from Power BI’s docsCreate, update, and manage tables, columns, measures, and relationships by using natural language
Source: learn.microsoft.com/en-us/power-bi/transform-model/copilot-web-modeling · checked Oct 26, 2026 · quoted by Claude
Claude partly (preview) · GPT nothing found · Gemini partly (preview)

Metabase

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

Alteryx

Yes
Quoted from Alteryx’s docsClean up the file I uploaded and remove rows with missing values.
Source: help.alteryx.com/aac/en/ask-alteryx/ask-alteryx-in-alteryx-one.html · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

MotherDuck

Partly
Quoted from MotherDuck’s docsWhen you ask for a data change, it writes the SQL for you to run.
Source: motherduck.com/docs/key-tasks/ai-and-motherduck/agent-chat · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT yes · Gemini partly

Mode

Partly
Quoted from Mode’s docsRefine data scopeDescribe how you want to limit your data, have AI define the WHERE clause--! exclude returns
Source: mode.com/help/articles/ai-assist · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT yes · Gemini partly

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