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 marketing analyst evaluating marketing automation performance.

## Task
Analyze key metricsβ€”open rates, click-through rates, conversion rates, and ROIβ€”and provide actionable insights. Compare actual performance against goals, identify trends, anomalies, and optimization opportunities.

## Context
**Campaign:** {{campaign-name}}
**Goals & audience:** {{campaign-goals-and-audience}}
**Industry & timeframe:** {{industry-and-timeframe}}

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

| Metric | Goal | Actual | Insights |
|--------|------|--------|----------|

For each metric row, provide:
- **Metric**: The KPI name (Open Rate, Click-Through Rate, Conversion Rate, ROI)
- **Goal**: The target value
- **Actual**: The observed result
- **Insights**: Concise analysis noting whether the metric met/missed the goal, any trends or anomalies, and one 

Marketing Automation Metrics Analysis Prompt

Generates a structured performance analysis of marketing automation campaigns by comparing key metrics - open rates, CTR, conversion rates, and ROI - against goals and delivering actionable insights. Runs on ChatGPT, Claude, Gemini, and Grok.

41
## Role
You are a data scientist and business strategist specializing in churn analysis and customer retention.

## Task
Perform a comprehensive churn analysis using the provided dataset. Identify key drivers of customer attrition, at-risk segments, and develop actionable retention strategies with measurable outcomes.

## Context
{{churn-dataset}}

## Analysis Requirements
- Apply statistical techniques to uncover patterns and causal factors in customer churn
- Quantify the impact of each churn driver with percentage contribution
- Define customer segments by churn risk level with associated probabilities
- Ground all findings in the data provided and industry best practices

## Output
Deliver your analysis in this structure:

**Data Sources:**
● List all datasets and sources used in the analysis

**Churn Analysis:**

Key Churn Drivers:
1. Driver name (percentage impact%)
2. Driver name 

Churn Analysis and Retention Strategy Prompt

Generates a data-driven churn analysis with at-risk customer segments, quantified churn drivers, and actionable retention strategies complete with implementation steps. Runs on ChatGPT, Claude, and other text models.

41

Customer Segmentation by Purchase Behavior Prompt

Analyzes purchase data to identify distinct customer segments based on buying patterns, demographics, and order values. Outputs a structured markdown table for ChatGPT, Claude, or Gemini.

41

ARIMA Model Accuracy Evaluation for Time Series

Evaluates ARIMA model performance on time series forecasts, stress-testing against seasonal shifts, structural breaks, and bounded data challenges. Runs on ChatGPT, Claude, Gemini, and Grok.

41

Website Traffic Analysis Optimization Prompt

Generates a structured web analytics report with user behavior insights and prioritized optimization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok to deliver data-backed strategies for improving site performance and user experience.

41
## Role
You are a financial analyst specializing in sales initiative performance measurement.

## Task
Calculate and present the Return on Investment (ROI) for a sales initiative using provided financial data.

## Context
Analyze the following:
- Sales initiative: {{sales-initiative}}
- Revenue generated: {{revenue-generated}}
- Cost of implementation: {{cost-of-implementation}}
- Customer acquisition cost: {{customer-acquisition-cost}}
- Analysis timeframe: {{timeframe}}

Calculate ROI percentage for each relevant metric using standard financial formulas: ROI = ((Revenue - Cost) / Cost) Γ— 100.

## Output
Deliver your analysis as:

1. **Markdown table** with three columns:
   - Metric (e.g., Overall Initiative ROI, Customer Acquisition Efficiency)
   - Value (dollar amounts or key figures)
   - ROI Percentage

2. **Summary section** below the table containing:
   - Overall ROI assessment

Sales Initiative ROI Calculator Prompt

Generates a structured ROI analysis for sales initiatives, calculating percentages across revenue, costs, and customer acquisition metrics. Runs on ChatGPT, Claude, Gemini, and Grok.

40
## Role
You are an expert sales analyst evaluating pipeline performance and identifying improvement opportunities.

## Task
Analyze key sales metrics and deliver a structured health check of the sales process. Focus on conversion rates, lead velocity, and average deal size. Set realistic targets for each metric and provide actionable recommendations to optimize the pipeline and drive revenue growth.

## Context
{{sales-context}}

*Describe your sales process, industry, and current performance (include conversion rates, deal flow, revenue trends, team size, sales cycle length, and any challenges you're facing).*

## Output
Deliver your analysis as:

1. **Metrics table** with three columns:
   - Metric
   - Current Performance
   - Target

2. **Recommendations** as a bullet-point list of specific, actionable improvements prioritized by impact.

Sales Pipeline Metrics Health Check Prompt

Analyzes conversion rates, lead velocity, and deal size to diagnose sales pipeline performance and recommend targeted improvements. Runs on ChatGPT, Claude, Gemini, and Grok.

40

Inventory Report Generator for Stock Analysis

Generates detailed inventory reports showing stock levels, product movement, and key metrics in markdown tables with actionable insights. Runs on ChatGPT, Claude, Gemini, and Grok.

40

Churn Prediction and Retention Plan Prompt

Generates a multi-signal churn prediction model and tiered retention strategy based on your business context. Runs on ChatGPT, Claude, Gemini, and Grok to deliver actionable customer retention plans.

39
## Role

You are an organizational wellness analyst who translates employee sentiment data into business intelligence. You interpret emotional well-being metrics through the OECD Better Life Index framework (work-life balance, relationships, emotional well-being) and connect them to concrete business outcomes like retention, productivity, and innovation.

## Task

Analyze the provided employee data and produce a structured Happiness Index Report that reveals both surface satisfaction scores and deeper patterns predicting business risk. Transform qualitative sentiment into quantitative metrics, identify organization-specific happiness drivers and detractors, and recommend evidence-based interventions prioritized by impact and feasibility.

## Context

{{employee-data}}

{{organization-context}}

## Output

Deliver a report with these sections:

**Executive Summary**  
Provide the overall 

Employee Happiness Index Report Generator

Generates a structured organizational wellness report that translates employee sentiment data into business intelligence through the OECD Better Life Index framework. Runs on ChatGPT, Claude, Gemini, and Grok.

39
## Role
You are a workforce analytics specialist who transforms exit interview data into strategic intelligence, combining rigorous data analysis with visual storytelling to expose turnover patterns that standard HR metrics miss.

## Task
Create a comprehensive Exit Trend Report that reveals root causes of employee turnover and translates complex workforce data into executive-ready insights. Connect exit patterns to business impact and provide data-backed retention recommendations.

## Context
{{organizational-context}}

{{exit-data-sources}}

## Output
Structure the Exit Trend Report with these components:

**EXECUTIVE DASHBOARD**
- One-page visual summary with traffic light indicators for key metrics
- Top 3 turnover drivers with quantified business impact
- Trend arrows showing 3-month, 6-month, and 12-month directional movement

**DETAILED ANALYSIS SECTIONS**

1. **Turnover Overview*

Exit Trend Report Generator for Workforce Analytics

Generates executive-ready exit trend reports that transform employee turnover data into strategic intelligence with root cause analysis, predictive indicators, and retention recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

38

Regression Analysis Prompt for Business Data

Performs thorough regression analysis on business datasets to quantify relationships between variables and generate actionable insights. Runs on ChatGPT, Claude, and other text models.

38

Survey Feedback Standardization Script Builder

Generates a complete data standardization script that unifies Likert-scale feedback across multiple survey formats, including auto-detection, mapping logic, and audit trails. Runs on ChatGPT, Claude, Gemini, and Grok.

38

Text Sentiment Analysis Tutorial Prompt

Generates a step-by-step tutorial that teaches users how to accurately identify positive, negative, or neutral sentiment in any text. Runs on ChatGPT, Claude, Gemini, and Grok.

38
## Role
You are an expert data visualization specialist designing real-time sales dashboards.

## Task
Create an effective dashboard that tracks key performance indicators for a sales operations team. Design a structured table layout that clearly presents each KPI with its current value, target value, and variance.

## Context
Sales operations team: {{team-context}}

Key performance indicators to track: {{kpis}}

## Output
Deliver a complete dashboard design that includes:

1. **KPI Table Structure** - A markdown table with columns for: KPI name, current value, target value, variance (absolute and percentage), and status indicator

2. **Visual Design Recommendations**
   - Color coding scheme for performance levels (red/yellow/green thresholds)
   - Icon or emoji indicators for at-a-glance status assessment
   - Formatting conventions for positive/negative variances

3. **Technical Speci

Real-Time Sales Dashboard Builder Prompt

Generates a complete real-time sales dashboard design with KPI tracking tables, visual design recommendations, and technical specifications. Runs on ChatGPT, Claude, and Gemini to produce structured markdown dashboards with color coding, variance analysis, and refresh-rate guidelines.

38
## Role
You are an expert Data Scientist specializing in Natural Language Processing (NLP), focused on building sentiment analysis models to interpret customer opinions and feedback.

## Task
Guide the user through developing a complete sentiment analysis model, from data collection through deployment and maintenance.

## Context
Data source: {{data-source}}
Programming language: {{programming-language}}
System specifications: {{system-specifications}}

## Output
Provide a step-by-step implementation guide using bullet points for clarity. Include code snippets in separate blocks.

Cover these phases:

**1. Data Collection**
● Explain the importance of gathering relevant, sufficient customer feedback data
● Describe methods for accessing and extracting data from the specified source
● Recommend dataset size and diversity requirements

**2. Data Preprocessing**
● Text cleaning (removing no

Sentiment Analysis Model Builder for NLP Projects

Builds a complete sentiment analysis model from data collection through deployment, with step-by-step guidance, code snippets, and library recommendations. Runs on ChatGPT, Claude, and Gemini for Python, R, or other programming languages.

38

Sales Data Analysis Prompt for Actionable Insights

Analyzes sales data to uncover trends, patterns, and anomalies, then generates specific recommendations and action items to improve KPIs. Outputs a structured markdown table for ChatGPT, Claude, or Gemini.

38

Email Marketing Metrics Analysis Prompt

Generates a structured performance analysis of email campaign metrics including open rates, CTR, conversions, and unsubscribes, delivered as a markdown table with actionable improvement strategies. Runs on ChatGPT, Claude, Gemini, and Grok.

37
## Role
You are a productivity analyst with expertise in team performance measurement, data-driven insights, and operational optimization.

## Task
Analyze team productivity trends and deliver a comprehensive report with actionable recommendations to improve efficiency and output.

## Context
Team: {{team-context}}

Focus on quantitative metrics (task completion rates, time-to-completion, output quality) and qualitative data (team feedback, performance reviews). Analyze trends over time, comparing performance against industry benchmarks and organizational goals. Consider external factors affecting productivity (tool changes, process shifts, workload variations). Ensure all recommendations follow SMART criteria (specific, measurable, achievable, relevant, time-bound). Avoid assumptions without data-backed evidence.

## Output
Deliver your analysis in this structure:

**Executive Summary**

Team Productivity Trends Analysis Report Prompt

Generates a comprehensive productivity analysis report with data-driven insights, trend visualizations, and SMART recommendations for improving team efficiency. Runs on ChatGPT, Claude, and Gemini.

37
## Role
You are a decision architecture specialist who helps organizations choose AI models by balancing performance, interpretability, and accountability. Your approach emerged from witnessing how opaque algorithms fail catastrophically when stakeholders cannot understand or trust them, even when technically accurate.

## Context
Organizations face mounting pressure to deploy AI while stakeholders demand both accuracy and accountability. The tension between interpretability and performance determines whether solutions get approved, adopted, or abandoned. Regulatory scrutiny intensifies, public trust erodes with each AI mishap, and model choice carries legal liability and competitive consequences.

## Task
Provide a structured analysis comparing simple interpretable models versus complex high-performance models for the given context:

{{business-context}}

Include:

**Framework**: Map mo

AI Model Tradeoff Analysis Prompt

Generates a structured comparison of interpretable versus complex AI models, balancing performance, accountability, and organizational constraints. Runs on ChatGPT, Claude, Gemini, and Grok.

37

Data Import Template Generator for Databases

Generates validated data import templates that transform external files into clean database records with built-in error handling and corruption prevention. Runs on ChatGPT, Claude, Gemini, and Grok.

37

Customer Segmentation Strategy for CRM Outreach

Generates a structured customer segmentation plan with tailored outreach strategies for each segment based on your CRM data. Runs on ChatGPT, Claude, and Gemini to help CRM teams design targeted engagement campaigns.

37

Line Chart Generator Prompt for Data Visualization

Generates complete, runnable code to build publication-quality line charts from raw datasets, with data cleaning, perceptually optimized design, and analytical overlays. Runs on ChatGPT, Claude, Gemini, and Grok.

37
## Role
You are a data analyst specializing in market basket analysis. Your task is to identify cross-selling and upselling opportunities by analyzing customer purchase patterns and product co-occurrence in transactions.

## Context
You will analyze transaction data to uncover relationships between products that customers frequently buy together. These insights enable strategic product placement in marketing campaigns, recommendation engines, and store layouts to increase sales.

**Business context:** {{business-context}}
(Your business type, current marketing strategies, product categories of interest, and customer segments to focus on.)

**Transaction data:** {{transaction-data}}
(Your dataset with transaction IDs and purchased products, or a description of the data source and time period covered.)

## Task

1. **Prepare the data:** Ensure it includes transaction IDs and products purch

Market Basket Analysis Prompt for Cross-Selling

Generates actionable product association insights by analyzing transaction data to uncover cross-selling and upselling opportunities. Runs on ChatGPT, Claude, and Gemini.

37

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: "Marketing Automation Metrics Analysis Prompt", "Churn Analysis and Retention Strategy Prompt", "Customer Segmentation by Purchase Behavior Prompt".

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.