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
Automated Financial Dashboard in Excel with VLOOKUP and Pivot Tables
Build a complete financial dashboard using advanced Excel formulas and pivot tables for monthly performance tracking.
Best for
Create an interactive financial panel in Excel that consolidates revenue, expenses, and contribution margin data with automatic updates via pivot tables.
Data Cleaning and Standardization with Power Query in Excel
Automate the process of cleaning messy data using Power Query to transform inconsistent datasets into reliable, analysis-ready sources.
Best for
Build an ETL (extract, transform, load) workflow in Excel Power Query to clean, standardize, and consolidate datasets affected by common real-world corporate data problems.
Smart Inventory Control with XLOOKUP and Conditional Formatting
Build an inventory management spreadsheet with automatic alerts, reorder forecasting, and ABC analysis using advanced formulas.
Best for
Develop an Excel or Google Sheets inventory control system that classifies products using the ABC curve, calculates reorder points, and generates automatic visual alerts.
VBA macro for monthly management report automation
Develops VBA macros in Excel to automate monthly management report generation—a process that typically consumes hours of the finance team's time.
Best for
Create a set of VBA macros that automate data consolidation from multiple sheets, generate standardized charts, and export reports as PDF for executive distribution.
Financial projection model with scenarios in Google Sheets
Creates a 12-month financial projection model with optimistic, realistic, and pessimistic scenarios using Google Sheets with advanced formulas.
Best for
Build a financial projection model in Google Sheets that allows simulation of 3 different scenarios, with adjustable assumptions and sensitivity analysis for decision-making.
Dynamic Pricing Calculator with Margin Protection in Google Sheets
Build a pricing calculator that automatically adjusts prices based on cost changes, competitor data, and margin targets while protecting profitability.
Best for
Create a Google Sheets pricing model that factors in variable costs, fixed costs, competitor prices, and minimum margin thresholds to generate optimal pricing recommendations for each SKU.
HR Dashboard: Turnover, Headcount, and Diversity Metrics in Excel,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n
Create a comprehensive HR analytics dashboard tracking turnover rates, headcount evolution, diversity metrics, and hiring pipeline health.
Best for
Build an Excel-based HR dashboard that gives leadership real-time visibility into workforce metrics, identifies retention risk areas, and tracks diversity goals.
Project Portfolio Tracker with Resource Allocation and Budget Burn-Down,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n
Build a project management tracker in Excel that monitors budget burn-down, resource allocation, timeline adherence, and portfolio-level health across multiple simultaneous projects.
Best for
Create a multi-project tracking system that gives PMO visibility into budget consumption, resource utilization, and delivery risk across the entire project portfolio.
Customer Segmentation Matrix with RFM Scoring in Excel,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n
Implement Recency-Frequency-Monetary (RFM) scoring to segment customers into actionable groups for targeted marketing campaigns.
Best for
Build an RFM customer segmentation model in Excel that scores each customer on recency, frequency, and monetary value, then classifies them into segments with specific marketing strategies.
Data Cleanup Formula for HR metrics Sheet
Step-by-step process for excel sheets using AI-powered workflows and strategies
Best for
Professional goal: Streamline the excel sheets strategy for better results
Spreadsheet Automation for user behavior Data
Detailed playbook for excel sheets with real-world examples and best practices
Best for
Professional goal: Optimize existing excel sheets workflow using AI tools
Budget Tracker for sales performance Project
Strategic approach to excel sheets enhanced with AI automation and optimization
Best for
Professional goal: Create a comprehensive excel sheets approach for scale
Google Sheets Setup for customer churn Team
Complete framework and implementation guide for excel sheets with AI assistance
Best for
Professional goal: Transform the excel sheets framework for efficiency
Excel Dashboard for HR metrics Metrics
Proven methodology for excel sheets scaled with AI assistance and automation
Best for
Professional goal: Enhance the excel sheets process with proven methods
Macro Automation for marketing analytics Excel
Professional workflow for excel sheets using cutting-edge AI tools and methods
Best for
Professional goal: Implement a systematic excel sheets workflow using AI tools
Sales Report Excel for dashboard design
Comprehensive guide to excel sheets leveraging artificial intelligence tools
Best for
Professional goal: Create a comprehensive excel sheets workflow using AI tools
Data Cleanup Formula for A/B testing Sheet
Complete framework and implementation guide for excel sheets with AI assistance
Best for
Professional goal: Create a comprehensive excel sheets process with proven methods
Excel Dashboard for user behavior Metrics
Complete framework and implementation guide for excel sheets with AI assistance
Best for
Professional goal: Build a scalable excel sheets framework for efficiency
Excel Dashboard for marketing analytics Metrics
Professional template and methodology for excel sheets with practical examples
Best for
Professional goal: Streamline the excel sheets strategy for better results
Financial Model in Excel for marketing analytics
Detailed playbook for excel sheets with real-world examples and best practices
Best for
Professional goal: Streamline the excel sheets approach for scale
Budget Tracker for financial reporting Project
Detailed playbook for excel sheets with real-world examples and best practices
Best for
Professional goal: Automate the excel sheets approach for scale
Budget Tracker for customer churn Project
Complete system for excel sheets with implementation roadmap and metrics
Best for
Professional goal: Transform the excel sheets approach for scale
Data Validation for customer churn Spreadsheet
Proven methodology for excel sheets scaled with AI assistance and automation
Best for
Professional goal: Automate the excel sheets approach for scale
Macro Automation for cohort analysis Excel
Complete system for excel sheets with implementation roadmap and metrics
Best for
Professional goal: Transform the excel sheets workflow using AI tools
Data Validation for dashboard design Spreadsheet
Proven methodology for excel sheets scaled with AI assistance and automation
Best for
Professional goal: Develop an effective excel sheets workflow using AI tools
Macro Automation for cohort analysis Excel
Step-by-step process for excel sheets using AI-powered workflows and strategies
Best for
Professional goal: Create a comprehensive excel sheets approach for scale
Spreadsheet Automation for dashboard design Data
Complete framework and implementation guide for excel sheets with AI assistance
Best for
Professional goal: Transform the excel sheets process with proven methods
Excel Dashboard for sales performance Metrics
Proven methodology for excel sheets scaled with AI assistance and automation
Best for
Professional goal: Implement a systematic excel sheets process with proven methods
Macro Automation for marketing analytics Excel
Comprehensive guide to excel sheets leveraging artificial intelligence tools
Best for
Professional goal: Implement a systematic excel sheets process with proven methods
Data Cleanup Formula for dashboard design Sheet
Comprehensive guide to excel sheets leveraging artificial intelligence tools
Best for
Professional goal: Develop an effective excel sheets system for growth
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.
