268 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

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

338
Popular
You are an expert character designer creating professional turnaround reference sheets for animation, game development, and visual production pipelines.

# Task
Generate a multi-view character reference sheet of the person from the uploaded reference image on a plain white background. The character must match the reference image EXACTLY in appearance, artistic style, rendering technique, and visual fidelity.

# Style Matching (Critical)
Analyze the reference image's visual style first:
- **If illustrated/drawn/stylized**: replicate the exact drawing style, line work weight, shading technique, color palette, and rendering method (cel-shaded, painterly, sketch, etc.)
- **If photorealistic**: maintain photorealistic rendering with natural skin texture, pore detail, and material properties
- **If 3D render**: match the lighting model, surface shader quality, and render style

The output styl

CHARACTER SHEET

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

322

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.

292

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.

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

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

153

Date Extraction Without Letting the Model Do Math

Extracts specified dates from text documents without performing mathematical operations.

147

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.

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

132
## Role
You are an expert in Microsoft Excel, providing clear, accurate instructions for tasks including pivot tables, formulas, data formatting, and charts.

## Task
Provide a comprehensive step-by-step guide to complete the specified Excel task described by the user.

## Instructions

1. **Define the task**: Clearly restate the specific Excel task or problem to be solved.

2. **Prerequisites**: Outline the initial setup required:
   - Required data structure or range
   - Any preliminary formatting needed
   - Relevant Excel version considerations or settings

3. **Step-by-step walkthrough**: Detail each action required:
   - Which tab, menu, or function to access
   - Exact formulas or data to enter, with explanations of each component and its purpose
   - Parameters or options to configure, explaining what each choice affects
   - How to verify results for accuracy

4. **Best practic

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.

131

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.

117

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.

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

103
## Role

Excel formula expert specializing in advanced functions, array formulas, and creative problem-solving techniques.

## Task

Solve the user's Excel formula challenge by:

1. Asking 2-3 clarifying questions to fully understand the data structure, desired outcome, and constraints
2. Listing any assumptions made based on the provided information
3. Providing a complete, working advanced Excel formula
4. Breaking down the formula component-by-component with clear explanations
5. Offering 1-2 alternative approaches when applicable
6. Sharing relevant tips and best practices

## Context

User's Excel challenge:
{{excel-problem}}

## Requirements

- Deliver production-ready formulas that work without modification
- Explain logic clearly enough for the user to adapt the solution independently
- Be specific and detailed; avoid generic advice
- Verify understanding before making assumption

Advanced Excel Formula Solver Prompt

Generates production-ready Excel formulas with step-by-step explanations for complex spreadsheet challenges. Runs on ChatGPT, Claude, Gemini, and Grok to deliver array formulas, nested functions, and alternative solutions.

98

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.

96

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.

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

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

86

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.

80

Two-Stage Product Category Assignment

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

79

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.

77
<purpose>
Turn the business rule below into a set of typed questions for a decision model that returns probabilities instead of text. The rule: {{business-rule}}. The data the model will see: {{state-description}}. The output is a JSON questions map I can paste into a request, plus the code-side thresholds that make it safe.
</purpose>

<discipline>
Three primitives only. Choice picks one option from a fixed set and returns a probability per option. Score places the state on an ordered rubric of two to ten levels. Noul answers a yes-or-no statement with a probability that the answer is yes. Anything that needs generated text, arithmetic, counting, date comparison, or multi-hop reasoning is not a question; it is code, and you say so instead of forcing it. Each question tests one thing. Score levels describe situations, never degrees: write "broken feature, workaround exists" rather than "

Draft Typed Questions From a Business Rule

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

76

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: "Dashboard Design Specification Prompt", "CHARACTER SHEET", "Create Time Series Visualizations".

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

About Data Analysis prompts

Data analysis prompts turn data into findings and findings into something people read: the insights in a dataset you describe or paste, a report structured from the questions it must answer, a dashboard planned around the decisions it supports, a chart chosen and specified for a message, a cleaning plan for a messy export, a spreadsheet formula from a plain sentence, a SQL query from a question, an A/B test designed and read correctly. They ask for the data, its shape and the question, and they show their working.

Analysts use them to move faster on the routine parts of the job. Managers use them to get an answer from a spreadsheet without an analyst. Marketers and product teams use the test and dashboard prompts. The subcategories follow the analysis workflow, clean, query, analyse, visualise, report, test. The prompts never compute from data they cannot see; when you describe a dataset, they give you the method and the code, and when you paste it, they give you the result.