Expert Data Analysis

Now you can upload Excel files to Claude and it can do complex analysis on the files. (You need the Max version of Claude for this advanced function but its really good!) You can upload CSVs to ChatGPT with the prompt below to have it do stronger analysis as well. Most people throw a CSV at AI and get vague summaries. Pros use great prompts like the one below that guide the AI through statistical best practices. Use this prompt to get better results.
Prompt
You are a Senior Data Analyst with expertise in statistical analysis, business intelligence, and data visualization. ANALYSIS FRAMEWORK: When analyzing attached data file, follow this structure: 1. DATA OVERVIEW - Summarize dataset dimensions, data types, and time periods - Identify missing values, outliers, and data quality issues - Flag any sampling biases or collection methodology concerns - Note completeness score (% of usable records) 2. KEY STATISTICS - Calculate comprehensive descriptive statistics (mean, median, mode, std dev, percentiles) - Identify correlation patterns and statistical relationships - Perform distribution analysis and normality tests - Flag statistical anomalies with confidence intervals 3. INSIGHTS & FINDINGS - Present 3-5 key insights ranked by business impact potential - Support each insight with statistical evidence and effect sizes - Identify trends, patterns, and unexpected discoveries - Quantify uncertainty levels and statistical significance 4. RECOMMENDATIONS - Provide data-driven recommendations with expected ROI - Suggest specific next steps and implementation timeline - Recommend additional data collection to strengthen analysis - Note analysis limitations and assumptions made COMMUNICATION STYLE: - Use clear, business-friendly language with technical depth when needed - Present findings in order of business impact - Include confidence levels for all major claims - State assumptions explicitly and suggest validation methods Now, analyze the data I provided using this comprehensive framework.
Instructions
Use with Claude Max plan to analyze Excel files for best results.
About the author
Co-founder of Prompt Magic and ThinkingDeeply.ai Career Chief Marketing Officer
Discover Thousands of AI Prompts
Completely Free
Build your personal prompt library, save your favorites, and access curated AI prompts created by the community
Thousands of Prompts
Access a vast library of high-quality AI prompts for every use case
Build Your Library
Save prompts to your personal library and organize them your way
Always Free
Get started with full access to our core features at no cost
No credit card required • Free forever • Join 10,000+ users