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.
335
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
Practical sql prompt to work through Data Extraction for marketing analytics Report with AI — specific steps, not generic advice.
Best for
Professional goal: Enhance the sql workflow using AI tools
Data Validation Query for inventory management DB
A focused prompt for sql that helps you work through Data Validation Query for inventory management DB faster and more consistently.
Best for
Professional goal: Create a comprehensive sql workflow using AI tools
SQL View for cohort analysis Reporting
Make SQL view for cohort analysis reporting repeatable: a clear sql prompt with placeholders you fill in.
Best for
Professional goal: Create a comprehensive sql process with proven methods
SQL Query for A/B testing Analysis
Get a strong first draft for SQL query for A/B testing analysis instead of starting from a blank page — tuned for sql.
Best for
Professional goal: Build a scalable sql strategy for better results
SQL Query for marketing analytics Analysis
Practical sql prompt to work through SQL Query for marketing analytics Analysis with AI — specific steps, not generic advice.
Best for
Professional goal: Streamline the sql framework for efficiency
ETL Query for marketing analytics Data Pipeline
Run ETL query for marketing analytics data pipeline with AI: a structured sql prompt you can adapt to your own context.
Best for
Professional goal: Enhance the sql workflow using AI tools
Stored Procedure for financial reporting Process
A ready-to-use prompt to work through Stored Procedure for financial reporting Process, built for sql work.
Best for
Professional goal: Develop an effective sql system for growth
SQL View for customer churn Reporting
Turn "SQL View for customer churn Reporting" into a practical, copy-and-run prompt for sql in data analysis.
Best for
Professional goal: Design a data-driven sql workflow using AI tools
Database Schema for A/B testing App
Run database schema for A/B testing app with AI: a structured sql prompt you can adapt to your own context.
Best for
Professional goal: Develop an effective sql framework for efficiency
Data Extraction for sales performance Report
A ready-to-use prompt to work through Data Extraction for sales performance Report, built for sql work.
Best for
Professional goal: Streamline the sql process with proven methods
Database Schema for inventory management App
Use this prompt to handle database schema for inventory management app as a repeatable sql workflow.
Best for
Professional goal: Build a scalable sql process with proven methods
Stored Procedure for sales performance Process
Use this prompt to handle stored procedure for sales performance process as a repeatable sql workflow.
Best for
Professional goal: Develop an effective sql system for growth
ETL Query for customer churn Data Pipeline
Practical sql prompt to work through ETL Query for customer churn Data Pipeline with AI — specific steps, not generic advice.
Best for
Professional goal: Implement a systematic sql system for growth
Database Schema for financial reporting App
Practical sql prompt to work through Database Schema for financial reporting App with AI — specific steps, not generic advice.
Best for
Professional goal: Design a data-driven sql process with proven methods
Performance Tuning for sales performance SQL
A focused prompt for sql that helps you work through Performance Tuning for sales performance SQL faster and more consistently.
Best for
Professional goal: Implement a systematic sql approach for scale
Data Extraction for user behavior Report
Use this prompt to handle data extraction for user behavior report as a repeatable sql workflow.
Best for
Professional goal: Automate the sql workflow using AI tools
Performance Tuning for inventory management SQL
Get a strong first draft for performance tuning for inventory management SQL instead of starting from a blank page — tuned for sql.
Best for
Professional goal: Develop an effective sql system for growth
Data Validation Query for user behavior DB
Practical sql prompt to work through Data Validation Query for user behavior DB with AI — specific steps, not generic advice.
Best for
Professional goal: Design a data-driven sql framework for efficiency
Database Schema for cohort analysis App
Get a strong first draft for database schema for cohort analysis app instead of starting from a blank page — tuned for sql.
Best for
Professional goal: Enhance the sql workflow using AI tools
Data Extraction for sales performance Report
Turn "Data Extraction for sales performance Report" into a practical, copy-and-run prompt for sql in data analysis.
Best for
Professional goal: Develop an effective sql approach for scale
SQL View for inventory management Reporting
Turn "SQL View for inventory management Reporting" into a practical, copy-and-run prompt for sql in data analysis.
Best for
Professional goal: Transform the sql approach for scale
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 ($15/$20 by length), or go all-access for $10/mo with a verifiable certificate.
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.