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
Sales analysis queries with CTEs and window functions
Writes advanced SQL queries using CTEs and window functions for sales performance analysis.
Best for
Create a set of reusable SQL queries that analyze sales by period, product, seller, and region using CTEs (Common Table Expressions) and window functions for rankings and comparisons.
Database Schema Design for Recurring Subscription Systems
Designs an optimized database schema for a subscription business with SaaS metrics.
Best for
Create a complete relational model for a recurring subscription system, including tables, indexes, constraints, and ready-to-use queries for calculating MRR, churn, and LTV.
Slow Query Optimization with EXPLAIN ANALYZE and Indexes
Diagnoses and optimizes slow SQL queries using execution plans, strategic indexes, and query rewriting.
Best for
Learn to identify SQL query performance bottlenecks using EXPLAIN ANALYZE, create efficient indexes, and rewrite queries to reduce response time.
Stored Procedures for Automatic Sales Commission Calculation
Creates stored procedures that automate commission calculations with complex tiered rules and bonuses.
Best for
Develop SQL stored procedures that calculate sales commissions considering tiered quotas, product mix bonuses, cancellation clawbacks, and team splits.
BigQuery Queries for E-commerce Conversion Funnel and Attribution Analysis
BigQuery queries to analyze conversion funnels, channel attribution, and browsing behavior in e-commerce.
Best for
Build conversion funnel analysis queries in BigQuery (Google Analytics 4 export) to identify drop-off points, optimize conversion rates, and attribute revenue to acquisition channels.
User Behavior Funnel Analysis with SQL: From Acquisition to Conversion,
SQL queries to build conversion funnels from raw event data, identifying drop-off points and calculating conversion rates between each step.
Best for
Write SQL queries that reconstruct user journey funnels from event-level data, calculate step-by-step conversion rates, and identify the highest-impact drop-off points for optimization.
Data Pipeline Monitoring: Detecting Anomalies in ETL Jobs with SQL,
SQL-based monitoring queries to detect data quality issues, pipeline failures, and anomalies in automated data pipelines before they corrupt downstream reports.
Best for
Create a set of SQL monitoring queries that automatically detect data pipeline problems including missing data, schema changes, volume anomalies, and freshness issues.
Geospatial SQL Analysis: Store Cannibalization and Market Coverage,
Geospatial SQL queries to analyze store coverage, detect cannibalization between locations, and identify underserved markets for expansion.
Best for
Use geospatial SQL functions to calculate distances between stores, analyze customer catchment areas, detect revenue cannibalization, and recommend optimal new store locations.
Sessionization and User Journey Reconstruction from Raw Web Events,
SQL queries to transform raw pageview events into sessions, reconstruct user journeys, and calculate engagement metrics from event-level web analytics data.
Best for
Build SQL-based sessionization logic that groups raw events into meaningful sessions, reconstructs user paths, and calculates engagement metrics typically found in analytics platforms.
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.
Database Schema for inventory management 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 “Database Schema for inventory management App” 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 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 “Stored Procedure 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.
ETL Query for customer churn 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 customer churn 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.
Database Schema for financial reporting 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 “Database Schema for financial reporting App” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Performance Tuning for sales performance SQL
A SQL draft/review with column definitions, assumptions and validation cases. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Performance Tuning for sales performance SQL” with a SQL draft/review with column definitions, assumptions and validation cases that can be checked against the supplied evidence.
Data Extraction for user behavior 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 user behavior Report” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Performance Tuning for inventory management SQL
A SQL draft/review with column definitions, assumptions and validation cases. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Performance Tuning for inventory management SQL” with a SQL draft/review with column definitions, assumptions and validation cases that can be checked against the supplied evidence.
Data Validation Query for user behavior 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 user behavior DB” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Database Schema 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 “Database Schema 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.
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.
SQL View for inventory management 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 inventory management Reporting” with a SQL draft/review with column definitions, assumptions and validation cases 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.