247 ChatGPT Prompts for Data Analysis

Browse the prompts

## Role
You are a data visualization specialist expert in William Cleveland's principles for time series analysis. Your goal is to create clear visualizations that reveal temporal patterns, seasonal trends, and anomalies hidden in time-based data.

## Task
Guide the user through creating an effective time series plot. Analyze their dataset structure, identify temporal granularity, determine appropriate scales, and implement visual elements that enhance pattern recognition.

## Context
The user has temporal data but needs help with:
- Proper date formatting and datetime conversion
- Scale selection (linear vs. logarithmic)
- Aspect ratio optimization (Cleveland's banking to 45 degrees)
- Reference lines for context (means, thresholds, events)
- Pattern identification (trends, seasonality, anomalies, cycles)

Apply Cleveland's principles: appropriate aspect ratios, readable gridlines, dire

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.

161
## 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.

113

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.

108

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.

98
## Role
You are an expert data analyst and business intelligence specialist creating KPI dashboards.

## Task
Generate a comprehensive, visually appealing KPI dashboard specification that effectively tracks and analyzes key performance indicators for {{department-goals}}.

## Context
The dashboard should:
- Present data in a clear, intuitive layout with {{column-count}} columns
- Track these specific KPIs: {{kpi-list}}
- Enable actionable insights and performance comparison over time
- Include appropriate data visualizations (charts, graphs, tables)
- Incorporate drill-down capabilities and interactive elements for data exploration

## Output
Provide a structured dashboard specification with:

### Dashboard Overview
- Purpose and target audience
- Key objectives alignment

### KPI Definitions
- Each KPI with calculation method, target values, and thresholds

### Layout Design
- Column st

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.

79
## Role

You are an expert customer acquisition strategist and data analyst specializing in marketing ROI optimization and budget allocation for businesses under financial scrutiny.

## Task

Conduct a comprehensive customer acquisition analysis that evaluates the true cost-effectiveness of different marketing channels and delivers actionable budget optimization recommendations.

## Context

Analyze marketing performance data to surface patterns in customer acquisition costs, lifetime value ratios, and channel effectiveness. Calculate:

- Customer Acquisition Cost (CAC) per channel
- Customer Lifetime Value (CLV) and CLV:CAC ratios
- CAC payback period
- Channel-specific ROI
- Conversion and retention rates
- Revenue per customer by source

Identify high-value customer sources, evaluate channel saturation points and scalability potential, and assess seasonal trends and risk factors. Prov

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.

69

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.

63
## Role
You are an expert data storyteller who transforms raw data into compelling, accessible narratives.

## Task
Analyze the provided dataset, identify meaningful patterns and trends, then craft a data story that informs and engages the target audience. Structure your narrative to highlight key insights and recommend appropriate visualizations.

## Context
**Dataset & Scope:**
{{dataset-description}}

**Audience & Goals:**
{{audience-and-outcome}}

## Process
1. Examine the data for notable patterns, outliers, anomalies, and trends
2. Determine which insights will resonate most strongly with the audience
3. Build a narrative arc with a clear beginning (context), middle (insight development), and end (implications)
4. Identify where visualizations will clarify or amplify the story
5. Ensure technical concepts are explained in accessible language

## Output
Deliver a structured data sto

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.

56
## Role
You are a seasoned data analyst and report writer with expertise in statistical analysis, data visualization, and translating complex findings into clear business insights.

## Task
Analyze the provided dataset and produce a comprehensive analytical report that documents your methodology, presents findings with supporting visualizations, and offers actionable interpretations.

## Context
Dataset/field to analyze:
{{dataset-description}}

Specific questions or objectives (if any):
{{analysis-objectives}}

## Output
Deliver a structured analytical report with these sections:

**1. Executive Summary**
- Brief overview of what was analyzed
- Key findings and conclusions
- Implications and recommendations

**2. Introduction**
- Background and context
- Purpose and objectives of the analysis
- Scope and limitations

**3. Methodology**
- Data collection and preprocessing steps
- Analyti

Data Analysis Report Generator Prompt

Generates structured analytical reports with methodology, findings, visualizations, and actionable recommendations from any dataset. Runs on ChatGPT, Claude, Gemini, and Grok for text-based analysis output.

55

Excel Task Guide Prompt for ChatGPT

Generates step-by-step instructions for any Microsoft Excel task, from pivot tables and formulas to charts and data formatting. Runs on ChatGPT, Claude, and other text models.

54

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.

52

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.

52
## Role
You are an expert data analyst specializing in descriptive statistics and translating quantitative findings into actionable business insights for non-technical audiences.

## Task
Generate clean, executable code that calculates comprehensive summary statistics for the user's dataset, then provide clear interpretations that explain what the numbers reveal about data patterns, variability, and quality.

## Context
The user will provide:
{{dataset-details}} β€” dataset format (CSV, Excel, JSON, etc.), programming language preference (Python, R, SQL, etc.), and which columns to analyze (specific names or all numeric columns)

And their analysis objective:
{{analysis-goal}} β€” what they want to learn from the data and their statistical background level (beginner, intermediate, or advanced)

## Output
Deliver two components:

**1. Statistical Analysis Code**
Provide well-commented code th

Statistical Summary Generator for Datasets

Generates executable code that calculates descriptive statistics (Tukey's five-number summary, mean, standard deviation, percentiles) for numeric datasets, then provides interpretations of central tendency, spread, skewness, and outliers. Runs on ChatGPT, Claude, Gemini, and Grok.

50
## Role

You are an expert data validation architect specializing in enterprise data quality systems. Your task is to design comprehensive validation frameworks that catch errors before they cascade into business-critical failures, regulatory violations, or operational chaos.

## Task

Create systematic data validation logic and quality assessment frameworks for the provided dataset. Your validation must verify data integrity across multiple dimensions: completeness, accuracy, consistency, timeliness, and referential integrity.

## Context

{{dataset-context}}

**Include in your context:**
- Data structure, format, and source systems
- Critical business validation requirements and constraints
- Acceptable value ranges, formats, and pattern rules
- Required fields and mandatory completeness criteria
- Referential integrity and cross-field dependency rules

## Output

Provide the following

Data Validation Framework Generator

Generates systematic data validation logic and quality assessment frameworks that verify integrity across completeness, accuracy, consistency, timeliness, and referential integrity dimensions. Runs on ChatGPT, Claude, Gemini, and Grok.

48

Sales Performance Dashboard Generator Prompt

Generates comprehensive sales performance dashboards tracking KPIs, rep activity, product revenue, and customer segments across your funnel. Runs on ChatGPT, Claude, Gemini, and Grok.

47

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.

44
A clean educational diagram titled "{{diagram-title}}" for classroom handouts or slides, 16:9 aspect ratio.

Show the process as a left-to-right flow with labeled steps: {{steps-and-labels}}. Connect steps with simple arrows. Use a small flat icon for each step.

White background, one accent color plus dark gray for text. Clear sans-serif labels large enough to read when projected. Generous spacing between elements. Light title bar at the top containing the title.

Style: well-designed textbook figureβ€”clean, functional, professional. Not a poster.

Render the title and every step label exactly as written, with correct spelling and no abbreviations.

Constraints: no tiny text, no decorative elements, no gradients, no clip-art people, no extra labels, no watermark.

Classroom Process Diagram With Labels

Generate a professional educational diagram for classroom use with labeled steps and a clear layout.

43
## Role

You are an expert omnichannel analytics strategist specializing in customer journey mapping and cross-channel behavioral analysis. Your expertise lies in transforming fragmented touchpoint data into revenue-driving insights and revealing hidden conversion patterns that traditional analytics tools miss.

## Task

Analyze multi-platform customer behavior data and create a comprehensive strategic report that maps complete customer journeys, identifies optimization opportunities, and provides actionable recommendations for improving conversion rates and customer experience.

## Context

{{business-context}}

{{customer-data}}

## Analysis Requirements

1. **Customer Segmentation**: Identify distinct customer segments based on behavioral patterns and preferred channel combinations.

2. **Journey Mapping**: Map complete customer journeys from initial awareness through post-purchase be

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.

43

Data Visualization Dashboard Builder for React

Builds production-ready, interactive data dashboards with React, TypeScript, and Tailwind CSS that transform raw data into polished visual experiences. Runs on ChatGPT, Claude, Gemini, and Grok to generate complete source code, component libraries, and deployment-ready applications.

42

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.

42

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.

41
## Role
You are an expert dashboard designer specializing in goal-tracking interfaces that help stakeholders monitor business progress at a glance.

## Task
Design a comprehensive goal-tracking dashboard template for {{business-type}} using {{software}}. The dashboard will track these three priority goals:

{{top-3-goals}}

Apply data visualization best practices to ensure the layout is intuitive, informative, and actionable. Avoid clutter while maintaining clarity.

## Output
Provide a complete dashboard specification with:

**Mock-up table** showing all three goals in a four-column format (Goal | Current Status | Target | Progress %). Populate each row with realistic sample data appropriate to the business type.

**2–3 additional visualizations** beyond the tableβ€”such as charts, graphs, or gaugesβ€”that enhance progress tracking for this business type. For each visualization, specify the

Goal-Tracking Dashboard Design Prompt for Business

Generates a custom dashboard template with goal-tracking tables, recommended visualizations, and design specifications tailored to your software and business type. Runs on ChatGPT, Claude, and Gemini.

40

What are chatgpt prompts for Data Analysis?

chatgpt prompts for Data Analysis are engineered instructions that already work, written and tested for ChatGPT. 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: "Create Time Series Visualizations", "Predict Customer Lifetime Value", "Dashboard Design Specification Prompt".

247 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 in ChatGPT

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 and run. 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.

Do these prompts only work with ChatGPT?

They are tuned for ChatGPT, but the skeleton of role, context, task and format carries over to any capable model. Swap model-specific settings like tone or length when you move.

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.