252 AI Prompts for Data Analysis

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

Browse the prompts

You are a strategic business analyst building an operator's weekly command dashboard. Your goal is to surface signal from noise: identify revenue drivers, time sinks, customer demand patterns, underperforming initiatives, and candidates for eliminationβ€”then recommend the three highest-leverage actions for the coming week.

# INPUT
Review the following business materials:

{{business-data}}

# ANALYSIS FRAMEWORK
Parse the materials and extract:

**Revenue & Profitability**
- Which products, services, or channels are generating the most revenue?
- What are the profit margins? Any low-margin high-effort offerings?
- Trend direction: growing, flat, or declining?

**Time & Resource Allocation**
- Which activities consume disproportionate time relative to their return?
- Are there operational bottlenecks or recurring manual tasks?
- What is the team (or you) spending hours on that doesn't move

One Person Company Operator Dashboard

Generate a strategic operator dashboard that identifies key business insights and actionable steps, ideal for owners of small businesses or startups.

151
{
  "model": "jev-latest",
  "state": {
    "today": "{{today-iso-date}}",
    "document": "{{document-text}}"
  },
  "questions": {
    "mode": {
      "type": "choice",
      "instructions": "How is the {{date-role}} written in the document?",
      "criteria": {
        "absolute": "A calendar date that names a month",
        "relative": "Given relative to today, such as tomorrow or next Friday",
        "none": "The document does not state this date"
      }
    },
    "month": {
      "type": "choice",
      "instructions": "If the {{date-role}} is an absolute calendar date, which month is it in?",
      "criteria": {"january": "January", "february": "February", "march": "March", "april": "April", "may": "May", "june": "June", "july": "July", "august": "August", "september": "September", "october": "October", "november": "November", "december": "December", "none": "Not an absolute 

Date Extraction Without Letting the Model Do Math

Extracts specified dates from text documents without performing mathematical operations.

136

CHARACTER SHEET

Generate a detailed character reference sheet matching a provided reference image, suitable for animation and game development workflows.

129

Create Time Series Visualizations

Generates Python code for time series plots that reveal temporal patterns, seasonal trends, and anomalies using William Cleveland's visualization principles. Runs on ChatGPT, Claude, Gemini, and Grok.

114

Dense Chart Reading With a Crop Tool

Generate a detailed reading of values from a chart image using image processing techniques to provide accurate data visualization analysis in a table format.

83
## Role

You are an expert data scientist specializing in customer analytics, predictive modeling, and retention forecasting. Your analyses drive marketing spend allocation, customer acquisition strategy, and revenue forecasting decisions.

## Task

Develop a comprehensive customer lifetime value (CLV) prediction model and retention probability forecast using the provided customer data. Deliver actionable insights that identify high-value customers, churn risk indicators, and optimization opportunities.

## Context

**Business environment:**
{{business-context}}

**Customer data:**
{{customer-data}}

**Key constraints:**
- Account for seasonal variations, economic factors, and evolving customer preferences
- Predictions must include statistical confidence intervals
- Models should forecast CLV over multiple time horizons: 6 months, 1 year, and 3 years

## Analysis Requirements

1. **Beha

Predict Customer Lifetime Value

A text prompt that builds customer lifetime value prediction models, retention probability scores, and value-based segments from your customer data, delivered as a structured analytical report with confidence intervals.

74
Stage one request, top level of the taxonomy:

{
  "model": "jev-latest",
  "state": {
    "product": {
      "title": "{{product-title}}",
      "description": "{{product-description}}",
      "attributes": "{{product-attributes}}"
    }
  },
  "questions": {
    "department": {
      "type": "choice",
      "instructions": "Which top-level department best matches this product? Read the subtree contents in each option before choosing.",
      "criteria": {
        "{{department-a}}": {"what": "{{department-a-description}}", "examples": ["{{department-a-examples}}"]},
        "{{department-b}}": {"what": "{{department-b-description}}", "examples": ["{{department-b-examples}}"]},
        "other": {"what": "Fits none of the departments listed"}
      }
    }
  }
}

Stage two request, built in code from the chosen department's children, same state, one question:

"subcategory": {
  "type": 

Two-Stage Product Category Assignment

Generate department and subcategory classifications for products using a two-stage hierarchy traversal. Produces JSON output for integration.

73

Draft Typed Questions From a Business Rule

Generate typed questions from a business rule for a decision model that produces probabilities instead of text.

72
## Role
You are an expert dashboard designer and UX architect applying information design principles and responsive web development best practices.

## Task
Design a comprehensive dashboard interface that prioritizes data hierarchy, eliminates visual clutter, and supports rapid decision-making. Balance aesthetic appeal with functional clarity, ensuring critical information captures attention first while maintaining logical relationships between data points.

## Context
Effective dashboards require:
- Clear information hierarchy based on decision-making priorities
- Strategic grouping of related metrics
- Appropriate visualizations matched to data types
- Responsive layouts that preserve priority across screen sizes
- Interactive controls positioned for optimal workflow
- Visual feedback systems (status indicators, loading states)
- Design that follows natural eye movement and cognitive p

Dashboard Design Specification Prompt

Generates a complete dashboard design specification with information architecture, responsive layouts, visual components, and interactive elements. Runs on ChatGPT, Claude, Gemini, and Grok.

54
You are a data transformation specialist. A user has uploaded a raw CSV file and a formatted spreadsheet template. Your task is to map the raw data onto the template's structure, apply its formatting and formulas, flag any rows that cannot be mapped cleanly, and provide reusable transformation code.

## Input

**Raw data:** {{raw-csv}}

**Template structure:** {{template-file}}

## Process

1. **Analyze both files:**
   - Identify all columns in the raw CSV and their data types
   - Examine the template's column headers, data types, formatting rules, and any embedded formulas
   - Note any naming variations (e.g., "Customer Name" vs "customer_name")

2. **Create column mappings:**
   - Match each raw CSV column to its corresponding template column
   - Document the mapping logic (exact match, fuzzy match, derived/calculated, or unmapped)
   - Identify template columns that have no source

Raw CSV to Formatted Spreadsheet Template

Transforms raw CSV files into formatted spreadsheets based on a given template, providing mapping and transformation code.

51

Customer Acquisition Analysis Prompt for Marketing ROI

Generates a detailed marketing channel analysis report that calculates CAC, CLV, payback periods, and delivers budget reallocation recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

49

KPI Dashboard Specification Generator

Generates structured KPI dashboard specifications with layout design, visualization recommendations, and interactive features. Runs on ChatGPT, Claude, Gemini, and Grok for business intelligence and reporting.

45

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.

42
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.

39
## Role
You are a content performance analyst specializing in cross-platform measurement and optimization. You translate raw metrics into actionable strategies that connect content performance to business outcomes.

## Task
Analyze the provided content metrics to build a performance framework that identifies meaningful KPIs, establishes realistic benchmarks, and delivers prioritized optimization recommendations.

## Context
Content creators often track vanity metrics while missing signals that drive real business results. Platform algorithms evolve constantly, and stakeholders need clear ROI evidence from content investments. Your framework must cut through noise to surface what matters.

## Input Required
- {{content-metrics-data}} – paste or attach your performance data (views, engagement, conversions, traffic sources, etc.)
- {{platforms-and-objectives}} – list your primary content pl

Content Performance Framework Builder for Analytics

Builds a structured content performance framework that translates raw metrics into KPI hierarchies, benchmarks, and prioritized optimization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

38

Digital Experience Friction Analysis Prompt

Identifies friction points and optimization opportunities across digital customer journeys by analyzing user flow patterns, bounce rates, and conversion funnels. Runs on ChatGPT, Claude, Gemini, and Grok.

36

Multi-Platform Customer Behavior Analysis Prompt

Generates a comprehensive strategic report mapping customer journeys across channels, identifying conversion paths, and providing optimization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

33
## Role
You are an expert data visualization specialist who translates complex data into interactive, user-friendly dashboards that drive informed decision-making across industries.

## Task
Provide a comprehensive, step-by-step guide to designing and implementing interactive dashboards tailored to the user's context. Cover the full lifecycle from initial design through ongoing maintenance.

## Context
- Industry and domain: {{industry-context}}
- Data characteristics: {{data-description}}
- End users and their needs: {{user-profile}}

## Output
Deliver a structured guide with clear headings and sections:

1. **Introduction**: Explain why interactive dashboards are critical for data visualization and decision-making in the given context.

2. **Design Process**: Outline the key steps in designing effective dashboards, from requirements gathering to wireframing.

3. **Tools & Technologies*

Interactive Dashboard Design Guide for Data Visualization

Generates a step-by-step guide to designing and implementing interactive dashboards tailored to your industry, data sources, and end users. Runs on ChatGPT, Claude, and Gemini to deliver structured best practices from requirements gathering through maintenance.

32
## Role
You are an expert digital marketing analyst specializing in Google Analytics implementation and website tracking strategy.

## Task
Create a comprehensive, step-by-step guide to implement Google Analytics for a business website. The guide must enable tracking of website traffic, analysis of user behavior, and measurement of conversions. Write for solopreneurs with varying technical backgrounds, ensuring clarity at every step.

## Context
Business context: {{business-context}}
(Include: business name, website URL, primary conversion goal, target audience, and your level of technical expertise)

## Output
Deliver the guide as a numbered list with clear section headings. For each implementation step, provide:
- Concise instructions
- Detailed explanations of what the step accomplishes
- Tips and best practices for optimization
- Any prerequisites or common pitfalls to avoid

Structu

Google Analytics Setup Guide for Solopreneurs

Generates a step-by-step implementation guide for Google Analytics tailored to your business context and technical level. Runs on ChatGPT, Claude, and Gemini to produce setup instructions, conversion tracking configuration, and custom reporting recommendations.

32

Data Storytelling Prompt for ChatGPT and Claude

Generates structured data narratives that transform raw datasets into accessible stories with insight analysis, narrative arcs, and visualization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

32

E-Commerce Data Analysis Prompt

Generates a multi-phase behavioral analytics engagement that transforms e-commerce transaction data into prioritized action plans. Runs on ChatGPT, Claude, Gemini, and Grok.

31

Marketing Channel Performance Report Generator

Generates structured marketing performance reports comparing two time periods, complete with metrics tables, trend analysis, and optimization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

30
## Role

You are an expert A/B testing strategist and statistical analyst specializing in conversion rate optimization. Design a comprehensive A/B testing strategy that transforms marketing hypotheses into statistically reliable insights through systematic experimentation.

## Context

Marketing budgets face intense scrutiny, attribution models are increasingly complex, and stakeholders demand rapid results while statistical significance requires patience. Common testing failures stem from insufficient sample sizes, premature conclusions, poorly defined success metrics, p-hacking, multiple comparison errors, and premature test termination.

## Task

Develop a systematic testing protocol that includes:

- Hypothesis formation frameworks with clear null and alternative hypotheses
- Statistical power calculations and sample size determination methodologies
- Success metrics hierarchies that

A/B Testing Strategy Framework Prompt

Generates a systematic A/B testing protocol that transforms marketing hypotheses into statistically valid experiments, complete with power calculations, sample sizing, and quality safeguards. Runs on ChatGPT, Claude, Gemini, and Grok.

29

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: App Development (109 prompts), Data Insights (86 prompts), Reporting & Dashboards (61 prompts), Data Cleaning (19 prompts), Data Visualization (19 prompts).

Popular on this page right now: "One Person Company Operator Dashboard", "Date Extraction Without Letting the Model Do Math", "CHARACTER SHEET".

252 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.