50 Claude Prompts for Data Analysts | AIA Copilot
As a business analyst, you spend hours manually reviewing data, writing reports, and translating complex findings for stakeholders. Claude's 200K token context window can analyze entire datasets in seconds, while Claude Projects maintains context across your analysis workflow. These 50 prompts will help you automate the tedious parts of analysis so you can focus on insights and strategy. I use these daily with clients to cut report turnaround time by 70% while improving quality.
Data Quality & Preparation
1. Dataset Schema Analysis
Upload your CSV or Excel file and prompt: 'Analyze this dataset structure. Identify column types, missing values, potential data quality issues, and suggest cleanup steps.' Claude's vision capability reads tables accurately and flags inconsistencies you'd spend an hour finding manually.
2. Data Dictionary Generator
Paste raw column names and sample data, then prompt: 'Create a professional data dictionary with field names, data types, descriptions, valid ranges, and business definitions.' Store this in Claude Projects for your team to reference across analyses.
3. Duplicate Detection Logic
Share your data structure and ask: 'Design a deduplication strategy for this dataset. Specify matching rules, handling of partial matches, and which records to keep based on recency and completeness.' Gets you production-ready logic in minutes.
4. Missing Data Impact Assessment
Upload incomplete datasets and prompt: 'Quantify the impact of missing values on each column. Recommend imputation strategies or exclusion rules based on missingness patterns and analysis objectives.' Claude catches patterns you'd miss in spreadsheet scans.
5. Data Validation Rule Builder
Describe your business context and ask: 'Generate SQL or Python validation rules to check for: negative revenues, future dates, duplicate IDs, orphaned records, and out-of-range values.' Get copy-paste ready code.
6. Outlier Detection Strategy
Share your numeric columns and prompt: 'Design an outlier detection approach using IQR, Z-score, or domain rules. Explain which method fits each variable and how to handle identified outliers.' Claude explains the statistics clearly for stakeholder documentation.
7. ETL Process Documentation
Describe your data pipeline and ask: 'Document this ETL process with source-to-target mappings, transformation logic, data quality checks, and error handling steps in a format suitable for technical and business audiences.' Perfect for handoffs.
8. Data Lineage Mapper
Upload database documentation and prompt: 'Trace data lineage from source systems through transformations to final reports. Identify dependencies and potential impact points for schema changes.' Critical for change management.
Exploratory Data Analysis
9. Dataset First Impressions
Upload your data and prompt: 'Provide an executive summary of this dataset: record count, time period, key dimensions, notable patterns, and three initial insights worth investigating.' Great for kickoff meetings.
10. Correlation Analysis Interpreter
Paste correlation matrix results and ask: 'Explain these correlations in business terms. Flag strong relationships, potential multicollinearity issues, and counterintuitive findings that need investigation.' Turns statistics into strategy.
11. Trend Pattern Identifier
Share time-series data and prompt: 'Identify trends, seasonality, cyclical patterns, and structural breaks. Suggest potential business drivers for each pattern observed.' Claude's 200K context handles years of daily data in one prompt.
12. Segment Discovery Prompt
Upload customer or product data and ask: 'Identify natural segments based on behavioral and demographic patterns. Describe each segment's characteristics and suggest targeting strategies.' Faster than manual pivot table exploration.
13. Statistical Test Selector
Describe your analysis question and data structure, then prompt: 'Recommend appropriate statistical tests with assumptions to check, sample size requirements, and interpretation guidelines.' Ensures methodological rigor.
14. Visualization Recommendation Engine
Share your data types and analysis goals, then ask: 'Suggest the most effective chart types for each insight, with specific design recommendations for clarity and impact.' Includes color, scale, and labeling advice.
15. Anomaly Explanation Generator
Highlight unusual data points and prompt: 'Propose three plausible business explanations for these anomalies. Suggest validation steps and data sources to confirm each hypothesis.' Speeds root cause analysis.
16. Distribution Analysis Writer
Share summary statistics and ask: 'Describe the distribution of each variable in plain English. Flag skewness, heavy tails, or multimodal patterns and explain business implications.' Makes technical findings accessible.
Business Requirements & Documentation
17. Requirements Clarification Assistant
Paste vague stakeholder requests and prompt: 'Identify ambiguities, missing information, and assumptions in these requirements. Generate clarifying questions organized by priority.' Prevents scope creep and rework.
18. User Story Generator
Describe business needs and ask: 'Write detailed user stories with acceptance criteria, edge cases, and testing scenarios in standard format.' Creates Claude Projects templates for consistent documentation.
19. Business Logic Flowchart Writer
Explain a process verbally and prompt: 'Document this business logic as a step-by-step flowchart with decision points, validation rules, and exception handling.' Use Claude Artifacts to get an editable diagram.
20. Functional Specification Builder
Share requirements and ask: 'Create a functional specification including scope, business rules, data requirements, calculations, validation logic, and UI behavior.' Gets you 80% done instantly.
21. Edge Case Identifier
Describe your business rules and prompt: 'List edge cases, boundary conditions, and exception scenarios that could break these rules. Include handling recommendations for each.' Catches issues before development.
22. Acceptance Criteria Writer
Share feature descriptions and ask: 'Write testable acceptance criteria covering happy path, negative scenarios, performance expectations, and data validation requirements.' QA-ready documentation.
23. Process Gap Analyzer
Upload current and future state documentation, then prompt: 'Identify gaps between current and desired processes. Prioritize changes by impact and complexity with implementation considerations.' Perfect for digital transformation projects.
24. Stakeholder Interview Guide Creator
Describe your project and ask: 'Generate interview questions for each stakeholder type covering goals, pain points, success metrics, constraints, and integration needs.' Ensures comprehensive discovery.
SQL & Data Extraction
25. SQL Query Generator from Plain English
Describe what you need and paste your schema, then prompt: 'Write a SQL query to extract this data with appropriate joins, filters, aggregations, and sorting.' Claude's code generation handles complex multi-table queries accurately.
26. Query Performance Optimizer
Share a slow query and ask: 'Optimize this SQL for performance. Suggest indexing strategies, query restructuring, and explain the execution plan improvements.' Includes before/after explanations.
27. Complex Join Logic Builder
Describe your data relationships and prompt: 'Write SQL with the correct join types and conditions to combine these tables, handling many-to-many relationships and preventing cartesian products.' Eliminates trial-and-error.
28. Window Function Expert
Explain your analytical need and ask: 'Write SQL using window functions for running totals, rankings, period-over-period comparisons, and cohort analysis.' Gets you advanced SQL without hours of documentation reading.
29. Data Quality Check Query Pack
Share your table structure and prompt: 'Generate SQL queries to check for nulls, duplicates, referential integrity, format issues, and business rule violations across all tables.' Creates a reusable audit script.
30. Parameterized Report Query Builder
Describe report requirements and ask: 'Write a parameterized SQL query with filters for date ranges, product categories, regions, and customer segments that handles null parameters gracefully.' Production-ready code.
31. SQL to English Translator
Paste complex legacy SQL and prompt: 'Explain what this query does in plain English. Document the logic, joins, filters, and calculations for non-technical stakeholders.' Essential for knowledge transfer.
32. Cross-Database Migration Helper
Share queries and target database type, then ask: 'Convert this SQL from [source] to [target] syntax, handling differences in functions, data types, and features.' Supports Oracle, SQL Server, PostgreSQL, MySQL migrations.
Report Writing & Communication
33. Executive Summary Generator
Upload your full analysis and prompt: 'Write a one-page executive summary with key findings, business impact, and recommended actions. Use bullet points and emphasize financial implications.' Perfect for time-pressed leadership.
34. Finding to Recommendation Converter
Share data insights and ask: 'Transform these analytical findings into specific, actionable business recommendations with implementation steps, resource needs, and expected outcomes.' Bridges the insight-to-action gap.
35. Technical to Business Translator
Paste technical analysis and prompt: 'Rewrite this for business stakeholders. Replace jargon with plain language, add context, and focus on business implications rather than methodology.' Makes your work accessible.
36. Data Story Builder
Share key findings and ask: 'Craft a narrative that connects these data points into a compelling story with context, tension, and resolution. Include transition sentences between insights.' Engages stakeholders emotionally.
37. Methodology Documentation Writer
Describe your analytical approach and prompt: 'Document the methodology including data sources, assumptions, calculations, limitations, and validation steps suitable for peer review.' Ensures reproducibility and credibility.
38. Presentation Slide Outliner
Upload your report and ask: 'Create a slide-by-slide outline for a 15-minute presentation with key messages, supporting data points, and visual recommendations for each slide.' Accelerates deck creation.
39. Limitations and Caveats Section
Share analysis details and prompt: 'Write a clear explanation of data limitations, methodological constraints, and interpretation caveats that stakeholders should consider before acting on findings.' Builds trust and manages expectations.
40. Quarterly Business Review Builder
Upload performance data and previous QBR, then prompt: 'Create a QBR report with period-over-period analysis, trend commentary, variance explanations, and forward-looking indicators.' Use Claude Projects to maintain QBR context quarter-over-quarter.
41. Chart Annotation Writer
Share your visualizations and prompt: 'Write concise annotations for each chart that highlight key takeaways, explain outliers, and guide the viewer's attention to what matters.' Makes dashboards self-explanatory.
Forecasting & Scenario Planning
42. Forecast Assumption Documenter
Describe your forecasting approach and prompt: 'Document all assumptions including growth rates, seasonality patterns, market conditions, and constraints. Format for stakeholder review and approval.' Creates accountability and alignment.
43. Scenario Matrix Builder
Share key variables and ask: 'Create a scenario planning matrix with best case, base case, and worst case projections. Include probability assessments and trigger indicators for each scenario.' Supports strategic planning.
44. Forecast Variance Explainer
Upload actual vs. forecast data and prompt: 'Analyze variances, categorize by type (volume, price, mix), quantify impact of each driver, and explain in narrative form suitable for management review.' Turns numbers into accountability.
45. Sensitivity Analysis Framework
Describe your model and ask: 'Design a sensitivity analysis testing how key assumptions impact outcomes. Specify ranges to test, variables to hold constant, and how to present results visually.' Gets you statistical rigor quickly.
46. Forecast Confidence Interval Interpreter
Share statistical forecast outputs and prompt: 'Explain prediction intervals and confidence levels in business terms. Help stakeholders understand uncertainty and make risk-informed decisions.' Prevents false precision.
47. What-If Scenario Designer
Describe your business context and ask: 'Design 10 what-if scenarios testing impact of price changes, volume shifts, cost increases, and market conditions. Specify inputs and outputs for each scenario.' Supports strategic discussions.
48. Forecast Model Documentation
Share your forecasting logic and prompt: 'Create technical documentation covering data inputs, transformation steps, algorithm choice, parameter tuning, validation approach, and update frequency.' Essential for model governance.
49. Time Series Decomposition Explainer
Upload decomposition results and ask: 'Explain the trend, seasonal, and residual components in business terms. Identify which component drives results and suggest forecasting implications.' Makes complex techniques accessible.
Python Analysis Automation
50. Pandas Data Cleaning Script
Describe your data issues and prompt: 'Write a Python script using pandas to clean this dataset: handle missing values, fix data types, remove duplicates, and validate ranges. Include comments explaining each step.' Gets production-ready code.
51. Automated Report Generator
Share report requirements and ask: 'Write Python code that extracts data, performs calculations, generates charts with matplotlib/seaborn, and exports to PDF/Excel with formatting.' Set up once, run monthly.
52. Statistical Analysis Script
Describe your hypothesis and data, then prompt: 'Write Python code for statistical testing including data prep, assumption checks, test execution, and results interpretation with scipy/statsmodels.' Ensures methodological correctness.
53. Data Visualization Template
Share your brand guidelines and chart needs, then ask: 'Create a Python visualization template with consistent colors, fonts, and styling that produces professional charts for this data type.' Standardizes reporting.
54. API Data Puller
Share API documentation and prompt: 'Write Python code to authenticate, pull data from this API, handle pagination and rate limits, and save to CSV/database with error handling.' Automates data collection.
55. Error Handler for Production Scripts
Share your working Python code and ask: 'Add comprehensive error handling with logging, email alerts, and graceful failures. Include retry logic and data validation checks.' Makes scripts production-grade.
💡 Pro Tips from an MCT
- Use Claude Projects to maintain context across your entire analysis lifecycle. Upload your data dictionary, business rules, and stakeholder preferences once, then reference them in every prompt without re-explaining.
- Enable prompt caching for repetitive analysis work. If you run the same type of report weekly with different data, cache your instructions and methodology documentation to cut API costs by 90% and speed up responses.
- Combine Claude's 200K token context with its vision capabilities by uploading screenshots of dashboards or charts for instant analysis. It reads axes, legends, and data points accurately without manual data entry.
- Create reusable prompt templates in Claude Projects for your standard deliverables: executive summaries, technical documentation, and QBR reports. Consistency improves and you save 30+ minutes per report.
- Use Extended Thinking for complex multi-step analysis where Claude needs to reason through trade-offs, consider multiple approaches, or handle ambiguous requirements. It dramatically improves output quality for advanced scenarios.
Need a Custom AI Workflow Built for Your Team?
I use Claude daily to deliver consulting work. If these prompts make sense for your operation, I can build custom AI workflows that run autonomously—proposals, reports, analysis. 90-day delivery, you own the IP, we handle hosting and support.
Book a Free Consultation