Data Analysis AI prompts
Excel, SQL, data visualization, KPIs and AI-powered reporting. Best for SQL, spreadsheets, dashboards, and KPI reviews, reporting workflows that need clearer logic, summarizing analysis into action-ready recommendations.
338
In this category
All of them
Free to copy
5
Subcategories
3
Difficulty levels
Every prompt below is open. Copy it straight into ChatGPT, Claude, or Gemini.
Guide
Developer guide
Open the guide that shows how this prompt category fits into a broader workflow.
Role path
Technical path
See how this category fits into a role-based AI workflow instead of using prompts in isolation.
Generator
Generate prompt variants
Use the prompt generator when you know the job to be done but not the exact prompt structure yet.
Course path
Course library
Move into structured lessons when you want a repeatable system, not only a single prompt.
Choose the closest workflow
Filter by subcategory and difficulty first. That usually gets you to the right prompt faster than scrolling the full list.
Filtered prompts
66 prompts match the current filters
KPI Framework for E-commerce with Metrics Tree Structure
Structure a complete metrics tree for e-commerce, connecting strategic KPIs to operational ones with realistic targets and benchmarks.
Best for
Create a hierarchical KPI framework for e-commerce that links business metrics (revenue, margin) to operational metrics (conversion, AOV, CAC), with targets grounded in industry benchmarks.
OKR System with Automated Tracking for Startups
Implement OKRs with weekly check-ins, scoring, and tracking dashboards integrated with your existing tools.
Best for
Build a complete OKR system (Objectives and Key Results) covering definition, cascading, weekly tracking, and quarterly scoring, with BI integration for automated progress monitoring.
Balanced Scorecard Adapted for Small and Medium Businesses
Adapt the Balanced Scorecard framework to small and medium business reality with practical, actionable metrics.
Best for
Create a simplified, actionable Balanced Scorecard for SMBs with specific metrics for each perspective (financial, customers, processes, learning) suited to your tax and operational context.
SaaS Metrics Hierarchy with Leading and Lagging Indicators
Maps the relationship between leading indicators (predictive) and lagging indicators (results-based) for a SaaS business, enabling preventive action before outcomes deteriorate.
Best for
Create a complete SaaS metrics hierarchy that differentiates leading indicators (which predict the future) from lagging indicators (which confirm the past), enabling intervention before results worsen.
Logistics Operations Dashboard with SLAs and Efficiency Metrics
Defines logistics KPIs with clear SLAs, penalty systems, and tracking dashboards for distribution operations.
Best for
Create a logistics metrics system covering the full supply chain (receiving, storage, picking, packing, shipping, transportation, last mile) with measurable SLAs and exception management.
Unit Economics Framework: CAC Payback, Contribution Margin, and LTV:CAC,
Build a unit economics model that calculates CAC payback period, contribution margin per customer, and LTV:CAC ratio to evaluate business model sustainability.
Best for
Create a comprehensive unit economics framework that answers the fundamental question: does each customer generate more value than it costs to acquire and serve them?
Customer Health Score: Composite Metric for Account Risk Assessment,
Design a weighted Customer Health Score combining product usage, support interactions, billing history, and engagement signals to predict account risk.
Best for
Build a composite health score (0-100) that predicts customer churn risk, identifies expansion opportunities, and prioritizes Customer Success team efforts.
North Star Metric Selection Framework for Product-Led Growth
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “North Star Metric Selection Framework for Product-Led Growth” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Engineering Team KPIs: DORA Metrics, Velocity, and Quality Dashboard,
Define engineering performance KPIs based on DORA metrics (Deployment Frequency, Lead Time, MTTR, Change Failure Rate) combined with quality and team health indicators.
Best for
Create an engineering metrics dashboard that measures delivery performance, code quality, and team health without incentivizing harmful behaviors like velocity inflation or quality shortcuts.
Startup KPIs for cohort analysis Metrics
An evidence table with finding, source, limitation, impact hypothesis, action and validation. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Startup KPIs for cohort analysis Metrics” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
KPI Framework for dashboard design Business
An evidence table with finding, source, limitation, impact hypothesis, action and validation. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “KPI Framework for dashboard design Business” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
E-commerce KPIs for marketing analytics Store
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “E-commerce KPIs for marketing analytics Store” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
KPI Framework for cohort analysis Business
An evidence table with finding, source, limitation, impact hypothesis, action and validation. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “KPI Framework for cohort analysis Business” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Product KPIs for marketing analytics App
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Product KPIs for marketing analytics App” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Sales KPIs for A/B testing Team
An experiment design/readout with hypothesis, metrics, limitations and decision rules. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Sales KPIs for A/B testing Team” with an experiment design/readout with hypothesis, metrics, limitations and decision rules that can be checked against the supplied evidence.
E-commerce KPIs for financial reporting Store
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “E-commerce KPIs for financial reporting Store” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Operational KPIs for cohort analysis Process
An evidence table with finding, source, limitation, impact hypothesis, action and validation. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Operational KPIs for cohort analysis Process” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Marketing KPIs for HR metrics Campaign
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Marketing KPIs for HR metrics Campaign” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Operational KPIs for sales performance Process
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Operational KPIs for sales performance Process” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Customer Success KPIs for HR metrics
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Customer Success KPIs for HR metrics” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
E-commerce KPIs for user behavior Store
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “E-commerce KPIs for user behavior Store” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
KPI Framework for cohort analysis Business
An evidence table with finding, source, limitation, impact hypothesis, action and validation. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “KPI Framework for cohort analysis Business” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
E-commerce KPIs for marketing analytics Store
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “E-commerce KPIs for marketing analytics Store” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Product KPIs for cohort analysis App
An evidence table with finding, source, limitation, impact hypothesis, action and validation. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Product KPIs for cohort analysis App” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
E-commerce KPIs for A/B testing Store
An experiment design/readout with hypothesis, metrics, limitations and decision rules. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “E-commerce KPIs for A/B testing Store” with an experiment design/readout with hypothesis, metrics, limitations and decision rules that can be checked against the supplied evidence.
Startup KPIs for cohort analysis Metrics
An evidence table with finding, source, limitation, impact hypothesis, action and validation. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Startup KPIs for cohort analysis Metrics” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Marketing KPIs for dashboard design Campaign
An evidence table with finding, source, limitation, impact hypothesis, action and validation. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Marketing KPIs for dashboard design Campaign” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
KPI Framework for sales performance Business
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “KPI Framework for sales performance Business” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Product KPIs for marketing analytics App
An analysis or query/formula plan with definitions, checks, findings, limitations and decision implications. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Product KPIs for marketing analytics App” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
E-commerce KPIs for A/B testing Store
An experiment design/readout with hypothesis, metrics, limitations and decision rules. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “E-commerce KPIs for A/B testing Store” with an experiment design/readout with hypothesis, metrics, limitations and decision rules that can be checked against the supplied evidence.
Every prompt here is free. The course teaches the thinking behind them.
Copy as many prompts as you like. When you want to move from single prompts to a repeatable AI workflow, Learn AI in 30 Days walks through it, one day at a time.
Buy the course once ($20), or choose $10/month or $100 lifetime access.
Related categories
Explore adjacent prompt libraries that support data analysis workflows.
Programming & Dev
Code, debugging, architecture, DevOps and AI-powered development
Finance & Accounting
Financial planning, investments, taxes and cash flow management
Project Management
Planning, agile, risk management, communication and deliverables
SEO & Traffic
On-page optimization, link building, SEO content and organic traffic
How to use Data Analysis prompts well
Start with the prompt closest to your workflow, replace any placeholders with your own context, and tell the model what a good output looks like. The fastest improvement usually comes from clearer context, tighter constraints, and a more specific deliverable.
This category is especially useful for SQL, spreadsheets, dashboards, and KPI reviews. Treat the prompt as the execution layer, then refine it into a reusable workflow once you know it solves a real recurring problem.