ChatGPT Prompt for Data Analysis

Data analysis has become an indispensable strategic lever for businesses and professionals. Yet extracting relevant insights from raw datasets remains a technical challenge that usually requires skills in statistics, programming, or specialized tools like advanced Excel, Python, or R. ChatGPT radically transforms this approach by allowing anyone to analyze complex data through natural language instructions. Whether you are working on sales data, survey results, marketing metrics, or financial indicators, a well-structured prompt enables you to obtain statistical analyses, correlations, trends, and actionable recommendations in seconds. The key lies in how you formulate your request: a precise prompt that defines the context, the desired type of analysis, and the expected output format will yield considerably more actionable results than a vague query. In this guide, you will find optimized prompts to get the most out of ChatGPT in your data analyses, regardless of your expertise level.

The prompt

ChatGPT

Act as a senior data analyst with 15 years of experience in business intelligence. I will provide you with a dataset [DESCRIBE_FORMAT: table, CSV, list]. Here is the data:

[PASTE_YOUR_DATA_HERE]

Conduct a comprehensive analysis following this methodology:

Overview: Summarize the main characteristics of the dataset (number of entries, variables, data types, missing values).
Descriptive statistics: Calculate key indicators (mean, median, standard deviation, min/max) for each numerical variable.
Trends and patterns: Identify temporal trends, seasonalities, or recurring patterns.
Correlations: Detect significant relationships between variables and quantify their strength.
Anomalies: Flag outliers or suspicious data that warrant investigation.
Actionable insights: Propose 3 to 5 concrete recommendations based on the results, ranked by potential impact.

Present the results in a structured format with tables where relevant. Use accessible but rigorous language. For each insight, specify the confidence level (high, medium, low) and the analysis limitations.

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 three key mechanisms: assigning an expert role that activates the model's specialized knowledge in data analysis, a structured six-step methodology that forces a comprehensive rather than superficial analysis, and the explicit request for confidence levels that prompts the model to nuance its conclusions. Specifying the output format (tables, ranked recommendations) ensures a directly usable result without reformatting.

Expected result

You will obtain a structured analysis report including a complete statistical summary of your data, identification of major trends and correlations between variables, as well as a list of actionable recommendations ranked by impact. Each conclusion will be accompanied by a confidence level and methodological limitations, allowing you to make informed decisions based on your data.

Variants by level

FAQ

How much data can I provide to ChatGPT for analysis?

ChatGPT can process datasets directly in the chat up to about 2,000 to 3,000 rows in text format, depending on column complexity. For larger datasets, use the Code Interpreter (Advanced Data Analysis) feature which allows uploading CSV or Excel files with no practical size limit. Tip: if your data exceeds the chat limit, provide a representative sample with key columns and ask ChatGPT to generate a Python script you can run on the full dataset.

Are ChatGPT analyses reliable for business decisions?

ChatGPT produces relevant and often accurate analyses, but it is essential to consider them as a starting point, not an absolute truth. The model can make calculation errors, incorrectly interpret correlations as causations, or lack specific business context. Good practice: always verify critical calculations with a spreadsheet, cross-check insights with your domain expertise, and explicitly ask ChatGPT to mention its limitations and assumptions. For high-stakes decisions, use ChatGPT to generate hypotheses and leads, then validate with dedicated statistical tools.

How should I structure my data before submitting it to ChatGPT for the best analysis?

The quality of the analysis directly depends on the quality of the data provided. Choose a clear tabular format with explicit headers (avoid ambiguous abbreviations). Clean the data beforehand: remove obvious duplicates, harmonize date and number formats, and flag missing values rather than leaving them blank. Always add context: specify what each column represents, the period covered, the unit of measurement, and the objective of your analysis. A well-prepared dataset with clear context will produce ten times more relevant results than a simple raw copy-paste.

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

ChatGPT Prompt for Generating Advertising Visuals

Creating advertising visuals is a major challenge for any company looking to stand out on social media, display, or print. With Cha

ChatGPT Prompt for Writing a Cover Letter

The cover letter remains a key element of any application, but writing it is often a daunting exercise. Between writer's block, the difficulty of highlighting yourself without sounding pretentious, and the need to adapt each letter to the targeted job, the process can be time-consuming and frustrating. ChatGPT turns this challenge into a structured and efficient exercise. By providing it with the right information — your background, the targeted position, the company's values — the AI generates a personalized letter that showcases your skills while precisely meeting the recruiter's expectations. The goal is not to delegate the entire writing process, but to obtain a solid foundation that you will refine with your personal touch. The prompt below is designed to produce letters that stand out from generic formulations, relying on a compelling narrative structure and a professional tone suited to your industry.

ChatGPT Prompt for Writing a Professional Bio

Writing a compelling professional bio is a delicate exercise that requires finding the right balance of credibility, authenticity, and impact. Whether it's

ChatGPT Prompt for Writing a Sales Page

Writing a sales page is one of the most demanding exercises in digital marketing. It must capture attention in seconds, maintain interest, create desire, and trigger action—the famous AIDA model.

ChatGPT Prompt for Writing a Speech

Writing a compelling speech is a demanding exercise that requires solid argumentative structure, a tone adapted to the audience, and the ability to captivate attention from start to finish.

ChatGPT Prompt for Writing an Internal Memo

Writing an internal memo is a delicate exercise that requires clarity, conciseness, and a tone tailored to the company culture. Whether it's announcing

Go further

How to prompt ChatGPT

The complete guide: techniques, examples and best practices.

Free prompt library

4800+ prompts sorted by category, one-click copy.

Get new prompts every week

Join our newsletter.