Category
Data Analysis AI Prompts
Analysis prompts fail without two things: context about the data and clarity about the decision it serves. Every template here asks for both — schema and sample rows on one side, the business question on the other — so the output is analysis you can act on, not a statistics lecture.
The set spans SQL writing and optimization, exploratory analysis, A/B test design and readouts, dashboard specs, and plain-English explanations of results. They pair well with tools that accept file uploads; otherwise paste representative rows into the variables.
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.
Dashboard KPI Definition Framework
Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.
A/B Test Results Interpreter
Interpret your A/B test results with statistical rigor — determine significance, effect size, and whether to ship the change.
Customer Churn Analysis Prompt
Analyze customer churn patterns to identify at-risk segments, root causes, and retention interventions.
Data Visualization Recommendations
Get expert recommendations on the best chart type, layout, and color choices to communicate your data clearly.
Marketing Attribution Analysis Prompt
Analyze your marketing channel data to understand which touchpoints drive conversions and where to allocate budget.
Cohort Retention Analysis Explainer
Interpret your cohort retention data to understand user behavior, identify drop-off patterns, and improve retention strategies.
Survey Data Analysis and Reporting
Analyze survey results to uncover trends, segment insights, and generate an executive-ready report with visualizations and recommendations.
Revenue Forecasting Model Builder
Build a structured revenue forecast with multiple scenarios, key assumptions, and sensitivity analysis to predict and plan for future growth.
Funnel Drop-Off Analysis Prompt
Diagnose where and why users drop off in your conversion funnel, with data interpretation frameworks, hypothesis generation, and prioritized experiment recommendations.
Product Usage Analytics Interpreter
Interpret raw product analytics data — feature adoption, session patterns, power user behaviors — and translate findings into actionable product decisions with prioritized recommendations.
Customer Segmentation Analysis Prompt
Analyze 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.
Data Cleaning and Preprocessing Checklist Builder
Generate 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.
Anomaly Detection and Alerting System Designer
Design a practical anomaly detection and alerting system for your business metrics — including threshold logic, statistical methods, alert routing, and false positive reduction strategies.
Pricing Elasticity Analysis Prompt
Analyze how price changes affect demand for your product using elasticity calculations, sensitivity modeling, and revenue optimization recommendations.
Natural Language Processing Text Analysis Prompt
Analyze 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.
Inventory Demand Forecasting Prompt
Build an inventory demand forecasting model that predicts stock needs, prevents stockouts and overstock, and optimizes reorder points using historical sales data and seasonal patterns.
Time Series Decomposition and Trend Analysis
Decompose time series data into trend, seasonality, and residual components to uncover patterns and build better forecasts.
Customer Lifetime Value Prediction Model Builder
Build 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.
Geospatial Data Analysis and Mapping Guide
Analyze location-based datasets to uncover geographic patterns, build heat maps, optimize service areas, and make data-driven decisions about physical expansion or logistics.
Conversion Rate Optimization Data Audit
Conduct 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.
SaaS Unit Economics Diagnostic
Analyze CAC, LTV, gross margin, payback period, and retention to diagnose whether your SaaS growth is efficient and sustainable.
Marketplace Liquidity Analysis Framework
Measure supply-demand balance, fill rates, time to match, and regional performance to understand whether your marketplace is liquid enough to grow.
Experimentation Metric and Guardrail Framework
Define primary metrics, guardrails, and decision thresholds for product and growth experiments before you ship a test.
Pricing Experiment Readout and Recommendation Memo
Analyze a pricing test with clear experiment readouts, segmented revenue impact, confidence caveats, and an executive recommendation memo for go, hold, or rollback decisions.
Forecast Bias Diagnosis and Correction Guide
Analyze whether forecasts are systematically too high or too low, then build a repeatable correction process for planning, budgeting, and operations teams.
Call Center Staffing Forecast Scenario Planner
Model support volume, staffing coverage, and service-level risk across multiple call center forecast scenarios.
Marketing Mix Modeling Brief Builder
Create a practical marketing mix modeling brief that defines channels, data requirements, assumptions, and decision outputs before analysis starts.
Retention Cohort Shock Analysis Builder
Analyze sudden retention drops or spikes in specific cohorts and isolate likely causes, impacted segments, and next investigative steps.
PLG Activation Funnel Diagnostic Builder
Diagnose where self-serve users stall between signup and activation, then turn the findings into a prioritized product-led growth action plan.
Warehouse Fill Rate and Stockout Risk Analyzer
Evaluate order fill rate, stockout drivers, and replenishment risk across products, warehouses, or regions.
Pricing Page Heatmap Insight Brief Builder
Analyze heatmap, click, and session replay findings from a pricing page to surface friction points and CRO opportunities.
Data Dictionary and Metric Lineage Builder
Document analytics definitions, metric formulas, source tables, owners, and lineage so teams stop debating numbers in meetings.
Budget vs Actual Variance Analysis Memo Builder
Analyze budget versus actual results and turn financial variances into a concise management memo with drivers, actions, and forecast impact.
GA4 Event Tracking QA Audit Prompt
Audit a Google Analytics 4 event tracking plan for naming consistency, parameters, conversions, attribution risks, and reporting readiness.
Data Quality Incident Root Cause Analysis Builder
Investigate metric discrepancies, broken pipelines, missing events, or dashboard errors with a structured data quality incident RCA and prevention plan.
Data Access Permission Audit Matrix Builder
Create a data access audit matrix that maps datasets, roles, owners, PII risk, permission levels, least-privilege gaps, and remediation actions.
Survey Sampling Bias Audit Builder
Audit survey results for sampling bias, nonresponse bias, weighting needs, and reporting caveats before making decisions from the data.
Invoice Aging and Collections Risk Analysis
Analyze accounts receivable aging data to prioritize collections, forecast cash flow risk, and recommend outreach actions.
Cloud Cost Allocation and Anomaly Analysis
Analyze cloud spend by service, team, product, and environment to find anomalies, allocation gaps, and FinOps savings opportunities.
Feature Cannibalization Impact Analysis
Analyze whether a new product feature is stealing usage, revenue, or engagement from existing features and recommend product or packaging actions.
Email Deliverability Health Analysis
Analyze email deliverability metrics across campaigns, domains, segments, and inbox providers to diagnose bounce, spam, engagement, and reputation issues.
On-Time Delivery Delay Root Cause Analysis
Analyze late deliveries by lane, carrier, warehouse, product, and SLA to identify root causes and operational fixes.
Subscription Dunning Recovery Analysis
Analyze failed payment and dunning data to reduce involuntary churn through retry timing, messaging tests, payment method insights, and recovery dashboards.
Fraud Pattern and Chargeback Analysis
Analyze payment fraud, chargeback trends, risky segments, and prevention levers using transaction, dispute, and customer behavior data.
Model Drift Monitoring Dashboard Builder
Design a model drift monitoring dashboard with input drift, prediction drift, performance checks, thresholds, and response playbooks.
Data Freshness SLA Audit Builder
Audit dashboard and pipeline freshness expectations with SLA definitions, stakeholder impact, alert thresholds, and remediation actions.
Refund Rate Root Cause Analysis Builder
Analyze refund spikes by product, channel, cohort, reason code, and customer segment to identify root causes and revenue-saving actions.
Lead Scoring Model Audit and Calibration Prompt
Audit a lead scoring model for signal quality, bias, threshold drift, sales alignment, and conversion accuracy, then create a practical recalibration plan.
Recruiting Funnel Metrics Audit Builder
Audit hiring funnel metrics across sources, stages, conversion rates, time-in-stage, candidate experience, and potential bias or bottlenecks.
Support Contact Reason Pareto Analysis Builder
Analyze customer support contact reasons with Pareto tables, volume trends, cost impact, CSAT signals, and root-cause reduction opportunities.
Site Search Zero-Results Analysis Builder
Analyze onsite search queries that return zero results, cluster intent, size revenue impact, and prioritize fixes for ecommerce or content discovery.
Coupon Promotion Profitability Analysis Builder
Analyze whether a coupon or discount promotion created profitable incremental revenue after margin, redemption, customer mix, and cannibalization effects.
Ad Creative Fatigue Performance Analysis Builder
Analyze paid media creative fatigue using spend, impressions, frequency, engagement, conversion, and creative age data to decide what to refresh, rotate, scale, or retire.
Support SLA Breach Trend Analysis Builder
Analyze support SLA breaches by queue, priority, channel, staffing, backlog age, handoffs, and time zones to identify operational causes and recovery actions.
Data Warehouse Query Cost Optimization Analysis Builder
Analyze warehouse query logs and billing data to find expensive dashboards, models, users, schedules, and SQL patterns, then prioritize safe cost optimizations.
Net Revenue Retention Bridge Analysis Builder
Analyze net revenue retention with expansion, contraction, churn, reactivation, cohort movement, account segments, and executive-ready bridge commentary.
Warehouse Labor Productivity Analysis Builder
Analyze warehouse labor productivity across shifts, zones, tasks, and demand patterns with fair normalization, bottleneck detection, and action recommendations.
Marketplace Take Rate Revenue Leakage Analysis Builder
Analyze marketplace revenue leakage across take rate, fee rules, refunds, discounts, payment costs, manual adjustments, and seller/buyer cohorts.
SaaS Seat Utilization License Waste Analysis Builder
Analyze SaaS license usage, inactive seats, role mismatches, department patterns, and renewal risks to reduce software spend without disrupting critical users.
Inventory ABC Classification Analysis Builder
Analyze inventory with ABC classification, velocity, margin, stockout risk, carrying cost, and replenishment actions for retail or warehouse teams.
Restaurant Menu Item Profitability Analysis Builder
Analyze restaurant menu items by sales mix, food cost, gross margin, labor complexity, modifiers, waste, and guest demand to guide menu decisions.
Appointment No-Show Rate Analysis Builder
Analyze missed appointments by segment, timing, reminder path, and operational impact, then recommend targeted no-show reduction experiments.
Healthcare Claim Denial Trend Analysis Builder
Analyze healthcare claim denials by payer, code, provider, location, root cause, appeal outcome, and revenue impact.
Subscription Cancellation Reason Analysis Builder
Analyze subscription cancellation reasons by customer segment, plan, cohort, usage, timing, and revenue impact to prioritize retention fixes.
Delivery Route Delay Analysis Builder
Analyze delivery route delays by driver, zone, stop type, weather, dispatch timing, carrier, and customer access constraints to improve on-time performance.
Manufacturing Scrap Rate Root Cause Analysis Builder
Analyze manufacturing scrap rate drivers with Pareto cuts, process variation checks, cost impact, root-cause hypotheses, and corrective action tracking.
Retail Foot Traffic Conversion Analysis Builder
Analyze how store traffic turns into transactions by joining door counts, POS data, staffing, promotions, weather, and local events.
Inventory Aging and Slow-Moving SKU Analysis Builder
Analyze aging inventory and slow-moving SKUs with sell-through, margin, days on hand, markdown risk, and action recommendations.
Employee Attrition Cohort Analysis Builder
Analyze employee attrition by cohort, tenure, role, manager, location, and hiring source to find retention risks and action priorities.
Facility Energy Usage Anomaly Analysis Builder
Analyze facility energy usage anomalies across meters, sites, weather, occupancy, equipment schedules, and utility bills to find savings and risk.
Warranty Claims Failure Pattern Analysis Builder
Analyze warranty claims for failure patterns across products, lots, regions, service centers, costs, and time-to-failure to guide quality actions.
Restaurant Reservation Demand Analysis Builder
Analyze reservation, walk-in, and table-turn data to forecast demand, reduce empty tables, and improve staffing by daypart.
Volunteer Shift Coverage Analysis Builder
Analyze volunteer shift coverage, no-shows, skill gaps, demand peaks, and scheduling risk for nonprofits, events, and community programs.
Hotel Housekeeping Room Turnover Analysis Builder
Analyze hotel housekeeping room turnover time, staffing, room status delays, inspection failures, and operational bottlenecks.
Retail Planogram Sales Lift Analysis Builder
Analyze whether a retail planogram or shelf placement change improved sales, margin, conversion, inventory movement, and store performance.
Call Center After-Call Work Time Analysis Builder
Analyze after-call work time by queue, agent, issue type, wrap code, tooling, and process friction to improve contact center capacity without hurting quality.
Parking Occupancy and Turnover Analysis Builder
Analyze parking occupancy and turnover using sensor, meter, permit, citation, or manual count data to improve pricing, enforcement, signage, and curb access.
Event Attendee Engagement Analysis Builder
Analyze event attendee engagement across registrations, check-ins, session scans, app activity, sponsor visits, surveys, and follow-up outcomes.
Fleet Fuel Cost and Idle Time Analysis Builder
Analyze fleet fuel spend, idle time, route patterns, driver behavior, maintenance signals, and utilization data to find savings without unsafe incentives.
Donor Retention Cohort Analysis Builder
Analyze nonprofit donor retention cohorts by acquisition source, gift size, cadence, campaign, stewardship touchpoints, and reactivation opportunities.
Public Library Program Attendance Analysis Builder
Analyze public library program attendance by branch, audience, topic, season, outreach source, capacity, repeat visits, and community impact signals.
School Cafeteria Meal Participation Analysis Builder
Analyze school meal participation by campus, grade, menu, eligibility, daypart, waste, staffing, and outreach while protecting student privacy.
Construction Change Order Cost Overrun Analysis Builder
Analyze construction change order cost overruns by trade, cause, status, owner, schedule impact, approval lag, and budget exposure with dashboard-ready outputs.
Pharmacy Inventory Expiration Waste Analysis Builder
Analyze pharmacy inventory expiration and waste by NDC, location, lot, supplier, velocity, ordering pattern, and disposal cost with privacy-safe recommendations.
Restaurant Table Turn Time Revenue Analysis Builder
Analyze restaurant table turn time and revenue with seating intervals, party size, average check, reservation pacing, bottlenecks, and service improvement scenarios.
Warehouse Slotting Efficiency Analysis Builder
Analyze warehouse slotting efficiency with SKU velocity, pick paths, cube movement, replenishment burden, congestion, safety constraints, and re-slotting recommendations.
Call Center Abandon Rate Staffing Analysis Builder
Analyze call center abandon rate and staffing performance with interval-level data, service levels, handle time, queue drivers, forecast gaps, and workforce recommendations.
Theatre Ticket Yield and Occupancy Analysis Builder
Analyze theatre ticket sales, occupancy, discounts, comps, seat maps, and revenue yield to improve programming, pricing, and audience development.
Parking Citation Appeal Outcome Analysis Builder
Analyze parking citation appeal outcomes by violation type, location, evidence, adjudicator result, response time, equity signals, and policy improvement opportunities.
Fitness Class Attendance and Capacity Analysis Builder
Analyze fitness class attendance, waitlists, no-shows, instructor utilization, room capacity, membership segments, and schedule optimization opportunities.
Clinical Lab Specimen Turnaround Time Analysis Builder
Analyze clinical lab specimen turnaround time by collection, transport, accessioning, testing, verification, priority, department, and bottleneck risk.
Municipal Permit Processing Backlog Analysis Builder
Analyze building permit intake, review stages, resubmissions, staffing, and service targets to find bottlenecks and reduce municipal permit backlogs.
Aquatics Pool Chemical Usage Cost Analysis Builder
Analyze pool chemical logs, bather load, water test results, weather, and vendor pricing to explain chemical cost spikes for aquatic facilities.
Sterile Processing Instrument Tray Turnaround Analysis Builder
Analyze sterile processing instrument tray turnaround times, bottlenecks, rework, case readiness, staffing, and quality issues for hospital operations.
Food Pantry Distribution Demand Analysis Builder
Analyze food pantry demand, visit patterns, household needs, item stockouts, volunteer coverage, and distribution-slot capacity for nonprofit food programs.
Library Hold Queue Wait Time Analysis Builder
Analyze public library hold queues, copy availability, branch demand, wait times, and purchasing signals for print, ebook, audiobook, or media collections.
Blood Donation Appointment No-Show Analysis Builder
Analyze blood donation appointment no-shows by drive, slot, reminder, donor segment, and season to improve attendance while respecting donor privacy.
Childcare Center Waitlist Capacity Analysis Builder
Analyze childcare waitlist demand, classroom capacity, age-group transitions, staff coverage, start-date gaps, and enrollment conversion without inventing licensing rules.
Animal Shelter Adoption Funnel Analysis Builder
Analyze animal shelter adoption funnels, kennel capacity, application stages, foster placement, length of stay, returns, and outreach opportunities with humane data caveats.
Street Tree Canopy Equity Analysis Builder
Analyze street tree canopy equity with planting records, maintenance requests, heat exposure, sidewalk conflicts, neighborhood indicators, and public works prioritization.
Museum Membership Renewal Cohort Analysis Builder
Analyze museum membership renewal cohorts by join month, level, visit behavior, campaign exposure, and revenue to improve retention strategy.
Public Park Attendance Weather Impact Analysis Builder
Analyze how weather affects public park attendance, program turnout, staffing, maintenance demand, concessions, and seasonal planning decisions.
Staff Scheduling Overtime Root Cause Analysis Builder
Analyze staff scheduling and overtime patterns to identify root causes, coverage gaps, demand mismatches, policy issues, and practical labor cost interventions.
Transit Fare Evasion Pattern Analysis Builder
Analyze transit fare evasion patterns with station segments, time trends, inspection data, equity safeguards, revenue estimates, and intervention testing.
Frequently Asked Questions
How do I use these data analysis AI prompts?
Open any prompt, copy the template, and replace the bracketed [variables] with your own details. Then paste it into your AI tool — each prompt page shows a realistic example output and tips for better results.
Which AI tools work with these data analysis prompts?
Most templates in this category are written for ChatGPT, Claude and Gemini, and each prompt page lists exactly which tools it's been written for. The templates use structured plain language, so they transfer well between assistants.
Are these data analysis prompts free?
Yes — all 106 prompts in this category are free to copy, customize, and use. No signup required.