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
Chart Selection Guide: Matching Visualization Types to Data and Objectives
Practical framework for selecting the correct visualization type based on analysis goal and data characteristics.
Best for
Create a quick-reference guide to help analysts choose the right chart (among 20+ types) based on analysis objective, number of variables, and target audience.
Power BI Dashboard for Commercial Tracking with Advanced DAX
Designs a complete Power BI dashboard with DAX measures for commercial analysis with drill-through and bookmarks.
Best for
Create the functional and technical specification for a Power BI dashboard for the commercial/sales department, including Star Schema data model, advanced DAX measures, and visual interactions.
Interactive Looker Studio Report with Google Analytics and Sheets Data
Create an automated report in Looker Studio connecting GA4, Google Sheets, and BigQuery with interactive filters.
Best for
Build a digital marketing report in Looker Studio (formerly Data Studio) that combines data from multiple Google sources, with automatic updates and stakeholder sharing.
Data Storytelling: Narrative Structure for Impactful Presentations
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 Storytelling: Narrative Structure for Impactful Presentations” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Real-Time Operational Dashboard with Metabase and Automated Alerts
Configure an operational dashboard in Metabase with real-time metrics, email/Slack alerts, and interactive drill-down.
Best for
Implement an operational dashboard in Metabase (open source) that monitors KPIs in real time, sends automated alerts when metrics exceed thresholds, and enables self-service exploration for the team.
Executive KPI One-Pager Design: Maximum Insight, Minimum Clutter,
Design principles and templates for single-page executive dashboards that communicate the most critical metrics at a glance without overwhelming the reader.
Best for
Create a one-page KPI dashboard design that follows information hierarchy principles, uses visual encoding effectively, and enables executives to understand business health in under 30 seconds.
Interactive Financial Waterfall Chart for P&L Variance Explanation,
Build waterfall charts that explain variance between two periods (budget vs. actual, year-over-year) with drill-down capability for each component.
Best for
Create waterfall visualizations that break down the difference between two financial states into contributing factors, enabling stakeholders to understand exactly what drove changes in revenue, margin, or profit.
Geographic Heatmap and Regional Performance Dashboard,
Create geographic visualizations (choropleth maps, bubble maps) to display regional performance, identify geographic patterns, and support territory-based decisions.
Best for
Build geographic dashboards that visualize data by region, state, or city, enabling regional managers to compare performance and identify geographic opportunities or problems.
Sankey Diagram for Customer Flow and Revenue Attribution,
Design Sankey diagrams that visualize multi-step customer flows and revenue distribution across channels, products, and segments.
Best for
Create Sankey diagrams that show how customers flow through multiple stages or how revenue distributes across dimensions, revealing patterns that traditional charts miss.
Interactive Dashboard for HR metrics
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 “Interactive Dashboard for HR metrics” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Dashboard Design for user behavior KPIs
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 “Dashboard Design for user behavior KPIs” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Marketing Dashboard for sales performance Metrics
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 Dashboard for sales performance Metrics” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Executive Dashboard 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 “Executive Dashboard for customer churn” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Data Visualization for HR metrics Metrics
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 Visualization for HR metrics Metrics” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
BI Report for marketing analytics 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 “BI Report for marketing analytics Analysis” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Sales Dashboard for dashboard design 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 “Sales Dashboard for dashboard design Team” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Interactive Dashboard for A/B testing
An experiment design/readout with hypothesis, metrics, limitations and decision rules. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Interactive Dashboard for A/B testing” with an experiment design/readout with hypothesis, metrics, limitations and decision rules that can be checked against the supplied evidence.
Data Visualization for user behavior Metrics
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 Visualization for user behavior Metrics” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Data Visualization for marketing analytics Metrics
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 Visualization for marketing analytics Metrics” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Chart Selection for marketing analytics Data
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 “Chart Selection for marketing analytics Data” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
Marketing Dashboard for financial reporting Metrics
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 Dashboard for financial reporting Metrics” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Marketing Dashboard for customer churn Metrics
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 Dashboard for customer churn Metrics” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Financial Dashboard for customer churn 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 “Financial Dashboard for customer churn Report” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
BI Report for cohort analysis 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 “BI Report for cohort analysis Analysis” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Financial Dashboard for dashboard design 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 “Financial Dashboard for dashboard design Report” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
BI Report for cohort analysis 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 “BI Report for cohort analysis Analysis” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Dashboard Design for dashboard design KPIs
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 “Dashboard Design for dashboard design KPIs” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Data Visualization for sales performance Metrics
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 Visualization for sales performance Metrics” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.
BI Report for marketing analytics 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 “BI Report for marketing analytics Analysis” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.
Interactive Dashboard for dashboard design
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 “Interactive Dashboard for dashboard design” with an evidence table with finding, source, limitation, impact hypothesis, action and validation 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.