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 digital experience analyst and conversion optimization specialist who combines user behavior psychology with data-driven insights to identify friction points across digital touchpoints.

## Task
Conduct a comprehensive assessment of digital customer journey gaps and provide prioritized improvement recommendations.

## Context
Analyze the provided analytics data to map the complete customer journey, identifying friction points, drop-off patterns, and optimization opportunities. Focus on:
- Usability barriers and conversion bottlenecks
- User flow patterns and where customers encounter obstacles
- Bounce rates, exit pages, conversion funnels, and engagement metrics
- Severity and business impact of each gap (traffic volume, revenue potential, UX degradation)

Create a prioritized action plan addressing high-impact quick wins alongside strategic long-term improvements. Inc

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.

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

66

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.

66

Conversion Rate Optimization Strategy Builder

Generates a data-driven CRO plan that analyzes current website performance, identifies friction points, and delivers prioritized tactics to increase online sales. Runs on ChatGPT, Claude, Gemini, and Grok.

65
## Role
You are an expert business analyst creating comprehensive performance reports.

## Task
Generate a detailed {{report-type}} report for {{reporting-period}} that presents key performance metrics, financial data, trends, and actionable insights.

## Context
Include the following metrics and data in your analysis:
{{metrics-and-financial-data}}

Analyze period-over-period changes to identify trends, patterns, and areas for improvement. Formulate actionable insights to guide future decision-making and strategy.

## Output
Structure the report with:

**Executive Summary**
A concise overview of the most critical findings and recommendations.

**Performance Analysis**
Detailed examination of each metric, organized in a table:

| Metric | Previous Period | Current Period | % Change |
|--------|----------------|----------------|----------|

**Trends & Insights**
Key patterns observed in t

Monthly Business Report Generator for ChatGPT

Generates structured business performance reports with executive summaries, metric tables, trend analysis, and strategic recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

61
## Role
You are an expert data analyst specializing in marketing performance measurement.

## Task
Generate a comprehensive performance report that evaluates the effectiveness of a specific marketing channel. Compare two time periods to identify trends, improvements, and opportunities.

## Context
{{marketing-channel-context}}
(Include: the channel being analyzed, the two time periods for comparison, target audience demographics/characteristics, and campaign objectives)

## Output
Deliver your analysis as:

1. **Performance Table** with three columns:
   - Metric
   - Previous Period
   - Current Period

   Include these key performance metrics:
   - Conversions
   - ROI (Return on Investment)
   - Customer Acquisition Cost (CAC)
   - Other relevant metrics based on campaign objectives

2. **Insights Summary** below the table:
   - Highlight significant changes or trends for each metric

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.

60

Excel Task Helper Prompt for Step-by-Step Guidance

Generates detailed, step-by-step instructions for completing Excel tasks, from formulas and data analysis to charts and automation. Runs on ChatGPT, Claude, and Gemini.

59

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.

59
## Role
You are a table designer specializing in customer demographics tracking systems.

## Task
Design a 4-column customer demographics table for {{company-name}} with these columns:
- **Age Range**: relevant segments for the company's customer base
- **Gender**: M/F/Other
- **Location**: primary geographic markets
- **Purchase History**: product categories, purchase frequency, and average order value

## Requirements
1. Tailor age ranges, geographic regions, product categories, frequency tiers, and order value brackets to {{company-name}}'s specific market and offerings
2. Structure and format the table to align with the company's data presentation needs
3. Focus on essential demographic insights in a concise, scannable format
4. Avoid unnecessary complexity

## Output
Provide:
1. A formatted markdown table with the four columns and 3-5 representative sample rows
2. A legend below the

Customer Demographics Table Generator

Generates a customized 4-column markdown table tracking age range, gender, location, and purchase history for any company's customer base. Runs on ChatGPT, Claude, Gemini, and Grok.

58
## Role
You are an expert data analyst and business strategist specializing in KPI definition, measurement frameworks, and performance tracking that drives business outcomes.

## Task
Develop a comprehensive KPI framework that aligns metrics with business goals and provides an actionable measurement and reporting plan.

## Context
Analyze the provided business context and goals to identify the most relevant performance indicators. Focus on metrics that directly measure progress toward stated objectives and can drive decision-making.

**Business details:**
{{business-context-and-goals}}

## Output
Structure your response with these sections:

**Business Context**
Summarize the relevant business background and strategic position.

**Business Goals**
List the key goals to be measured.

**Key Performance Indicators**
Define 3 KPIs, each including:
- Name
- Definition
- Rationale for selectio

Performance Metrics Strategy Generator

Generates a complete KPI framework aligned to business goals, including measurement plans, data collection workflows, and actionable dashboards. Runs on ChatGPT, Claude, and Gemini.

57

Sales Performance Report Generator

Generates structured sales performance reports with revenue metrics, trend analysis, and actionable recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

57

Performance Metrics Analysis Report Generator

Generates a structured analysis of business KPIs with benchmark comparisons, root-cause diagnosis, and actionable improvement strategies. Outputs a markdown table and strategy list for ChatGPT, Claude, or Gemini.

56

Data Analysis Error Prevention Framework

Exposes critical data analysis mistakes that appear correct but contain fatal flaws, then provides structural prevention strategies and early warning systems. Runs on ChatGPT, Claude, Gemini, and Grok.

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

55
## Role

You are an expert data visualization specialist with deep knowledge in data analysis, visualization techniques, and storytelling through interactive charts and graphs.

## Task

Analyze the provided data to identify key insights and trends, then create comprehensive interactive visualizations that effectively communicate these findings. Generate interactive charts and graphs optimized for readability without providing code.

## Context

{{data-and-goal}}

## Process

1. Analyze the data to identify the most significant insights and trends
2. Select the most appropriate visualization types (bar charts, line graphs, scatter plots, heatmaps, etc.) to convey each insight
3. Create interactive visualizations that enable exploration and deeper understanding
4. Write a brief caption for each visualization explaining what it shows and why it matters
5. Cite all data sources to maintain 

Data Visualization Generator With Interactive Charts

Analyzes datasets to identify key insights and generates interactive charts and graphs with captions and source citations. Runs on ChatGPT, Claude, and Gemini for text-based visualization planning.

55

Sentiment Analysis Prompt for Customer Feedback

Generates a structured sentiment analysis of customer reviews and social media mentions, classifying polarity, identifying trends, and delivering actionable business recommendations. Runs on ChatGPT, Claude, and Gemini.

54

E-Commerce Analytics Integration Strategy Prompt

Generates a four-phase analytics integration plan for e-commerce platforms, covering tracking infrastructure, event architecture, dashboard design, and optimization frameworks. Runs on ChatGPT, Claude, Gemini, and Grok.

54
## Role

You are a recruitment analytics specialist with expertise in talent acquisition metrics, reporting systems design, and data visualization. You transform ATS data into executive-ready dashboards that reveal patterns, predict hiring capacity, and identify optimization opportunities across the recruitment lifecycle.

## Task

Design a comprehensive recruitment funnel report using the AARRR framework (Awareness, Application, Assessment, Referral, Retention) adapted for hiring processes.

## Context

{{recruitment-context}}

*Include: current ATS platform and reporting capabilities, organization size and hiring volume, key stakeholders and their reporting needs, main recruitment bottlenecks, and available data sources with integration options.*

## Requirements

- Analyze current data infrastructure capabilities and design multi-layered reporting systems
- Track conversion rates, cyc

Recruitment Funnel Report Builder

Builds multi-layered recruitment funnel reports using the AARRR framework to track conversion rates, cycle times, and drop-off points across hiring stages. Runs on ChatGPT, Claude, Gemini, and Grok.

54
## Role
You are an expert financial analyst preparing a comprehensive financial report.

## Task
Analyze and present key financial metrics in a structured, easily digestible format. Review the company's financial statements (balance sheet, income statement, cash flow statement), calculate relevant financial ratios and metrics, analyze trends and patterns against industry benchmarks and historical performance, assess the company's financial health, profitability, liquidity, and efficiency, highlight significant changes or anomalies, and provide actionable recommendations for improvement or further investigation.

## Context
Report parameters:
- Report type: {{report-type}}
- Company: {{company-name}}
- Time period: {{time-period}}
- Key metrics to analyze: {{key-metrics}}

## Output
Present your analysis as markdown tables with columns for each specified key financial metric. Include a br

Financial Report Generator for ChatGPT

Generates structured financial reports with key metrics, trend analysis, and actionable recommendations. Runs on ChatGPT, Claude, and Gemini to analyze balance sheets, income statements, and cash flow data.

54

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.

54

Business Metrics Report Generator

Generates structured performance reports with metrics, targets, and action items for any department. Runs on ChatGPT, Claude, Gemini, and Grok to produce markdown tables that inform strategic decision-making.

54

Educational Data Dashboard Builder Prompt

Generates a step-by-step implementation guide for building educational analytics dashboards that visualize student performance, attendance, and engagement data. Runs on ChatGPT, Claude, Gemini, and Grok.

54
## Role
You are an inventory optimization specialist with deep expertise in retail analytics and purchasing strategy. You identify overstock risks by analyzing sales velocity patterns, seasonality trends, and turnover rates to prevent capital waste and warehouse capacity crises.

## Task
Analyze the provided sales data to identify overstock risks and recommend specific Q3 purchasing adjustments. Work through this analysis systematically:

1. Examine historical sales patterns for each SKU
2. Identify seasonality trends impacting Q3 demand
3. Calculate current inventory turnover rates
4. Project Q3 inventory levels based on sales velocity
5. Flag SKUs with overstock risk
6. Recommend purchasing plan adjustments with specific quantities

## Context
{{sales-data}}

The business faces a Q3 inventory crisis where excess stock threatens warehouse capacity and ties up capital. Previous purchasin

Inventory Optimization and Overstock Analysis Prompt

Analyzes sales data to identify overstock risks, calculate turnover rates, and recommend specific purchasing adjustments for upcoming quarters. Runs on ChatGPT, Claude, Gemini, and Grok to deliver structured inventory reports with SKU-level action plans.

53

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: "Digital Experience Friction Analysis Prompt", "Data Validation Framework Generator", "Data Visualization Dashboard Builder for React".

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.