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
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
Variants by level
FAQ
How much data can I provide to ChatGPT for analysis?
Are ChatGPT analyses reliable for business decisions?
How should I structure my data before submitting it to ChatGPT for the best analysis?
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.
More prompts to explore
ChatGPT Prompt for Evaluating Skills
Skills assessment is a central issue for recruiters, managers, and trainers. Traditionally time-consuming and subjective, this process can be significantly improved with ChatGPT.
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 Grading Papers
Grading papers is one of the most time-consuming tasks for teachers, trainers, and tutors. Between spelling mistakes, grammar errors, stylistic awkwardness, and content evaluation, each paper can take 10 to 30 minutes of meticulous work. ChatGPT radically transforms this process by offering a fast, structured, and consistent first pass of correction. The AI can identify language errors, assess argumentative quality, check coherence, and provide personalized pedagogical feedback. Unlike a simple spell checker, ChatGPT understands context, analyzes text structure, and can adapt its feedback to the student's level. It doesn't replace the teacher's judgment but saves considerable time by automating the mechanical part of grading. Used intelligently, it allows more time for personalized support and qualitative feedback that truly helps students progress. Here is an optimized prompt to fully leverage this capability.
ChatGPT Prompt for Optimizing SEO
SEO (Search Engine Optimization) is a fundamental lever for generating qualified organic traffic to your website. Yet mastering all its facets...
ChatGPT Prompt for Organizing a Project
Organizing a project can quickly become a headache, especially when juggling multiple tasks, deadlines, and stakeholders. ChatGPT proves to be a valuable ally to structure your project from A to Z.
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.
Go further
Get new prompts every week
Join our newsletter.