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.
All prompts
338 prompts in this category
Sales Report Excel for dashboard design
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Sales Report Excel for dashboard design” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Data Validation for A/B testing Spreadsheet
An experiment design/readout with hypothesis, metrics, limitations and decision rules. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Data Validation for A/B testing Spreadsheet” with an experiment design/readout with hypothesis, metrics, limitations and decision rules that can be checked against the supplied evidence.
Budget Tracker for cohort analysis Project
A cost/budget/pricing worksheet with calculations, assumptions and sensitivity checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Budget Tracker for cohort analysis Project” with a cost/budget/pricing worksheet with calculations, assumptions and sensitivity checks that can be checked against the supplied evidence.
Financial Model in Excel for customer churn
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Financial Model in Excel for customer churn” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Data Cleanup Formula for financial reporting Sheet
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Data Cleanup Formula for financial reporting Sheet” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Data Cleanup Formula for user behavior Sheet
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Data Cleanup Formula for user behavior Sheet” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Spreadsheet Automation for user behavior Data
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Spreadsheet Automation for user behavior Data” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Google Sheets Setup for sales performance Team
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Google Sheets Setup for sales performance Team” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Spreadsheet Automation for HR metrics Data
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Spreadsheet Automation for HR metrics Data” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Financial Model in Excel for sales performance
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Financial Model in Excel for sales performance” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Financial Model in Excel for financial reporting
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Financial Model in Excel for financial reporting” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Excel Dashboard for financial reporting Metrics
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Excel Dashboard for financial reporting Metrics” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Data Cleanup Formula for marketing analytics Sheet
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Data Cleanup Formula for marketing analytics Sheet” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Google Sheets Setup for user behavior Team
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Google Sheets Setup for user behavior Team” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Macro Automation for HR metrics Excel
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Macro Automation for HR metrics Excel” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Spreadsheet Automation for dashboard design Data
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Spreadsheet Automation for dashboard design Data” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Budget Tracker for sales performance Project
A cost/budget/pricing worksheet with calculations, assumptions and sensitivity checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Budget Tracker for sales performance Project” with a cost/budget/pricing worksheet with calculations, assumptions and sensitivity checks that can be checked against the supplied evidence.
Budget Tracker for customer churn Project
A cost/budget/pricing worksheet with calculations, assumptions and sensitivity checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Budget Tracker for customer churn Project” with a cost/budget/pricing worksheet with calculations, assumptions and sensitivity checks that can be checked against the supplied evidence.
Data Cleanup Formula for customer churn Sheet
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Data Cleanup Formula for customer churn Sheet” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Macro Automation for user behavior Excel
A spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Macro Automation for user behavior Excel” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Data Extraction for marketing analytics Report
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 “Data Extraction for marketing analytics Report” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Data Validation Query for inventory management DB
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 “Data Validation Query for inventory management DB” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
SQL View for cohort analysis Reporting
A SQL draft/review with column definitions, assumptions and validation cases. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “SQL View for cohort analysis Reporting” with a SQL draft/review with column definitions, assumptions and validation cases that can be checked against the supplied evidence.
SQL Query for A/B testing Analysis
An experiment design/readout with hypothesis, metrics, limitations and decision rules. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “SQL Query for A/B testing Analysis” with an experiment design/readout with hypothesis, metrics, limitations and decision rules that can be checked against the supplied evidence.
SQL Query for marketing analytics Analysis
A SQL draft/review with column definitions, assumptions and validation cases. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “SQL Query for marketing analytics Analysis” with a SQL draft/review with column definitions, assumptions and validation cases that can be checked against the supplied evidence.
ETL Query for marketing analytics Data Pipeline
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 “ETL Query for marketing analytics Data Pipeline” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Stored Procedure for financial reporting 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 “Stored Procedure for financial reporting Process” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
SQL View for customer churn Reporting
A SQL draft/review with column definitions, assumptions and validation cases. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “SQL View for customer churn Reporting” with a SQL draft/review with column definitions, assumptions and validation cases that can be checked against the supplied evidence.
Database Schema for A/B testing App
An experiment design/readout with hypothesis, metrics, limitations and decision rules. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Database Schema for A/B testing App” with an experiment design/readout with hypothesis, metrics, limitations and decision rules that can be checked against the supplied evidence.
Data Extraction for sales performance Report
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 “Data Extraction for sales performance Report” with an evidence table with finding, source, limitation, impact hypothesis, action and validation 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.