The tools

The work surface determines what AI can see, change, and leave behind.

This is a showcase of current approaches, not a ranking. Product pages establish feature and target-user contracts; measured systems are labeled separately.

Feature contract

Provider or maintainer says the capability exists.

Measured system

A defined human study exists, though often on an older system version.

Conversation and artifacts

Bring a bounded file to the model—or ask it to make a small application.

Fastest route to a one-off result. Local semantics, delivery, and maintenance arrive mostly through the prompt and the person.

  • ChatGPT data analysis

    Executed analysis, tables, common charts, code, and downloads.

    Control: inspect code and intermediate results.
  • Claude Artifacts

    Generated HTML or application code for custom interactive explanation.

    Watch: state, accessibility, hosting, maintenance.
  • Julius

    Specialist data chat for files, connections, charts, models, and reports.

    Independent correctness and repair evidence is sparse.
Spreadsheet-native

Keep the familiar grid while adding analysis, code, and chart generation.

Installed context and handoff improve. Refresh behavior and copied data can quietly become the new failure surface.

  • Copilot in Excel

    Python-backed answers and optional static chart or table insertion.

    Advanced mode can create editable, refreshable Python cells.
  • Gemini in Sheets

    Summaries, formulas, prompted edits, and editable inserted charts.

    Inserted charts follow copied support data, not later changes to the original range.
  • Bricks

    One workspace for spreadsheet data, live dashboards, slides, and team collaboration.

    Evidence: provider contract.
  • Quadratic

    AI spreadsheet with Python, SQL, JavaScript, live connections, and visible code cells.

    Control: schema and code remain in the grid.
Notebooks and visible canvases

Place generated work inside an inspectable analysis state.

These environments give AI more project context while preserving cells, nodes, versions, and role-specific controls.

  • Hex AI

    Edits SQL, Python, chart, pivot, and Markdown cells; builds apps; queries curated data.

    Technical authors audit code; consumers use published apps; managers govern context.
  • Observable Canvases AI

    Adds tables, transformations, SQL, and charts beside existing work.

    Control: creates new versions instead of silently overwriting or deleting.
Guided storytelling editor

Use natural language as a shortcut into a known visual grammar.

The assistant can make precise native edits because the editor constrains the available state.

  • Flourish AI

    Changes style, labels, sources, annotation, and accessibility settings in the editor.

    Control: reversible native edits. Boundary: it does not edit source data or invent intent.
Established BI authoring

Ask AI to work inside a report, worksheet, or maintained semantic model.

More local context can narrow errors, but it also makes data teams responsible for metadata, measures, instructions, and review.

  • Power BI Copilot

    Creates and modifies report pages against model and report state.

    Depends on measures, descriptions, permissions, and review.
  • Tableau Agent

    Builds views and calculations in existing web-authoring surfaces.

    Control returns through the worksheet and data source.
  • Looker Conversational Analytics

    Maps questions onto governed LookML fields and measures.

    Administrators own glossaries, defaults, and verified queries.
Governed conversational analytics

Let business consumers ask questions over curated organizational data.

Provider direction is converging on a separate author who owns semantics, permissions, review, and feedback.

  • ThoughtSpot Spotter

    Search and conversational analysis for business teams.

    Data teams maintain governed models rather than answer queues.
  • Ask Sigma

    Shows sources, formulas, filters, and multi-step analysis.

    Control: edit individual steps instead of regenerating everything.
  • Qlik Answers

    Structured and unstructured RAG plus chart and dashboard agents.

    Includes permissions and audit logs.
  • Databricks Genie

    SQL-backed answers and visualizations in a curated no-code chat.

    Authors monitor, review, and refine definitions and instructions.
  • Amazon Q in QuickSight

    BI authoring, Q&A, executive summaries, and data stories.

    Inherits datasets, topics, permissions, and author review.
  • Oracle Analytics AI Assistant

    Charts and narratives for consumers over author-prepared data and metadata.

    Explicitly separates author and consumer roles.
Mixed-initiative and open source

Constrain generation with visible data state, declarative specifications, and reusable guardrails.

These approaches make model output more inspectable and executable. Current repositories often exceed the versions evaluated in research.

  • Data Formulator

    Direct encoding plus natural-language transformation, branching, visible derived data, and reports.

    Measured system Small reproduction study; current project is newer.
  • Lumen

    Serializable declarative pipelines, charts, dashboards, and specialist agents.

    Generated work can move from chat into notebooks or apps.
  • Vizro

    Low-code Python dashboard specification with code escape hatches and agent tools.

    Production components narrow generation; acceptance tests remain necessary.
  • AntV visualization skills

    Retrievable library syntax, chart vocabulary, declarative output, and version guardrails.

    Reports its own 174-case tests; independent current-model ablation is still needed.