Best AI tools for data analysis: which to weigh, and when
This guide compares six AI tools for data analysis on the data each takes in, what it computes and what it costs to start. We make Ultramarine Work, so it is entry 1, and every entry says where another tool fits better.
Checked on
At a glance
| Product | Best for | Available on | Starts at | Free access |
|---|---|---|---|---|
| ChatGPT | Exploratory Python analysis of an uploaded file | Web, desktop and mobile ChatGPT apps | Free plan, Go $8, Plus $20 a month | Yes, limited data analysis and uploads |
| Julius AI | No-code charts and statistics, warehouse connections | Web app | Free plan, Plus $20 a month | Yes, a limited free plan |
| Ultramarine Work | Analytics and data science work, from raw exports to memos | Web app and desktop app for Mac and Windows | $5 a month (Starter) | 7 days free on Starter and Plus |
| Hex | Warehouse SQL and Python notebooks for data teams | Web platform | Free Community, Professional $36 an editor | Yes, Community plan with agent trial |
| Claude | Analysis that ends in files, large messy inputs | Web, desktop and mobile Claude apps | Free plan, Pro $20 a month | Yes, limited usage in 5-hour and weekly windows |
| Copilot in Excel | Questions and edits inside an Excel workbook | Excel on Windows, Mac, web, iPad, mobile | From Microsoft 365 Personal $9.99 a month | Standard access for some business users, none for consumers |
The tools to weigh
1. ChatGPT
OpenAI
- Good for
- An exploratory first pass on a file you upload: cleaning, distribution checks, statistical tests and charts in one conversation, with the Python it wrote shown for review. Analysts iterate on a CSV or workbook without opening a notebook, and the charts and summaries drop straight into a memo.
- How it works
- A feature of ChatGPT (web, desktop and mobile) that writes and runs Python in a sandboxed notebook environment
- Runs on
- OpenAI’s own models: the plan page names GPT-6.1 Sol, GPT-6 Astra, GPT-6 Sol, GPT-6 Luna and GPT-5.6 Terra (November 2026), varying by plan.
- Price
- Free plan with limited data analysis and uploads, Go $8 a month (may include ads), Plus $20, Pro from $100.
- Choose it when
- The work is one exported file and one afternoon: a data quality scan, quick distributions, a chart for tomorrow’s memo, with the exact code there to read.
Sources: OpenAI Help Center, Data analysis with ChatGPT, ChatGPT pricing
2. Julius AI
Julius AI
- Good for
- Chatting with spreadsheets and databases in plain language: the agent writes the Python, runs the statistics and regressions, renders charts and shows the code to verify. Connectors reach Snowflake, BigQuery, MySQL, Postgres and SQL Server, and the same workspace turns results into reports, decks and dashboards.
- How it works
- A web app for chatting with files and databases, with reports, presentations, dashboards and sites in the same workspace
- Runs on
- Named on its pricing page: GPT-6.1 Sol and Claude Opus 5.5 on paid plans, and its own Julius models from Julius 1.2 Lite on Free (November 2026).
- Price
- Free plan, Plus $20 a month (2,000 credits), Pro $45, Business $450, Enterprise by quote.
- Choose it when
- Questions arrive weekly, the analyst should not have to write Python, and you want warehouse connections and a client-ready deck from the same subscription.
Sources: Julius AI pricing, Julius AI docs, credits overview, Julius AI docs, model selector
3. Ultramarine Work
Paper Instruments
Ultramarine Work fits product and BI analysts, data scientists and analytics leads whose analyses end in a memo or a chart pack. Its Analytics & Data Science mode carries 13 skills for recurring work: explaining why a KPI moved, metric definitions, A/B tests, cohort studies, causal analyses and forecasts. You pick the mode once, and the agent picks the skills each step needs. Warehouse teams are better served by Hex, workbook-heavy finance by Copilot in Excel.
Analytics & Data Science carries 13 skills, each a written method with definitions, formulas and review standards, from metric specification and cohort analysis to difference-in-differences. Ultramarine 1 Flash, our model, post-trained on GLM-5.3-Flash for knowledge work, reads the folder’s files, applies those skills and runs code where numbers must be computed. Paper Instruments writes the skills and trains the model, so both improve together. Standard runs our model on any plan, Assisted adds a frontier model as an advisor, and Advanced gives a frontier model the whole task.
4. Hex
Hex Technologies
- Good for
- Data teams that live in SQL and Python on a cloud warehouse: the agent drafts cells in notebooks that stay versioned and reviewed, the analysis runs against governed tables in Snowflake, BigQuery or Databricks, and a notebook can publish as a data app or a scheduled run. Threads gives business users self-serve answers.
- How it works
- A collaborative data notebook platform that connects to cloud warehouses, with agents for notebooks, modeling and self-serve
- Runs on
- A picker with Auto plus Claude Opus 5.5 and Fable 5.1, GPT 6 Sol, Astra and Luna, Grok 4.6 (added September 23, 2026), or your own keys on Enterprise.
- Price
- Community plan free (agent trial), Professional $36 an editor a month, Team $75, Enterprise custom, with monthly per-seat credit grants.
- Choose it when
- The analysis must survive review and re-run: versioned notebooks on live warehouse tables, teammates auditing the SQL, and scheduled runs keeping results current.
Sources: Hex pricing, Hex docs, AI overview
5. Claude
Anthropic
- Good for
- Analysis that ends in finished files: code execution on uploaded workbooks, handling for long multi-tab files, and output written back as a cleaned workbook, a memo or a deck. Claude Sheets (beta) works spreadsheet-style, Claude for Excel edits existing workbooks, and the same model writes the findings.
- How it works
- A feature of the Claude apps (web, desktop and mobile): code execution, file creation, Claude Sheets beta, Claude for Excel add-in
- Runs on
- Anthropic’s own Claude models throughout: Opus, Sonnet, Haiku and Fable, depending on plan.
- Price
- Free plan with limited usage in 5-hour and weekly windows, Pro $20 a month ($17 annual), Max $100, Ultra $200 with no 5-hour limit for verified accounts.
- Choose it when
- The analysis has to read long, messy documents the spreadsheet never captures, or the deliverable is a memo that carries the numbers and the argument together.
Sources: Claude pricing, Anthropic support, Claude Sheets in the web app
6. Copilot in Excel
Microsoft
- Good for
- Analysis inside the workbook you already have: chat mode answers data questions and returns charts, PivotTables, summaries, trends and outliers, and edit mode builds formulas, tables and reports in-sheet through multi-step plans. It runs in Excel on Windows, Mac and web.
- How it works
- Built into Excel on Windows, Mac, web and iPad and phone, with edit, plan and chat modes
- Runs on
- Editing uses Anthropic models per the consumer support page. A January 2026 Microsoft post named GPT 5.2 and Claude Opus 4.5 choices for Microsoft 365 Copilot.
- Price
- From Microsoft 365 Personal $9.99 a month, Premium $19.99, Copilot Business $21 a user a month, enterprise $30, plus a base Microsoft 365 license.
- Choose it when
- The workbook is the shared object the team audits, and edits should land next to the formulas finance already checks, with no exports.
Sources: Microsoft Support, Copilot in Excel overview, Microsoft 365 Copilot pricing for individuals, Microsoft 365 Copilot pricing for businesses
Pricing and how to try it
Plans start at $5 a month, and Starter and Plus begin with 7 days free. On our internal PI Knowledge Work benchmark, Ultramarine 1 Flash costs about $0.13 a task, about a tenth of Claude Opus 5.5 or GPT-6 Sol at comparable scores.
Questions
Do these tools run code on my file, or estimate the totals?
Yes, they run code rather than estimating the totals. Ultramarine Work, ChatGPT, Claude and Julius write and run Python on your files, Hex runs SQL and Python against the warehouse, and Copilot in Excel works in the sheet itself. Read the code each tool ran, check row counts against your source, and ask for a specific method when a chart looks off, because the tool picks the method and can pick wrongly.
Do I need to know Python or SQL to use these?
No for ChatGPT, Claude, Julius, Copilot in Excel and Ultramarine Work, which write and run the code for you and show it for review. Hex is built for teams that work in SQL and Python, and its Threads feature answers questions for colleagues who do not.
Will these tools use our customer data for training?
Check each vendor’s terms, which differ by plan. Ultramarine Work changes files only in the project’s folder. When a request needs it, it can read files elsewhere on your computer, never passwords, keys or app data, and you can turn that off in settings. The model runs on Paper Instruments’ servers, so the content it works on is sent there to be processed. Paper Instruments is SOC 2 Type II, and our security and compliance details are on our compliance page. Whatever the tool, strip personal data you do not need before sending files.
Can I query the warehouse instead of uploading CSVs?
Hex and Julius connect to warehouses directly, so queries run where the data lives. ChatGPT, Claude and Copilot in Excel mostly work on uploaded files or the open workbook. Ultramarine Work has no warehouse connector: it works on exported files and on apps it connects to, such as Google Sheets and Airtable, so export the query results first.
Can a small team evaluate these tools before committing?
ChatGPT, Claude and Julius each have a free plan or an $8 to $20 entry, Hex has a free Community plan and a trial, and Copilot in Excel comes with Microsoft 365 licenses some teams already hold. Ultramarine Work has no free tier. Its entry is the Starter plan at $5 a month, which begins with 7 days free. Score every tool on the same question and the same dataset.
Sources
Checked on
- OpenAI Help Center, Data analysis with ChatGPThelp.openai.com
- ChatGPT pricingchatgpt.com
- MacRumors, OpenAI launches ChatGPT Go planmacrumors.com
- Julius AI pricingjulius.ai
- Julius AI docs, credits overviewjulius.ai
- Hex pricinghex.tech
- Hex docs, AI overviewlearn.hex.tech
- Claude pricingclaude.com
- Anthropic support, Claude Sheets in the web appsupport.claude.com
- Microsoft Support, Copilot in Excel documentationsupport.microsoft.com
- Microsoft 365 Copilot pricing for individualsmicrosoft.com
- Microsoft 365 Copilot pricing for businessesmicrosoft.com
- PostHog docs, retention analysisposthog.com
- Ultramarine 1 Flash: cost per task and methodpaperinstruments.com
- Ultramarine 1 Flash model cardhuggingface.co
- Julius AI docs, model selectorjulius.ai