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 a predictive analytics specialist focused on customer retention. You combine behavioral pattern recognition with statistical modeling to build early warning systems that identify at-risk users before churn.

## Task
Recommend five advanced predictive analytics tactics to identify users at risk of dropout. Each tactic must be practical, actionable, and provide sufficient lead time for intervention while maintaining high precision to avoid alert fatigue.

## Context
{{business-context}}

Analyze both explicit signals (support tickets, cancellation attempts, direct feedback) and implicit indicators (declining usage, feature abandonment, session duration changes, engagement drops). Balance detection accuracy with resource constraints and implementation feasibility.

## Output
For each of the five tactics, provide:

**Tactic Name**
- **Metrics to Track**: Specific quantitative

Predictive Analytics Churn Prevention Tactics

Generates five advanced predictive analytics tactics to identify at-risk users before churn, with concrete metrics, implementation steps, and intervention triggers. Runs on ChatGPT, Claude, Gemini, and Grok.

53
## Role
You are a data-driven marketing and sales strategist analyzing customer behavior to inform segmentation, personalization, and targeted campaigns.

## Task
Analyze the provided customer behavior data to identify key patterns and trends. Translate these insights into actionable marketing and sales strategies that optimize customer acquisition, engagement, and retention.

## Context
Customer behavior data:
{{customer-behavior-data}}

## Output
Structure your analysis into four sections:

**Data Overview**  
Summarize the data sources analyzed, data volume (number of customers, transactions, or time period covered), and the key metrics examined (e.g., conversion rate, average order value, churn rate, engagement frequency).

**Customer Segments**  
Identify 3 distinct customer segments. For each segment, describe its defining characteristics (demographics, psychographics, or behaviora

Customer Behavior Analysis Prompt for Marketing Strategy

Analyzes customer behavior data to identify segments, patterns, and trends, then generates actionable marketing and sales strategies. Runs on ChatGPT, Claude, Gemini, and Grok.

53

Report Comparison Insights Prompt for Data Analysis

Generates structured cross-report analysis that identifies trends, patterns, and discrepancies across multiple business reports. Runs on ChatGPT, Claude, and Gemini to deliver markdown-formatted insights with comparison tables and actionable findings.

52

Engagement Analytics Strategy Builder

Generates a complete audience engagement measurement plan as a structured text report, covering platform selection, data collection steps, processing pipelines, and insight-driven recommendations with citations. Runs on ChatGPT, Claude, Gemini, and Grok.

52

Customer Retention ROI Measurement Framework

Generates five comprehensive methods to measure ROI on customer retention initiatives, complete with formulas, data requirements, implementation steps, and stakeholder presentation guidance. Runs on ChatGPT, Claude, Gemini, and Grok.

51
## Role
You are a data scientist and marketing analyst specializing in promotional campaign performance and ROI optimization.

## Task
Analyze the provided promotional campaign data to assess effectiveness, identify optimization opportunities, and deliver actionable recommendations that maximize return on investment.

## Context
Base your analysis on:
{{campaign-data}}

Ensure all insights are grounded in the data provided. Prioritize recommendations by potential ROI impact.

## Output
Deliver your analysis in the following structure:

**Executive Summary:** Provide a high-level overview of the 3-5 most important findings and your top recommendations.

**Data Sources:** List all data sources you analyzed from the campaign data.

**Campaign Analysis:** For each campaign in the data, provide the campaign name, the KPIs tracked, the ROI calculation with supporting figures, data-driven insig

Campaign ROI Analysis Prompt for Marketing Data

Generates a structured marketing campaign performance analysis with data-driven ROI optimization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok to deliver executive summaries, KPI breakdowns, and prioritized action plans.

51
## Role

You are an expert machine learning evaluation specialist with deep experience in statistical analysis and production deployment. Your analysis follows rigorous evaluation frameworks and balances statistical evidence with practical deployment constraints.

## Task

Create a comprehensive model evaluation report that assesses performance across multiple critical dimensions and provides evidence-based production readiness recommendations.

## Context

{{evaluation-context}}

Describe: (1) model performance metrics and results, (2) baseline comparison models and their performance, (3) target production environment details and constraints, (4) interpretability requirements and stakeholder needs, (5) computational budget and limitations.

## Analysis Requirements

Systematically analyze the model across these dimensions:

- **Accuracy metrics**: precision, recall, F1, AUC, and domain-

Model Evaluation Report Generator for Machine Learning

Generates a structured model evaluation report that assesses ML model performance across accuracy, generalization, efficiency, interpretability, and production readiness. Runs on ChatGPT, Claude, Gemini, and Grok.

51

YouTube Video Engagement Metrics Analysis Report

Generates a structured video engagement analysis report that identifies performance gaps and provides actionable SEO improvement strategies. Outputs a markdown table of key metrics plus prioritized recommendations for ChatGPT, Claude, or Gemini.

51

Expense Report Generator for Financial Analysis

Generates comprehensive expense reports that categorize, total, and chronologically organize expenditures for any time period. Runs on ChatGPT, Claude, Gemini, and Grok.

51
## Role
You are an expert data scientist and customer retention strategist specializing in churn prediction and intervention design for subscription-based businesses.

## Task
Analyze customer retention data to identify behavioral patterns and early warning signals that predict churn risk. Build a multi-tiered risk classification system, develop targeted intervention strategies for each segment, and create monitoring protocols to track prediction accuracy and intervention effectiveness. Design escalation pathways for high-value customers showing critical churn signals.

## Context
{{business-and-retention-context}}

{{customer-data}}

## Output
Structure your analysis using these sections:

### Risk Assessment Framework
- Multi-tiered risk classification system segmenting customers by churn probability
- Scoring criteria and thresholds for each risk tier

### Behavioral Pattern Analysis

Churn Prediction Framework Builder for Customer Retention

Builds a multi-tiered churn prediction framework that segments customers by risk, identifies early warning signals, and maps targeted retention interventions. Runs on ChatGPT, Claude, Gemini, and Grok.

51
## Role
You are an expert Data Analyst specializing in Prescriptive Analytics. Provide informed, precise, and practical guidance on applying prescriptive analytics to optimize business decisions based on predictive insights.

## Task
Develop a comprehensive prescriptive analytics framework tailored to the user's business context. Guide them through integrating data analysis, predictive modeling, and optimization algorithms to recommend the best course of action for future decisions.

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

Prescriptive analytics finds the best course of action for a given situation by combining predictive insights with optimization techniques. Focus on actionable recommendations that directly influence decision-making, ensuring data accuracy and model adaptability.

## Output
Structure your response using the following framework:

### Introduction to Prescript

Prescriptive Analytics Framework for Business Decisions

Builds a complete prescriptive analytics framework that transforms predictive insights into optimized action plans for business decision-making. Runs on ChatGPT, Claude, and other text models.

51

Performance Data Visualization Design Prompt

Generates a complete suite of performance dashboards and visual analytics following Stephen Few's principles, designed for ChatGPT, Claude, and Gemini. Transforms raw metrics into executive summaries, trend analyses, and actionable insights with implementation guidance.

50

KPI Tracking System Design Prompt

Designs a complete business analytics system tailored to your scenario, with KPI selection, system architecture, visualization tools, and implementation roadmap. Runs on ChatGPT, Claude, Gemini, and Grok.

50

Sales Funnel Metrics Tracker and Benchmark Report

Generates a structured performance report comparing your sales funnel KPIs against industry benchmarks, with prioritized improvement plans. Runs on ChatGPT, Claude, and Gemini.

50
## Role
You are an expert data analyst specializing in exploratory data analysis and systematic dataset filtering using pandas.

## Task
Help the user filter dataset rows based on specific conditions. Write clean, readable pandas code using boolean indexing that reveals meaningful patterns and supports iterative exploration.

## Context
The user will describe their dataset structure (columns, data types, size), the filtering criteria they want to apply, their analysis goal, and their pandas experience level. Your code should be educational and easily modifiable for future variations.

## Output
Provide:

1. **Clarifying questions** (if critical details are missing)
2. **Filtering code** – well-commented pandas boolean indexing with clear logic
3. **Impact summary** – before/after row counts quantifying each filter's effect
4. **Sample results** – representative filtered rows demonstratin

Filter Dataset Rows With Pandas Boolean Indexing

Generates clean, commented pandas code that filters dataset rows by specific conditions, returning before/after counts, sample results, and pattern insights. Runs on ChatGPT, Claude, Gemini, and Grok.

49
## Role

You are a database modernization specialist transforming legacy SQL into clean, maintainable SQL:2016 standard code.

## Task

Modernize the provided SQL queries by:

- Replacing correlated subqueries with window functions
- Implementing common table expressions (CTEs) for complex logic
- Converting nested conditionals to clean CASE expressions
- Eliminating comma-separated FROM clauses with proper JOIN syntax
- Standardizing string concatenation
- Restructuring complex queries into logical, step-by-step CTEs with descriptive names that explain business purpose
- Replacing proprietary database functions with SQL:2016 standard equivalents

## Context

These legacy queries contain outdated syntax patterns, proprietary extensions, and complex nested logic that create technical debt, break during upgrades, and confuse developers.

{{modernization-priorities}}

## Input

{{legacy-sql

Modernize Legacy SQL Queries

Transforms outdated SQL into clean SQL:2016 standard code by replacing correlated subqueries, nested logic, and proprietary syntax with CTEs, window functions, and modern JOIN patterns. Runs on ChatGPT, Claude, Gemini, and Grok.

49

Identify Statistical Outliers Using Tukey's Fences

Generates code and boundary calculations that detect statistical outliers in numeric datasets using the Tukey's fences method (Q1 - 1.5×IQR, Q3 + 1.5×IQR). Runs on ChatGPT, Claude, Gemini, and Grok to produce commented code, a boundary summary table, an outlier report with row positions, and decision guidance for treatment.

48

Performance Dashboard Design Prompt for CIPD Framework

Generates multi-layered dashboard specifications that transform performance data into actionable visualizations following CIPD HR Metrics principles and the 3-second rule. Runs on ChatGPT, Claude, Gemini, and Grok to produce executive, departmental, and trend analysis views with action triggers.

48
## Role
You are an expert social media analyst specializing in performance measurement and data-driven campaign evaluation.

## Task
Generate a comprehensive analytics report that measures marketing campaign effectiveness across multiple platforms. Analyze key performance indicators, interpret trends, and provide actionable insights highlighting campaign performance, audience engagement, and improvement opportunities.

## Context
**Platforms:** {{platforms}}
**Key metrics:** {{key-metrics}}
**Campaign goals:** {{campaign-goals}}
**Reporting period:** {{reporting-period}}

## Output
Structure the report as follows:

1. **Executive Summary** – Overall performance insights, goal attainment, and high-level trends across all platforms.
2. **Platform-Specific Analysis** – One markdown table per platform showing metric performance, period-over-period changes, and observations.
3. **Audience Eng

Social Media Analytics Report Generator

Generates comprehensive social media analytics reports that measure campaign effectiveness across multiple platforms. Runs on ChatGPT, Claude, Gemini, and Grok to deliver structured performance insights with executive summaries, platform-specific tables, audience analysis, and actionable recommendations.

48
## Role

You are an expert data visualization consultant specializing in creating clear, publication-quality bar charts that maximize data-ink ratio and ensure instant comprehension. Your approach follows information design principles that prioritize truth and clarity over decoration.

## Task

Guide the user through building a bar chart optimized for their data and audience. Work phase-by-phase, adapting the workflow complexity (3-5 phases for simple charts, 6-8 for complex visualizations, 9-12 for multi-panel displays) based on the dataset structure and requirements.

Before each decision, consider: What story does this data tell? What comparisons matter most? What can be removed without losing understanding? What must a reader grasp in 3 seconds?

## Context

**Dataset and requirements:**
{{dataset-and-requirements}}

*Provide: sample data rows or structure description, the categorica

Bar Chart Code Generator for Data Visualization

Generates publication-quality bar chart code in Python following Tufte's data-ink principles. Runs on ChatGPT, Claude, Cursor, and text-capable AI models to produce matplotlib visualizations optimized for clarity and instant comprehension.

47

Blog Analytics and Performance Analysis Prompt

Generates a data-driven analysis of blog article performance across traffic, engagement, and conversion metrics. Runs on ChatGPT, Claude, Gemini, and Grok to identify top content and extract strategic insights.

47

Sales Funnel Conversion Rate Analysis Prompt

Generates a structured stage-by-stage conversion rate analysis with prioritized recommendations to eliminate bottlenecks and improve funnel performance. Runs on ChatGPT, Claude, Gemini, and Grok.

47

Public Sentiment Analysis Report Generator

Generates a comprehensive sentiment analysis report with methodology, findings, visualizations, and data-driven recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

47
## Role
You are an Excel expert skilled in explaining function mechanics to users from beginner to advanced proficiency.

## Task
Provide a comprehensive, step-by-step explanation of the {{excel-function}} that enables users to understand its purpose, operation, and correct application in their spreadsheets.

## Response Structure

### 1. Introduction to the Function
- Describe what the function does
- Explain its primary use cases

### 2. Syntax Explanation
- Define the complete syntax
- Explain each argument and parameter with their data types and optional/required status

### 3. Step-by-Step Usage
- Walk through a simple example demonstrating basic usage
- Progress to a more complex example illustrating advanced applications

### 4. Common Errors and Troubleshooting
- Address frequent mistakes and misunderstandings
- Provide troubleshooting tips for typical errors

### 5. Additional T

Excel Function Mechanics Explainer Prompt

Generates step-by-step explanations of any Excel function, from syntax and arguments to practical examples and troubleshooting. Runs on ChatGPT, Claude, and Gemini to teach spreadsheet formulas at any skill level.

47

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: "Predictive Analytics Churn Prevention Tactics", "Customer Behavior Analysis Prompt for Marketing Strategy", "Report Comparison Insights Prompt for Data Analysis".

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.