data•6 prompts
Data Analysis Prompts
AI can speed up every step of data analysis—from cleaning to insights. These prompts help you extract value from your data faster.
1. Data Exploration
Best: ClaudeI have a dataset about [describe data]. Columns include: [list columns]. Help me explore it: What questions should I ask? What patterns might exist? What analyses would reveal interesting insights? What should I check for data quality?
Exploration before analysis. Understand your data before diving deep.
2. SQL Query
Best: ClaudeWrite a SQL query to [describe what you want to find]. Tables involved: [describe schema]. I need to: [specific requirements]. Optimize for readability and performance. Explain what each part does.
Include your database type (PostgreSQL, MySQL, etc.) for accurate syntax.
3. Excel Formula
Best: ChatGPTWrite an Excel formula to [describe calculation]. My data is in: [describe layout]. I need to handle: [edge cases]. Explain the formula and suggest alternatives if this could be done more simply.
ChatGPT's Code Interpreter can test Excel formulas. Describe your layout clearly.
4. Statistical Analysis
Best: ClaudeHelp me analyze this data statistically: [describe data and question]. What statistical test is appropriate? What assumptions should I check? Walk me through the analysis and how to interpret results.
Statistics requires choosing the right test. State your hypothesis clearly.
5. Find Insights
Best: ChatGPTAnalyze this data and find insights: [paste data or describe patterns]. Look for: trends, outliers, correlations, and actionable findings. Present insights as "We found X, which suggests Y, so we should Z."
Upload data to Code Interpreter for actual analysis, not just suggestions.
6. Data Cleaning
Best: ClaudeHelp me clean this messy data: [describe problems: duplicates, missing values, inconsistent formats, etc.]. For each issue: explain the best approach, write the code/formula to fix it, and note any judgment calls.
Cleaning is 80% of data work. Document your decisions.
Try These Prompts with Multiple AIs
Get responses from Claude, ChatGPT, Gemini, and more—all at once. Compare which AI handles these prompts best.
Try Council Free