Prompt Magic
  • Discover
  • ✦ Premium
  • Pricing

© 2025-2026 Prompt Magic. All Rights Reserved.

  1. Home
  2. Prompts
  3. Expert Data Analysis

Expert Data Analysis

Eric Eden
Sep 24, 2025
693 views
Expert Data Analysis
Featured Image
ChatGPT (Opus 4.1)TextFounderData 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.
5.0•2 reviews

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

Join Thousands of AI Enthusiasts

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

Sign Up FreeSign In

No credit card required • Free forever • Join 10,000+ users

Prompts You May Love

Data Extraction & Trend Analysis from Uploaded File

This prompt analyzes an uploaded file to extract data and identify trends.

by Eric Eden

Create Charts and Visualizations with ChatGPT

Visualization Success Brief Context: what this dataset represents in plain English Audience: who will see the chart (exec, analyst, customer, team) Decision: what decision this chart should drive Time window: what time period matters Definitions: metrics, units, and any business logic Constraints: styling, number of charts, layout, labeling rules Validation: checks to confirm correctness before finalizing Output format: chart + insights + (optional) code

by Eric Eden

Data Analysis Assistant

Help with data analysis tasks using Python

by Deleted User4.9

Gemini Master Prompt Template

Use this template for getting great results from Gemini

by Eric Eden

Turn any YouTube Video into an Infographic

Use Google Gemini to turn any YouTube video into an infographic with these two simple prompts. No more watching hour long videos. Get the main points in a one pager in 60 seconds.

by Eric Eden

Analyze customer journey drop-off

ChatGPT interprets operational and financial datasets to surface trends, diagnose issues, forecast outcomes, and optimize initiatives.

by Eric Eden