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
Data Cleanup Formula for A/B testing Sheet
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 Cleanup Formula for A/B testing Sheet” with an experiment design/readout with hypothesis, metrics, limitations and decision rules that can be checked against the supplied evidence.
Excel Dashboard for user behavior 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 user behavior Metrics” 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 marketing analytics 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 marketing analytics Metrics” 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 marketing analytics
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 marketing analytics” 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 financial reporting 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 financial reporting 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 Validation for customer churn Spreadsheet
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 Validation for customer churn Spreadsheet” 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 cohort analysis 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 cohort analysis 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 Validation for dashboard design Spreadsheet
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 Validation for dashboard design Spreadsheet” 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 cohort analysis 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 cohort analysis 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.
Excel Dashboard for sales performance 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 sales performance Metrics” 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 marketing analytics 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 marketing analytics 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 Cleanup Formula for dashboard design 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 dashboard design 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.
Data Cleanup Formula for sales performance 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 sales performance 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.
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.
Google Sheets Setup for dashboard design 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 dashboard design Team” 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 HR metrics 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 HR metrics Metrics” 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 marketing analytics 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 marketing analytics Excel” 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 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 “Financial Model in 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.
Budget Tracker for financial reporting 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 financial reporting Project” with a cost/budget/pricing worksheet with calculations, assumptions and sensitivity checks that can be checked against the supplied evidence.
Google Sheets Setup for customer churn 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 customer churn Team” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks that can be checked against the supplied evidence.
Sales Report Excel for HR 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 “Sales Report Excel for HR metrics” 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 A/B testing
An experiment design/readout with hypothesis, metrics, limitations and decision rules. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Financial Model in Excel for A/B testing” with an experiment design/readout with hypothesis, metrics, limitations and decision rules 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.
Macro Automation for marketing analytics 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 marketing analytics Excel” with a spreadsheet formula or transformation plan with example inputs, expected outputs and validation checks 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.