Guide

Best ChatGPT Prompts for Data Analysis

30 free prompts · Updated July 2026

Data analysis prompts fail in two ways: no context about the data, or no definition of the decision the analysis serves. The templates below require both — schema and sample rows on one side, the business question on the other — so ChatGPT produces analysis you can act on rather than a statistics lecture.

The collection covers SQL query writing and optimization, exploratory data analysis plans, A/B test design and readouts, dashboard specs, and plain-English explanations of statistical results. Paste your table structure into the [variables] and go.

  1. 01PLG Activation Funnel Diagnostic BuilderDiagnose where self-serve users stall between signup and activation, then turn the findings into a prioritized product-led growth action plan.Works with ChatGPT, Claude, Gemini
  2. 02SaaS Unit Economics DiagnosticAnalyze CAC, LTV, gross margin, payback period, and retention to diagnose whether your SaaS growth is efficient and sustainable.Works with ChatGPT, Claude, Gemini
  3. 03Funnel Drop-Off Analysis PromptDiagnose where and why users drop off in your conversion funnel, with data interpretation frameworks, hypothesis generation, and prioritized experiment recommendations.Works with ChatGPT, Claude, Gemini
  4. 04Transit Fare Evasion Pattern Analysis BuilderAnalyze transit fare evasion patterns with station segments, time trends, inspection data, equity safeguards, revenue estimates, and intervention testing.Works with ChatGPT, Claude, Gemini
  5. 05Food Pantry Distribution Demand Analysis BuilderAnalyze food pantry demand, visit patterns, household needs, item stockouts, volunteer coverage, and distribution-slot capacity for nonprofit food programs.Works with ChatGPT, Claude, Gemini
  6. 06Library Hold Queue Wait Time Analysis BuilderAnalyze public library hold queues, copy availability, branch demand, wait times, and purchasing signals for print, ebook, audiobook, or media collections.Works with ChatGPT, Claude, Gemini
  7. 07Sterile Processing Instrument Tray Turnaround Analysis BuilderAnalyze sterile processing instrument tray turnaround times, bottlenecks, rework, case readiness, staffing, and quality issues for hospital operations.Works with ChatGPT, Claude, Gemini
  8. 08Clinical Lab Specimen Turnaround Time Analysis BuilderAnalyze clinical lab specimen turnaround time by collection, transport, accessioning, testing, verification, priority, department, and bottleneck risk.Works with ChatGPT, Claude, Gemini
  9. 09Municipal Permit Processing Backlog Analysis BuilderAnalyze building permit intake, review stages, resubmissions, staffing, and service targets to find bottlenecks and reduce municipal permit backlogs.Works with ChatGPT, Claude, Gemini
  10. 10Fitness Class Attendance and Capacity Analysis BuilderAnalyze fitness class attendance, waitlists, no-shows, instructor utilization, room capacity, membership segments, and schedule optimization opportunities.Works with ChatGPT, Claude, Gemini
  11. 11Warehouse Slotting Efficiency Analysis BuilderAnalyze warehouse slotting efficiency with SKU velocity, pick paths, cube movement, replenishment burden, congestion, safety constraints, and re-slotting recommendations.Works with ChatGPT, Claude, Gemini
  12. 12Pharmacy Inventory Expiration Waste Analysis BuilderAnalyze pharmacy inventory expiration and waste by NDC, location, lot, supplier, velocity, ordering pattern, and disposal cost with privacy-safe recommendations.Works with ChatGPT, Claude, Gemini
  13. 13School Cafeteria Meal Participation Analysis BuilderAnalyze school meal participation by campus, grade, menu, eligibility, daypart, waste, staffing, and outreach while protecting student privacy.Works with ChatGPT, Claude, Gemini
  14. 14Public Library Program Attendance Analysis BuilderAnalyze public library program attendance by branch, audience, topic, season, outreach source, capacity, repeat visits, and community impact signals.Works with ChatGPT, Claude, Gemini
  15. 15Donor Retention Cohort Analysis BuilderAnalyze nonprofit donor retention cohorts by acquisition source, gift size, cadence, campaign, stewardship touchpoints, and reactivation opportunities.Works with ChatGPT, Claude, Gemini
  16. 16Retail Planogram Sales Lift Analysis BuilderAnalyze whether a retail planogram or shelf placement change improved sales, margin, conversion, inventory movement, and store performance.Works with ChatGPT, Claude, Gemini
  17. 17Volunteer Shift Coverage Analysis BuilderAnalyze volunteer shift coverage, no-shows, skill gaps, demand peaks, and scheduling risk for nonprofits, events, and community programs.Works with ChatGPT, Claude, Gemini
  18. 18Inventory Aging and Slow-Moving SKU Analysis BuilderAnalyze aging inventory and slow-moving SKUs with sell-through, margin, days on hand, markdown risk, and action recommendations.Works with ChatGPT, Claude, Gemini
  19. 19Retail Foot Traffic Conversion Analysis BuilderAnalyze how store traffic turns into transactions by joining door counts, POS data, staffing, promotions, weather, and local events.Works with ChatGPT, Claude, Gemini
  20. 20Manufacturing Scrap Rate Root Cause Analysis BuilderAnalyze manufacturing scrap rate drivers with Pareto cuts, process variation checks, cost impact, root-cause hypotheses, and corrective action tracking.Works with ChatGPT, Claude, Gemini
  21. 21Healthcare Claim Denial Trend Analysis BuilderAnalyze healthcare claim denials by payer, code, provider, location, root cause, appeal outcome, and revenue impact.Works with ChatGPT, Claude, Gemini
  22. 22Inventory ABC Classification Analysis BuilderAnalyze inventory with ABC classification, velocity, margin, stockout risk, carrying cost, and replenishment actions for retail or warehouse teams.Works with ChatGPT, Claude, Gemini
  23. 23Warehouse Labor Productivity Analysis BuilderAnalyze warehouse labor productivity across shifts, zones, tasks, and demand patterns with fair normalization, bottleneck detection, and action recommendations.Works with ChatGPT, Claude, Gemini
  24. 24Support SLA Breach Trend Analysis BuilderAnalyze support SLA breaches by queue, priority, channel, staffing, backlog age, handoffs, and time zones to identify operational causes and recovery actions.Works with ChatGPT, Claude, Gemini
  25. 25Site Search Zero-Results Analysis BuilderAnalyze onsite search queries that return zero results, cluster intent, size revenue impact, and prioritize fixes for ecommerce or content discovery.Works with ChatGPT, Claude, Gemini
  26. 26Data Freshness SLA Audit BuilderAudit dashboard and pipeline freshness expectations with SLA definitions, stakeholder impact, alert thresholds, and remediation actions.Works with ChatGPT, Claude, Gemini
  27. 27Fraud Pattern and Chargeback AnalysisAnalyze payment fraud, chargeback trends, risky segments, and prevention levers using transaction, dispute, and customer behavior data.Works with ChatGPT, Claude, Gemini
  28. 28On-Time Delivery Delay Root Cause AnalysisAnalyze late deliveries by lane, carrier, warehouse, product, and SLA to identify root causes and operational fixes.Works with ChatGPT, Claude, Gemini
  29. 29Warehouse Fill Rate and Stockout Risk AnalyzerEvaluate order fill rate, stockout drivers, and replenishment risk across products, warehouses, or regions.Works with ChatGPT, Claude, Gemini
  30. 30Time Series Decomposition and Trend AnalysisDecompose time series data into trend, seasonality, and residual components to uncover patterns and build better forecasts.Works with ChatGPT, Claude, Gemini

Frequently Asked Questions

Can ChatGPT write SQL for my database?

Yes — give it your table names, columns, and a sample of the data via the template variables, and it writes queries against your actual schema. Always sanity-check joins and filters before running against production.

How do I analyze a spreadsheet with ChatGPT?

Describe the columns and paste representative rows (or attach the file in tools that support uploads), then state the decision you're trying to make. The EDA templates structure exactly that conversation.

Do I need to know statistics to use these prompts?

No — several templates are built to explain results in plain English, including what a result does and doesn't prove. They're useful both for doing analysis and for interrogating analysis someone hands you.

More Guides

Best ChatGPT Prompts for MarketingCopy-paste ChatGPT prompts for email campaigns, ad copy, social calendars, SEO briefs, and brand strategy — structured templates marketers can run today.Best ChatGPT Prompts for WritingChatGPT writing prompts for blog posts, essays, editing, rewriting, and storytelling — structured templates that produce drafts worth keeping.Best ChatGPT Prompts for CodingChatGPT coding prompts for debugging, code review, tests, refactoring, and system design — templates that get specific, useful answers.Best ChatGPT Prompts for BusinessChatGPT prompts for business plans, strategy, meetings, proposals, and operations — structured templates for founders, managers, and consultants.

Browse every prompt in this topic: Data Analysis prompts