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
50
Free to open
285
Premium prompts
5
Subcategories
Free prompts are open. Premium prompts are clearly marked in the cards below.
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,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n
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,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n
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,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n
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,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n
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
Complete system for sql with implementation roadmap and metrics
Best for
Professional goal: Enhance the sql workflow using AI tools
Data Validation Query for inventory management DB
Professional workflow for sql using cutting-edge AI tools and methods
Best for
Professional goal: Create a comprehensive sql workflow using AI tools
SQL View for cohort analysis Reporting
Complete framework and implementation guide for sql with AI assistance
Best for
Professional goal: Create a comprehensive sql process with proven methods
SQL Query for A/B testing Analysis
Complete framework and implementation guide for sql with AI assistance
Best for
Professional goal: Build a scalable sql strategy for better results
SQL Query for marketing analytics Analysis
Professional template and methodology for sql with practical examples
Best for
Professional goal: Streamline the sql framework for efficiency
ETL Query for marketing analytics Data Pipeline
Detailed playbook for sql with real-world examples and best practices
Best for
Professional goal: Enhance the sql workflow using AI tools
Stored Procedure for financial reporting Process
Professional workflow for sql using cutting-edge AI tools and methods
Best for
Professional goal: Develop an effective sql system for growth
SQL View for customer churn Reporting
Step-by-step process for sql using AI-powered workflows and strategies
Best for
Professional goal: Design a data-driven sql workflow using AI tools
Database Schema for A/B testing App
Actionable framework for sql with ready-to-use prompts and templates
Best for
Professional goal: Develop an effective sql framework for efficiency
Data Extraction for sales performance Report
Step-by-step process for sql using AI-powered workflows and strategies
Best for
Professional goal: Streamline the sql process with proven methods
Database Schema for inventory management App
Detailed playbook for sql with real-world examples and best practices
Best for
Professional goal: Build a scalable sql process with proven methods
Stored Procedure for sales performance Process
Professional template and methodology for sql with practical examples
Best for
Professional goal: Develop an effective sql system for growth
ETL Query for customer churn Data Pipeline
Step-by-step process for sql using AI-powered workflows and strategies
Best for
Professional goal: Implement a systematic sql system for growth
Database Schema for financial reporting App
Comprehensive guide to sql leveraging artificial intelligence tools
Best for
Professional goal: Design a data-driven sql process with proven methods
Performance Tuning for sales performance SQL
Actionable framework for sql with ready-to-use prompts and templates
Best for
Professional goal: Implement a systematic sql approach for scale
Data Extraction for user behavior Report
Comprehensive guide to sql leveraging artificial intelligence tools
Best for
Professional goal: Automate the sql workflow using AI tools
Performance Tuning for inventory management SQL
Complete system for sql with implementation roadmap and metrics
Best for
Professional goal: Develop an effective sql system for growth
Data Validation Query for user behavior DB
Step-by-step process for sql using AI-powered workflows and strategies
Best for
Professional goal: Design a data-driven sql framework for efficiency
Database Schema for cohort analysis App
Actionable framework for sql with ready-to-use prompts and templates
Best for
Professional goal: Enhance the sql workflow using AI tools
Data Extraction for sales performance Report
Professional workflow for sql using cutting-edge AI tools and methods
Best for
Professional goal: Develop an effective sql approach for scale
SQL View for inventory management Reporting
Step-by-step process for sql using AI-powered workflows and strategies
Best for
Professional goal: Transform the sql approach for scale
Free browsing stays open. Premium prompts unlock the reusable workflow layer.
Use the guides and role paths to validate the job first. Upgrade when you want the full prompt text, editable premium prompts, and the surrounding course paths in one place.
Free access
- Browse guides, role paths, and category pages.
- Preview prompts before you decide to upgrade.
- Find the right starting point without friction.
Membership access
- Unlock premium prompts and the full copy text.
- See more workflow paths and course connections.
- Keep the reusable templates in one place.
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.
