AI Codex
Tools & Ecosystemfield-note

What AI actually looks like for a data and analytics team

Data teams have a counterintuitive relationship with Claude — it is not about the analysis, it is about everything around it.

5 min read·Tool Use

Data analysts and data scientists have a complicated relationship with AI tools. On one hand, they work with the kind of structured, logical problems that AI should handle well. On the other hand, the core of their work — running queries, building models, statistical analysis — is better handled by their existing tools than by Claude.

The real value for data teams is not in the analysis. It is in everything around it.

Where Claude delivers for data teams

Translating analysis into communication. The gap between what a data team can see in data and what stakeholders understand from it is enormous. Claude closes that gap. "Here is what this cohort analysis shows. Write an executive summary for a non-technical audience that makes the business implication clear." This is where data teams spend disproportionate time — Claude handles the translation without losing the integrity of the finding.

Writing SQL and Python faster. Claude cannot run your database or your Jupyter notebook. But it can write the query or the function, which you then review and run. For a data analyst, "write a SQL query that does X given this schema" is a meaningful time saving — especially for unfamiliar syntax or edge cases. Always review before running.

Documentation that actually gets written. Data documentation is universally behind. Datasets go undocumented. Pipelines are a mystery to anyone who didn't build them. "Here is the schema and what this table is used for. Write the documentation for it." Claude produces documentation that would never have been written otherwise, because the barrier was the blank page rather than the knowledge.

Stakeholder question handling. "The head of sales asked why their pipeline numbers differ from the finance report. Help me draft an explanation that covers the three most likely reasons and asks the right clarifying questions." Data teams field questions like this constantly. Claude helps draft the response; the analyst confirms the technical accuracy.

Exploratory analysis planning. "I have a dataset with these columns and I want to understand what drives churn. What analyses should I run and in what order?" Claude can produce a structured analysis plan — not the analysis, but the plan. Useful for junior analysts or unfamiliar domains.

What Claude does not replace for data teams

The actual analysis. If you ask Claude to analyse a dataset in a conversation, it will give you a plausible-sounding answer that is not grounded in your actual data. Your numbers, your statistical methods, your model outputs — these must come from your actual tools: SQL, Python, R, your BI platform, whatever you use.

Claude works with text. Your data lives in databases, dataframes, and visualisation tools. The integration between these is thin unless you are using Tool Use or code execution in an agent context — and even then, the analyst needs to understand and verify what is being run.

Statistical interpretation. Claude knows statistics. It does not know your data's specific characteristics, distribution, or the domain context that makes an effect meaningful or trivial. Statistical conclusions about your data require a statistician — Claude can help explain methodology, not validate findings.

The setup for data teams

A data Project with:

  • Your data dictionary or key table schemas
  • Standard query patterns your team uses
  • Definitions for key business metrics (to ensure consistency)
  • Communication templates (executive summary format, stakeholder update format)

System prompt: "You are a data communication assistant for [Company]'s analytics team. You help translate data findings into clear communication for non-technical stakeholders, assist with documentation, and help draft queries and code. You do not run analysis or provide statistical conclusions without being given data — you work with what the team provides."

The real pattern

The data teams that get the most from Claude are not using it for analysis. They are using it to multiply the impact of their analysis — faster communication, better documentation, less time on translation and more time on the work that requires their expertise. That is the right division of labour.