253 AI Prompts for Data Analysis

The best Data Analysis prompts across 7 subcategories. Tested on ChatGPT, Claude, Gemini and every major model.

Browse the prompts

## Role
You are an expert financial analyst creating comprehensive sales reports that deliver actionable insights into company performance.

## Task
Generate a detailed sales report for {{company-name}} covering {{timeframe}}. Analyze key metrics including revenue, profit margins, customer acquisition costs, and sales growth. Focus on {{industry-context}} dynamics and any additional performance indicators relevant to the business. Tailor the analysis and commentary for {{target-audience}}.

## Output
Present the report as a markdown table with 5 columns:
- Date
- Revenue
- Profit Margin
- Customer Acquisition Cost
- Sales Growth %

Below the table, provide a concise analysis that interprets trends, highlights significant changes, and identifies actionable insights for decision-making.

Sales Report Generator for Revenue and Profit Analysis

Generates detailed sales reports with markdown tables tracking revenue, profit margins, customer acquisition costs, and sales growth over custom timeframes. Runs on ChatGPT, Claude, and Gemini.

47
## Role

You are a Statistical Visualization Architect specializing in histogram creation and distribution analysis. Guide users through building meaningful histograms that reveal the true nature of their data distributions.

## Task

Create an optimal histogram for the user's dataset through a structured, adaptive process:

1. **Data Discovery**: Understand the dataset, target variable, analytical goals, and user's statistical knowledge level
2. **Parameter Optimization**: Calculate optimal bin count (Sturges' rule: ⌈log₂(n) + 1⌉), evaluate data range and density, identify outliers, recommend overlays (density curves, mean/median markers)
3. **Implementation**: Provide clean, executable code with automatic bin calculation, proper labeling, statistical annotations, and edge-case handling
4. **Interpretation**: Analyze distribution shape (normal/skewed/multimodal/uniform), central tendenc

Histogram Generator With Code

Generates optimized histogram visualizations with executable code, statistical overlays, and distribution analysis tailored to your dataset and expertise level. Runs on ChatGPT, Claude, and other text models that execute Python, R, or JavaScript.

46

Data Structure Inspection Prompt for Python and R

Generates executable code and analysis to reveal dataset dimensions, column types, missing values, and data quality issues. Runs on ChatGPT, Claude, Gemini, and Grok for text-based output.

46

Customer Lifetime Value Analysis Prompt

Generates customer lifetime value (CLV) calculations across segments, identifies high-value patterns, and delivers strategic sales recommendations in a markdown table format. Runs on ChatGPT, Claude, Gemini, and Grok.

46

Customer Behavior Analysis Prompt for E-Commerce Data

Generates a comprehensive customer behavior analysis report that reveals purchasing patterns, conversion bottlenecks, and segment insights from e-commerce data. Runs on ChatGPT, Claude, Gemini, and Grok to deliver actionable recommendations with visualizations.

46
## Role
You are an Excel formula expert specializing in advanced functions, array formulas, and nested logic to solve complex spreadsheet problems.

## Task
Help the user build a working Excel formula that solves their specific problem. First, ask clarifying questions to understand:

- The exact problem or desired outcome
- Cell ranges, worksheet structure, and data layout
- Any conditions, criteria, or logical rules the formula must handle
- Where the output should appear and how it should be formatted

Then provide a complete, working formula tailored to their scenario.

## Context
{{problem-description}}

## Output
Structure your response with these sections:

**Formula:** Present the complete working formula in a code block.

**How it works:** Break down each major component of the formula and explain what it does.

**Advanced features used:** Identify any specialized Excel functions

Excel Formula Generator for Complex Spreadsheet Problems

Generates custom Excel formulas with step-by-step breakdowns for advanced spreadsheet challenges. Runs on ChatGPT, Claude, and Gemini to solve nested logic, array formulas, and multi-condition calculations.

46
## Role
You are a social media analytics expert analyzing performance metrics and delivering strategic recommendations.

## Task
Analyze the provided social media metrics across platforms, identify trends and patterns, and formulate actionable recommendations aligned with business goals and industry best practices.

## Context
Business: {{business-name}}
Platforms and metrics: {{platforms-and-metrics}}
Business goals: {{social-media-goals}}

## Process
1. Examine each platform's metrics for patterns, anomalies, and performance trends
2. Compare performance against typical benchmarks for the industry
3. Identify strengths to leverage and weaknesses to address
4. Develop specific, actionable recommendations tied to the stated business goals

## Output
Present your analysis as a markdown table with these columns:
- **Platform** – the social media channel
- **Metric** – the specific KPI anal

Social Media Metrics Analysis Prompt

Generates a structured analysis of social media performance across platforms, identifying trends and delivering actionable recommendations in a markdown table format. Runs on ChatGPT, Claude, Gemini, and Grok.

45

Employee Exit Data Analysis Prompt

Generates a comprehensive workforce analytics report that uncovers hidden turnover patterns, root causes, and retention strategies by analyzing HR exit data. Runs on ChatGPT, Claude, Gemini, and Grok.

45

Visual Communication Strategy Builder for Complex Data

Generates a structured visual communication strategy that transforms complex information into infographics, charts, and diagrams tailored to your target audience. Runs on ChatGPT, Claude, Gemini, and Grok.

45
Design an ultra-premium facial aesthetics analysis report with a luxury editorial interface. The layout should evoke high-end beauty magazines and Apple-style UI refinement: monochrome black and white palette, thin elegant divider lines, soft rounded cards with subtle shadows, spacious breathing room, and sophisticated typography.

The report must include these analytical components in a highly organized dashboard layout:

**Visual Analysis Section:**
- Clean contour line-art interpretation of the facial structure (simplified, geometric, professional)
- Face shape classification with elegant label
- Facial symmetry analysis visualization

**Proportional Metrics:**
- Eyes, nose, jawline, lips, and forehead measurements presented as refined data points or minimal bar charts
- Skin texture observations in concise clinical language

**Recommendations Panel:**
- Hairstyle compatibility sugges

Facial Aesthetics Analysis Report

Generate an ultra-premium facial aesthetics analysis report with a high-end beauty magazine aesthetic, focusing on visual and proportional analysis.

45
## Role
You are an ROI analyst specializing in employee engagement program measurement. You apply Jack Phillips' five-level ROI framework to quantify both financial returns and cultural value in formats executives and CFOs require.

## Task
Calculate comprehensive ROI for an engagement program by:

- Applying Phillips' five-level framework: Level 1 (Reaction & Satisfaction), Level 2 (Learning & Confidence), Level 3 (Application & Implementation), Level 4 (Impact & Consequences), Level 5 (ROI & Intangible Benefits)
- Calculating total program costs: direct expenses, participant time, opportunity costs
- Isolating program effects from other variables using control groups, trend analysis, or expert estimation
- Converting business impact to monetary values using standard values, expert input, or external databases
- Presenting findings with confidence intervals and sensitivity analysis
- Pr

Engagement Program ROI Calculator

Calculates financial returns and cultural value of employee engagement programs using Jack Phillips' five-level ROI framework, producing executive summaries with cost analysis, benefit quantification, and confidence intervals. Runs on ChatGPT, Claude, Gemini, and Grok.

45

Partner Incentive Tracker Spreadsheet Builder

Generates a structured partner incentive tracking table with conditional formatting rules for monitoring sales volume, customer acquisition, and revenue growth targets. Runs on ChatGPT, Claude, and Gemini.

45

Sales Forecasting Model Builder for Predictive Analytics

Designs a complete sales forecasting model architecture using historical data, market variables, and modern algorithms like time-series models and neural networks. Runs on ChatGPT, Claude, Gemini, and Grok.

45

SQL Query Optimization Prompt for Database Performance

Guides you through creating optimized SQL queries using Baron Schwartz's principles, adapting from 3 to 15 phases based on complexity. Runs on ChatGPT, Claude, Gemini, and Grok to analyze schemas, design efficient joins, and improve query performance across MySQL, PostgreSQL, SQL Server, and Oracle.

45
## Role
You are a data transformation specialist focused on revealing critical patterns through systematic sorting. You prioritize proper data arrangement over complex algorithms, knowing that viewing sorted extremes—highest and lowest values—exposes rankings, distributions, and outliers that drive strategic decisions.

## Task
Generate clear, executable Python code using pandas to sort the user's dataset and reveal immediate visual insights. Guide the user through:

1. **Data Understanding**: Confirm the dataset structure and identify key columns
2. **Sorting Strategy**: Clarify which columns to sort by and in what order (ascending/descending)
3. **Code Generation**: Provide copy-paste-ready pandas code with error handling for missing values and data type mismatches
4. **Results Display**: Show at least 5 rows from both the top and bottom of the sorted data
5. **Insight Extraction**: Ex

Sort Data Columns With Pandas Python Generator

Generates executable Python pandas code that sorts datasets by specified columns and displays top/bottom rows to reveal rankings, outliers, and distributions. Runs on ChatGPT, Claude, Gemini, and Grok.

44
## Role
You are an expert social media analyst evaluating the return on investment (ROI) of social media efforts in driving sales.

## Task
Analyze social media metrics and present a comprehensive ROI assessment. Identify key metrics relevant to the business context, define each metric clearly, and explain how it impacts sales. Provide actionable insights for optimizing social media strategies to boost sales performance.

## Context
Business context: {{business-context}}

Consider platform-specific metrics (engagement rate, reach, impressions, click-through rate, conversion rate, customer acquisition cost, lifetime value, share of voice), content performance indicators, audience behavior patterns, and the sales funnel stages from awareness to conversion.

## Output
Deliver your analysis as a markdown table with three columns:

| Metric | Definition | Impact on Sales |
|--------|---------

Social Media ROI Metrics Analysis Prompt

Generates a structured ROI assessment of social media performance with key metrics, definitions, and sales impact analysis. Runs on ChatGPT, Claude, Gemini, and Grok to deliver a markdown table plus prioritized optimization recommendations.

44

Misleading Data Visualization Detection Prompt

Identifies and prevents misleading charts and graphs that distort business decisions. Runs on ChatGPT, Claude, Gemini, and Grok to audit visualization design choices and provide prevention strategies for both intentional manipulation and unintentional bias.

44

Heatmap Generation Prompt With Code Strategy

Generates a systematic heatmap visualization strategy that transforms structured datasets into color-encoded patterns revealing hidden relationships. Runs on ChatGPT, Claude, Gemini, and Grok.

44
## Role

You are an expert data visualization architect specializing in clear, truthful statistical graphics. Your approach prioritizes simplicity and insight—making complex distributions immediately understandable through well-crafted box plots.

## Task

Guide the user through creating professional box plots with clean, commented code. Adapt your response structure and depth based on their dataset complexity, statistical fluency, and visualization goals.

## Context

The user needs help visualizing distribution data:

{{dataset-and-goal}}

*Describe your dataset (format, structure, size), the main story or comparison the visualization should reveal, your programming language preference (Python, R, JavaScript, etc.), your statistical background level (beginner / intermediate / advanced), and intended use (exploratory analysis / presentation / publication).*

## Approach

Before generati

Box Plot Code Generator for Data Visualization

Generates clean, commented code to create professional box plots that reveal distribution patterns and outliers. Runs on ChatGPT, Claude, and other text models, adapting complexity to your dataset size and statistical background.

43
## Role
You are an expert sales analyst conducting accurate sales forecasting through structured data analysis.

## Task
Analyze historical data, market trends, and customer insights to project future sales. Examine past sales patterns, identify seasonality, evaluate current market conditions and emerging trends, and incorporate customer behavior insights to refine projections. Develop strategies to capitalize on opportunities and mitigate risks.

## Context
**Product/Service:** {{product-service}}

**Forecasting Period:** {{time-period}}

**Business Intelligence:**
{{business-intelligence}}

*Include: key market factors, primary customer segments, and a brief summary of historical sales data (trends, growth patterns, seasonal variations).*

## Output
Present your forecast as a markdown table with 4 columns:

| Time Period | Projected Sales | Influencing Factors | Strategies |
|---------

Sales Forecasting Prompt for ChatGPT

Generates structured sales projections by analyzing historical data, market trends, and customer behavior. Outputs a markdown table with period-by-period forecasts, influencing factors, and actionable strategies for ChatGPT, Claude, and Gemini.

43

Remove Duplicate Rows – Python Pandas Data Cleaning

Generates executable Python code that detects, analyzes, and removes duplicate records from datasets using pandas. Runs on ChatGPT, Claude, Gemini, and other text models.

43

Sales Pipeline Opportunity Analysis Prompt

Generates a prioritized table of revenue opportunities from your sales pipeline, with impact estimates, probability scores, and implementation strategies. Runs on ChatGPT, Claude, Gemini, and Grok.

43

Workout Performance Data Analysis Prompt

Generates a structured fitness progress report with trends, strengths, weaknesses, and personalized training recommendations based on your workout logs. Runs on ChatGPT, Claude, Gemini, and Grok.

42
## Role
You are an expert digital marketing analyst evaluating ad campaign performance.

## Task
Analyze the effectiveness of a digital marketing campaign across multiple channels. Focus on key metrics (impressions, clicks, conversions), identify strengths and weaknesses of each channel, surface trends, and recommend improvements.

## Context
{{campaign-details}}

## Output
**Performance Table:**
Present your analysis as a markdown table with these columns:
- Channel
- Impressions
- Clicks
- Conversions

**Key Findings & Recommendations:**
Following the table, provide bullet-point summary of:
- Primary strengths and weaknesses by channel
- Notable trends
- Concrete recommendations for optimization

Ad Performance Analysis Prompt for Multi-Channel Campaigns

Generates a structured performance analysis of digital ad campaigns across multiple channels, evaluating impressions, clicks, and conversions with actionable optimization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

41

What are AI prompts for Data Analysis?

AI prompts for Data Analysis are engineered instructions that already work. These are not one-line questions. Each one fixes the role, the context, the task and the output format before you type a word, so you get a usable result on the first run instead of the fourth.

They cover the work Data Analysis actually get asked for: research and briefs, copy and content, analysis and reporting, planning, outreach and the admin that eats the day. Open a card to see the full prompt and the output it returns.

The deepest areas here: Data Insights (88 prompts), Reporting & Dashboards (64 prompts), Data Visualization (28 prompts), Data Cleaning (26 prompts), Spreadsheets & Formulas (18 prompts).

Popular on this page right now: "Sales Report Generator for Revenue and Profit Analysis", "Histogram Generator With Code", "Data Structure Inspection Prompt for Python and R".

253 on this page, every one scoped to Data Analysis. Free to read, free to copy.

Why these prompts work for Data Analysis

A weak prompt costs you the hour you were trying to save: you rewrite it three times, get something generic, then finish the job by hand. An engineered prompt front-loads that thinking once.

In Data Analysis that means first drafts you can send, analysis you can act on, and the repetitive work handed off, so the time goes into judgement instead of typing.

Every prompt here was written for a real job and tested against the models people actually use. Nothing scraped from a thread.

How to use these prompts

Open a prompt, copy it, and replace the [bracketed] variables with your own product, audience or topic. The structure around them stays as is. That structure is the part doing the work.

Paste it into ChatGPT, Claude, Gemini, Grok or the model you already use. If the output drifts, tighten the context line instead of rewriting the whole prompt.

No account needed to copy one. No setup, no extension, nothing to install.

Which AI tool works best for Data Analysis prompts?

Text prompts here run well in ChatGPT, Claude, Gemini and Grok; image prompts target Midjourney and Nano Banana. Each card lists the models it was tested with.

Are these AI prompts free to use?

A big part of the library is free: open a prompt, copy it, use it. Premium packs and the Complete AI Bundle unlock the full collection with lifetime updates.

How do I adapt these prompts to my use case?

Start with the [variables]: niche, audience, constraints. If the result still misses, add one example of the output you want. A single good example beats three extra instructions.

For a prompt built from scratch, the Start Now card above opens the custom prompt generator.

Related resources

Get smarter on AI every week

One email a week with the best new prompts, tools, and model updates. Unsubscribe anytime.

Join 100,000+ subscribers. One email a week, real prompts, tools, and model updates. Unsubscribe anytime.