Guide

Best ChatGPT Prompts for Data Analysis

30 free prompts · Updated April 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. 01Funnel 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
  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. 03PLG 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
  4. 04Dataset Summary and InsightsPaste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.Works with ChatGPT, Claude, Gemini
  5. 05SQL Query Writer for Business ReportsGenerate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.Works with ChatGPT, Claude
  6. 06Dashboard KPI Definition FrameworkDefine the right KPIs for your business dashboard with clear formulas, targets, and data sources.Works with ChatGPT, Claude, Gemini
  7. 07A/B Test Results InterpreterInterpret your A/B test results with statistical rigor — determine significance, effect size, and whether to ship the change.Works with ChatGPT, Claude
  8. 08Customer Churn Analysis PromptAnalyze customer churn patterns to identify at-risk segments, root causes, and retention interventions.Works with ChatGPT, Claude
  9. 09Data Visualization RecommendationsGet expert recommendations on the best chart type, layout, and color choices to communicate your data clearly.Works with ChatGPT, Claude, Gemini
  10. 10Marketing Attribution Analysis PromptAnalyze your marketing channel data to understand which touchpoints drive conversions and where to allocate budget.Works with ChatGPT, Claude, Gemini
  11. 11Cohort Retention Analysis ExplainerInterpret your cohort retention data to understand user behavior, identify drop-off patterns, and improve retention strategies.Works with ChatGPT, Claude, Gemini
  12. 12Survey Data Analysis and ReportingAnalyze survey results to uncover trends, segment insights, and generate an executive-ready report with visualizations and recommendations.Works with ChatGPT, Claude, Gemini
  13. 13Revenue Forecasting Model BuilderBuild a structured revenue forecast with multiple scenarios, key assumptions, and sensitivity analysis to predict and plan for future growth.Works with ChatGPT, Claude, Gemini
  14. 14Product Usage Analytics InterpreterInterpret raw product analytics data — feature adoption, session patterns, power user behaviors — and translate findings into actionable product decisions with prioritized recommendations.Works with ChatGPT, Claude, Gemini
  15. 15Customer Segmentation Analysis PromptAnalyze your customer base to identify distinct segments based on behavior, demographics, and value — then generate targeted strategies for each segment to improve retention, upsell, and marketing ROI.Works with ChatGPT, Claude, Gemini
  16. 16Data Cleaning and Preprocessing Checklist BuilderGenerate a comprehensive data cleaning and preprocessing checklist tailored to your dataset type — covering missing values, outliers, encoding, normalization, and validation steps before analysis or model training.Works with ChatGPT, Claude, Gemini
  17. 17Anomaly Detection and Alerting System DesignerDesign a practical anomaly detection and alerting system for your business metrics — including threshold logic, statistical methods, alert routing, and false positive reduction strategies.Works with ChatGPT, Claude, Gemini
  18. 18Pricing Elasticity Analysis PromptAnalyze how price changes affect demand for your product using elasticity calculations, sensitivity modeling, and revenue optimization recommendations.Works with ChatGPT, Claude, Gemini
  19. 19Natural Language Processing Text Analysis PromptAnalyze unstructured text data using NLP techniques including sentiment analysis, topic modeling, entity extraction, and text classification to uncover actionable insights from customer feedback, reviews, or survey responses.Works with ChatGPT, Claude, Gemini
  20. 20Inventory Demand Forecasting PromptBuild an inventory demand forecasting model that predicts stock needs, prevents stockouts and overstock, and optimizes reorder points using historical sales data and seasonal patterns.Works with ChatGPT, Claude, Gemini
  21. 21Time 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
  22. 22Customer Lifetime Value Prediction Model BuilderBuild a predictive customer lifetime value (CLV) model using historical transaction data to forecast future revenue, segment customers by value tiers, and inform acquisition spend decisions.Works with ChatGPT, Claude, Gemini
  23. 23Geospatial Data Analysis and Mapping GuideAnalyze location-based datasets to uncover geographic patterns, build heat maps, optimize service areas, and make data-driven decisions about physical expansion or logistics.Works with ChatGPT, Claude, Gemini
  24. 24Conversion Rate Optimization Data AuditConduct a systematic data audit of your conversion funnel to identify drop-off points, statistical significance of tests, and data-driven recommendations for improving conversion rates.Works with ChatGPT, Claude, Gemini
  25. 25Marketplace Liquidity Analysis FrameworkMeasure supply-demand balance, fill rates, time to match, and regional performance to understand whether your marketplace is liquid enough to grow.Works with ChatGPT, Claude, Gemini
  26. 26Experimentation Metric and Guardrail FrameworkDefine primary metrics, guardrails, and decision thresholds for product and growth experiments before you ship a test.Works with ChatGPT, Claude, Gemini
  27. 27Pricing Experiment Readout and Recommendation MemoAnalyze a pricing test with clear experiment readouts, segmented revenue impact, confidence caveats, and an executive recommendation memo for go, hold, or rollback decisions.Works with ChatGPT, Claude, Gemini
  28. 28Forecast Bias Diagnosis and Correction GuideAnalyze whether forecasts are systematically too high or too low, then build a repeatable correction process for planning, budgeting, and operations teams.Works with ChatGPT, Claude, Gemini
  29. 29Call Center Staffing Forecast Scenario PlannerModel support volume, staffing coverage, and service-level risk across multiple call center forecast scenarios.Works with ChatGPT, Claude, Gemini
  30. 30Marketing Mix Modeling Brief BuilderCreate a practical marketing mix modeling brief that defines channels, data requirements, assumptions, and decision outputs before analysis starts.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