Prompt Claude for Data Analysis

Data analysis has become a strategic lever for any organization seeking to make informed decisions. Claude excels at interpreting complex datasets, whether CSV tables, survey results, financial metrics, or application logs. Unlike traditional analysis tools that require advanced technical skills, Claude allows you to obtain actionable insights in natural language. You can submit raw data and ask it to identify trends, anomalies, correlations, or hidden patterns. It can segment your data, calculate descriptive statistics, formulate explanatory hypotheses, and suggest relevant visualizations. Whether you are an experienced data analyst looking to speed up your exploratory workflow, or a non-technical decision-maker wanting to understand a report, Claude adapts to your level of expertise. It transforms raw numbers into understandable narratives, concrete recommendations, and measurable action plans. This page offers optimized prompts to get the most out of Claude in your daily data analyses.

The prompt

Claude

You are a senior data analyst specialized in exploratory analysis. I will provide you with a dataset. Here is your mission:

General overview: Describe the data structure (number of rows, columns, variable types, missing values).
Descriptive statistics: Calculate key indicators (mean, median, standard deviation, quartiles) for each numerical variable.
Trends and patterns: Identify the 3 to 5 most significant trends in the data.
Anomalies: Spot outliers or inconsistencies that warrant investigation.
Correlations: Analyze relationships between variables and point out strong correlations (positive or negative).
Segmentation: Propose a relevant segmentation of the data if applicable.
Recommendations: Formulate 3 to 5 actionable recommendations based on your analysis.
Limitations: Indicate the limitations of your analysis and the additional data that would allow deeper exploration.

Present each section with a clear heading. Use tables for key figures. Simplify your conclusions so they are understandable by a non-technical person.

Here is the data:
[PASTE YOUR DATA HERE]

Personalize this prompt with Léa

Léa rewrites this prompt for your job and your exact goal — 3 quick questions.

Why it works

This prompt works thanks to the attribution of a precise expert role (senior data analyst) that activates Claude's statistical knowledge, combined with an 8-step structure that imposes a rigorous methodological framework covering the entire analytical process. The explicit request for simplification and actionable recommendations forces Claude to go beyond mere description to produce decision-oriented analysis.

Expected result

You will obtain a structured analysis report including a data summary, key statistics presented in tables, identification of major trends and anomalies, as well as concrete recommendations. The report will be written in accessible language, with clearly delineated sections allowing quick or in-depth reading depending on your needs.

Variants by level

FAQ

How much data can I submit to Claude for analysis?

Claude can efficiently process datasets of up to several thousand lines in plain text (CSV, Markdown tables). For large datasets, it is recommended to submit a representative sample (500 to 2000 rows) or provide aggregated statistics. If your data exceeds the context window, split it into thematic segments and analyze them in several steps, then ask Claude for an overall synthesis.

In what formats can I provide my data to Claude?

Claude accepts data in CSV, Markdown tables, JSON, tabulated text, or even pasted directly from a spreadsheet. CSV format with headers is the most reliable for correct interpretation. Avoid binary formats (Excel .xlsx) that cannot be read as plain text. If your data comes from Excel, export it as CSV or copy-paste the table directly. Remember to include column headers so Claude understands the meaning of each variable.

Can Claude replace a Business Intelligence tool like Tableau or Power BI?

Claude does not replace BI tools for producing interactive dashboards or processing massive databases in real time. However, it excels as a complement to these tools: quick exploration of a new dataset, hypothesis generation, interpretation of results in natural language, writing analysis reports, or generating Python/SQL code to automate recurring analyses. Claude is particularly useful in the exploratory phase, before building a formal dashboard.

How to use this prompt

Copy the prompt with the button above.
Paste it into ChatGPT, Claude or your favorite AI assistant.
Replace the bracketed variables with your details, then refine the result.

About Prompt Guide

Prompt Guide is a free library of 4800+ ready-to-use prompts for ChatGPT, Claude and other AIs, with guides to learn prompting and tools to build and optimize your own prompts.

Prompt library Learn prompting Prompt builder Prompt optimizer

Already have a prompt?

Paste it into the Optimizer, AI improves it in 5 seconds: role, context, format. Free, no signup.

Open the Optimizer

More prompts to explore

Prompt Claude for Designing Software Architecture

Software architecture design is a fundamental step that determines a project's maintainability, scalability, and robustness. Claude exce

Prompt Claude for Writing a Cover Letter

Writing a convincing cover letter is a delicate exercise that requires finding the right balance between professionalism, authenticity, and relevance.

Prompt Claude for Writing a Professional Bio

Writing a compelling professional bio is a delicate exercise that requires finding the right balance between highlighting your career and authenticity.

Prompt Claude for Writing a Sales Page

Writing an effective sales page is an exercise that combines psychology, copywriting, and business strategy. Every word counts: the hook must grab attention in less than three seconds, the body must maintain interest while building desire, and the call to action must trigger the purchase. Claude excels at this exercise thanks to its ability to structure persuasive argumentation while maintaining an authentic tone. Unlike generic approaches, Claude can adapt the sophistication level of copywriting to your audience: direct and emotional language for B2C, rational and data-driven argumentation for B2B. By providing precise context about your product, target audience, and goals, you get a complete sales page that integrates proven direct-response copywriting principles—from the AIDA formula to open loops and social proof. The result is conversion-ready text that you can refine and test quickly.

Prompt Claude for Writing a Thesis

Writing a thesis is a demanding academic exercise that requires research, analysis, structuring, and writing skills. Claude can become...

Prompt Claude for Writing an Internal Memo

Writing internal memos is a delicate exercise that requires clarity, diplomacy, and adaptation to the organizational context. Whether announcing a restructuring, celebrating a collective success, or communicating a policy change, every word counts. Claude excels in this area thanks to its ability to adjust tone, structure information hierarchically, and anticipate employee questions. By providing Claude with the precise context—nature of the announcement, target audience, company culture, and sensitivity level—you get a professional memo that respects corporate communication codes while remaining human and engaging. The AI also helps you avoid common pitfalls: excessive jargon, ambiguities that generate anxiety, or omission of essential practical information. Whether you are an HR manager, communications director, or team leader, Claude turns your rough notes into a structured, empathetic, and actionable message that your employees will read to the end.