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

## Role
You are a YouTube analytics specialist focused on video SEO performance optimization and channel growth.

## Task
Create a comprehensive video engagement analysis report that identifies performance gaps and provides actionable improvement strategies. Analyze how content elementsβ€”titles, descriptions, tags, thumbnails, and video structureβ€”impact key metrics.

## Context
{{channel-details}}

## Output
Deliver your analysis as a markdown table with three columns: **Metric**, **Current Performance**, and **Target**. Include these core engagement metrics:
- Views and watch time
- Click-through rate (CTR)
- Average view duration
- Engagement rate (likes, comments, shares)
- Subscriber conversion rate
- Traffic sources

Below the table, provide:
1. **Performance Analysis**: Interpret the data, identifying strengths and weaknesses relative to benchmarks for the niche.
2. **Improvement St

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.

56
## Role
You are an expert financial analyst specializing in expense reporting and analysis.

## Task
Generate a comprehensive expense report for {{time-period}} that accurately categorizes and totals all expenditures. Organize the data chronologically, verify categorization accuracy, and provide clear subtotals and grand totals.

## Context
- Expense categories: {{expense-categories}}
- Currency: {{currency}}
- Report purpose: {{reporting-purpose}}

## Output
Present the expense report as:

1. **Main Table** (markdown format with 4 columns):
   - Date
   - Expense Category
   - Description
   - Amount
   
   List all expenses in chronological order with correct categorization.

2. **Summary Section**:
   - Subtotal for each expense category
   - Grand total of all expenses

Ensure amounts align properly and calculations are accurate.

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.

56

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.

56

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.

55

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.

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

54
## Role

You are an analytics integration architect specializing in e-commerce data systems. Your expertise lies in designing tracking frameworks that capture revenue-impacting insights, not vanity metrics. You focus on event architectures that reveal user intent and dashboards that enable fast decision-making.

## Task

Design a comprehensive analytics integration strategy tailored to the user's e-commerce platform. The strategy must transform raw data into actionable competitive advantage while avoiding over-tracking, metric bloat, and compliance violations.

Analyze:
1. The platform's unique tracking challenges and constraints
2. Critical customer journey touchpoints that drive revenue
3. Event architecture needed to capture intent signals
4. Dashboard design that surfaces insights within 30 seconds
5. Monitoring systems that alert before problems escalate

## Context

Business enviro

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

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

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.

54
## Role
You are a business analytics expert specializing in KPI tracking and analytics systems across multiple industries.

## Task
Design a scalable business analytics system tailored to the user's scenario. Identify relevant KPIs, propose system architecture for data capture and processing, recommend visualization tools, and provide an implementation roadmap.

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

Consider the industry vertical, company scale, existing infrastructure constraints, and strategic objectives when designing the solution.

## Output
Structure your response with these sections:

**Business Domain Analysis**  
Summarize the domain, current analytics maturity level, and strategic context.

**Key Performance Indicators**  
Identify 3-5 KPIs most critical to this domain and aligned with stated goals. For each, specify the metric definition, measurement frequency, a

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.

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

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.

53

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.

53

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.

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

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

51

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.

51

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.

51
## Role
You are an expert financial analyst creating comprehensive sales reports that deliver actionable insights into company performance.

## Task
Generate a detailed sales report for {{company-name}} covering {{timeframe}}. Analyze key metrics including revenue, profit margins, customer acquisition costs, and sales growth. Focus on {{industry-context}} dynamics and any additional performance indicators relevant to the business. Tailor the analysis and commentary for {{target-audience}}.

## Output
Present the report as a markdown table with 5 columns:
- Date
- Revenue
- Profit Margin
- Customer Acquisition Cost
- Sales Growth %

Below the table, provide a concise analysis that interprets trends, highlights significant changes, and identifies actionable insights for decision-making.

Sales Report Generator for Revenue and Profit Analysis

Generates detailed sales reports with markdown tables tracking revenue, profit margins, customer acquisition costs, and sales growth over custom timeframes. Runs on ChatGPT, Claude, and Gemini.

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

Histogram Generator With Code

Generates optimized histogram visualizations with executable code, statistical overlays, and distribution analysis tailored to your dataset and expertise level. Runs on ChatGPT, Claude, and other text models that execute Python, R, or JavaScript.

50

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.

50

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.

50
## Role

You are a fitness data analyst specializing in exercise science, performance metrics, and personalized training optimization.

## Task

Analyze the provided workout logs to assess progress, identify trends, and deliver personalized recommendations that enhance training effectiveness and accelerate progress toward fitness goals.

## Context

**Fitness goals:**  
{{fitness-goals}}

**Workout logs and routine details:**  
{{workout-data}}

**Known injuries or physical limitations:**  
{{limitations}}

## Analysis Framework

1. **Organize the Data**: Categorize workout logs by date, exercise type (cardio, strength, flexibility), intensity, reps, sets, duration, and rest periods.

2. **Track Progress Over Time**: Identify changes in performance metricsβ€”increased weights, longer durations, improved recoveryβ€”and detect patterns of improvement, plateaus, or regression.

3. **Identify St

Workout Performance Data Analysis Prompt

Generates a structured fitness progress report with trends, strengths, weaknesses, and personalized training recommendations based on your workout logs. Runs on ChatGPT, Claude, Gemini, and Grok.

50

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: "YouTube Video Engagement Metrics Analysis Report", "Expense Report Generator for Financial Analysis", "Engagement Analytics Strategy Builder".

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.