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
68 prompts match the current filters
Reconcile two reports that disagree on revenue
A reconciliation table and validation query plan. Start with your own evidence and finish with a reviewable next step.
Best for
Produce a reconciliation table and validation query plan from the supplied inputs.
Explain an experiment whose result is inconclusive
A plain-English experiment readout and decision options. Start with your own evidence and finish with a reviewable next step.
Best for
Produce a plain-English experiment readout and decision options from the supplied inputs.
Monthly Executive Report with Variance Analysis and Recommendations
Structures a standardized monthly executive report with variance analysis (actual vs. budget) and actionable recommendations.
Best for
Create a monthly executive report template that presents results clearly for leadership, with variance analysis, root causes, and recommendations prioritized by impact.
Automated Report Generation with Python and Scheduled Email Delivery
Automates report creation and distribution using Python, Pandas, and scheduled email delivery.
Best for
Build a Python script that automates the entire report generation pipeline: data extraction from a database, processing with Pandas, chart creation, export to PDF/Excel, and automatic email delivery.
Cohort and Retention Analysis for Recurring Revenue Businesses
Generates a complete cohort analysis report to understand retention patterns and identify critical churn windows.
Best for
Develop a detailed cohort analysis that reveals behavioral patterns over time, identifies the critical churn window, and quantifies the financial impact of retention.
Budget vs. Actual Variance Analysis Report for Financial Controllers
Develops a detailed budget variance report with decomposition of causes (price, volume, mix) and projections.
Best for
Create a variance analysis framework that breaks down differences between budgeted and actual results into their components (price effect, volume effect, mix effect, exchange rate effect) to enable precise corrective action.
Data Narrative for Annual Report with Strategic Insights
Transforms raw yearly data into a coherent strategic narrative for the company's annual report.
Best for
Write the analytical narrative for the annual report, turning tables and charts into a story that connects past results with future strategic direction, in language appropriate for diverse stakeholders.
Weekly Business Review (WBR) Template with Action Tracking,
Structure a standardized weekly business review meeting with data-driven agenda, KPI tracking, and action item follow-up to maintain operational rhythm.
Best for
Create a repeatable WBR format that keeps leadership focused on the right metrics, drives accountability through action tracking, and enables rapid course correction.
A/B Test Results Report with Statistical Rigor and Business Context
An experiment design/readout with hypothesis, metrics, limitations and decision rules. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “A/B Test Results Report with Statistical Rigor and Business Context” with an experiment design/readout with hypothesis, metrics, limitations and decision rules that can be checked against the supplied evidence.
Competitive Intelligence Report: Market Share, Pricing, and Feature Gap Analysis,
Structured competitive analysis report that tracks market positioning, pricing strategies, feature parity, and strategic threats across key competitors.
Best for
Create a systematic competitive intelligence framework that updates regularly, tracks competitor movements, and informs product roadmap and go-to-market strategy.
Board Deck Template: Quarterly Investor Update with Financial Projections,
Create a board-ready quarterly presentation template that communicates company performance, key metrics, risks, and financial projections to investors and board members.
Best for
Design a standardized quarterly board deck that tells a clear story about company performance, builds investor confidence, and facilitates strategic discussion rather than just reporting numbers.
Performance Report for marketing analytics Team
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 “Performance Report for marketing analytics Team” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Financial Report for HR metrics Company
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 “Financial Report for HR metrics Company” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Data Analysis Report for inventory management
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 Analysis Report for inventory management” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Ad-hoc Analysis Report for customer churn
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 “Ad-hoc Analysis Report for customer churn” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Financial Report for dashboard design Company
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 “Financial Report for dashboard design Company” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Financial Report for inventory management Company
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 “Financial Report for inventory management Company” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Ad-hoc Analysis Report for inventory management
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 “Ad-hoc Analysis Report for inventory management” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Financial Report for dashboard design Company
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 “Financial Report for dashboard design Company” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Sales Report for inventory management Period
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 “Sales Report for inventory management Period” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Annual Report for user behavior Company
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 “Annual Report for user behavior Company” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Data Analysis Report for cohort analysis
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 Analysis Report for cohort analysis” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Annual Report for customer churn Company
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 “Annual Report for customer churn Company” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Sales Report for cohort analysis Period
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 “Sales Report for cohort analysis Period” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Monthly Report Template for user behavior
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 “Monthly Report Template for user behavior” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Financial Report for marketing analytics Company
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 “Financial Report for marketing analytics Company” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Marketing Report for inventory management 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 Report for inventory management Campaign” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Financial Report for financial reporting Company
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 “Financial Report for financial reporting Company” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Data Analysis Report for inventory management
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 Analysis Report for inventory management” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Quarterly Business Review for customer churn
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 “Quarterly Business Review for customer churn” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications 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.