Data AI Prompt Templates
49 free prompt templates for data
AI prompts for data analysis, SQL, dashboards, reporting, and visualization. Copy any prompt template below with one click and paste it into ChatGPT, Claude, or Gemini to get instant results. Each prompt includes customizable variables and expert tips.
Analyze Survey Response Data
You are an expert data analyst specializing in survey research. I need you to analyze the following survey response data...
Analyze Time Series Data with Statistical Insights
You are an expert data scientist specializing in time series analysis. Please perform a comprehensive analysis of the pr...
Analyze Website Traffic Data
I need you to analyze website traffic data and provide actionable insights. Please examine the following metrics and dat...
Build a Project Timeline Tracker
Create a comprehensive project timeline tracker spreadsheet for [PROJECT_NAME] with the following specifications: **Pro...
Build Advanced Customer Segmentation Model
Act as a senior data scientist specializing in customer analytics. I need you to design a comprehensive customer segment...
Build an Inventory Tracking Spreadsheet
Create a comprehensive inventory tracking spreadsheet for [BUSINESS_TYPE] that manages [INVENTORY_ITEMS]. The spreadshee...
Build Customer Churn Prediction Model
You are an expert data scientist specializing in customer retention analytics. Help me build a comprehensive customer ch...
Build Employee Performance Tracker Spreadsheet
Create a comprehensive employee performance tracker spreadsheet for [DEPARTMENT] with [NUMBER_OF_EMPLOYEES] employees. T...
Build ETL Data Pipeline
You are a senior data engineer tasked with designing and implementing a comprehensive ETL (Extract, Transform, Load) dat...
Calculate Correlation Between Variables
You are a statistical analyst tasked with calculating and interpreting correlations between variables. I need you to ana...
Calculate Customer Lifetime Value (CLV)
You are a customer analytics expert specializing in calculating Customer Lifetime Value (CLV). I need you to analyze the...
Calculate Monthly Recurring Revenue (MRR)
I need help calculating Monthly Recurring Revenue (MRR) for my subscription business. Please create a comprehensive MRR ...
Calculate Statistical Significance
I need you to calculate statistical significance for my data analysis. Please act as a statistician and perform a compre...
Clean Messy CSV Data
You are a data cleaning specialist. I need help cleaning a messy CSV dataset. Please analyze the data and provide a comp...
Cluster Customer Behavior Data
You are a data scientist specializing in customer analytics. I need you to analyze customer behavior data and create mea...
Create Advanced Outlier Detection Script
Create a comprehensive Python script for outlier detection in datasets. The script should be production-ready and includ...
Create an Expense Tracking Dashboard
Create a comprehensive expense tracking dashboard design for [USER_TYPE]. The dashboard should be designed for [PLATFORM...
Create Automated Email Report
Create a comprehensive automated email report template for [REPORT_TYPE] that will be sent [FREQUENCY] to [AUDIENCE]. Th...
Create Comprehensive Trend Analysis Report
Create a comprehensive trend analysis report for [DATASET_TYPE] covering the [TIME_PERIOD]. Structure the report with th...
Create Conditional Formatting Rules for Spreadsheets
I need help creating conditional formatting rules for my spreadsheet data. Please provide detailed conditional formattin...
Create Data Heatmap Visualization
You are a data visualization expert specializing in heatmap creation. I need you to create a comprehensive heatmap visua...
Create Data Visualization Chart
You are a data visualization expert tasked with creating a comprehensive chart visualization for the following dataset a...
Create Executive Dashboard Layout
You are an expert business intelligence designer specializing in executive-level dashboards. Create a comprehensive dash...
Create Interactive Data Filters
You are an expert data visualization developer. Create interactive filter specifications and code for a dataset visualiz...
Create KPI Dashboard Metrics
You are a business intelligence expert tasked with creating comprehensive KPI dashboard metrics for [BUSINESS_FUNCTION]....
Create Pivot Tables in Excel
I need step-by-step instructions to create a pivot table in Excel for my data analysis project. Please provide comprehen...
Create Professional Financial Report Template
Create a comprehensive financial report template for [COMPANY_TYPE] covering the [REPORTING_PERIOD]. The template should...
Create Real-Time Sales Dashboard
You are a senior business intelligence analyst and dashboard architect. Create a comprehensive real-time sales dashboard...
Debug SQL Syntax Errors
You are an expert SQL developer and database administrator. I need help debugging a SQL syntax error in my query. Here'...
Design Survey Data Collection Strategy
You are a research methodology expert specializing in survey design and data collection. I need you to create a comprehe...
Generate Comprehensive Data Quality Report
You are a senior data analyst tasked with creating a comprehensive data quality report. Analyze the provided dataset inf...
Generate Python Pandas Code for Data Analysis
You are an expert Python data analyst specializing in pandas. Write clean, efficient, and well-commented pandas code to ...
Generate SQL Queries with Complex Joins
Act as an expert SQL database developer. I need you to write a SQL query that joins multiple tables to retrieve specific...
Generate Synthetic Test Data for Database Testing
I need you to generate synthetic test data for a [DATABASE_TABLE] with the following specifications: Table Schema: - [C...
Generate Weekly Performance Report
You are a business analyst creating a comprehensive weekly performance report. Generate a professional report based on t...
Handle Missing Data Values
You are an expert data scientist specializing in data preprocessing and missing data analysis. I need comprehensive guid...
Merge Data from Multiple Sources
I need to merge data from multiple sources and need your help creating a comprehensive data integration plan. Please ana...
Normalize Database Table Structure
You are a database design expert specializing in normalization. Analyze the following table structure and normalize it a...
Perform A/B Test Analysis
You are a data analyst specializing in A/B test analysis. I need you to analyze the results of an A/B test and provide c...
Perform Comprehensive Cohort Analysis
You are an expert data analyst specializing in cohort analysis. I need you to help me perform a comprehensive cohort ana...
Perform Sentiment Analysis on Dataset
You are an expert data scientist specializing in natural language processing and sentiment analysis. I need you to perfo...
Predict Sales Using Regression Analysis
Act as an expert data scientist specializing in sales forecasting. I need to build a regression model to predict sales f...
Remove Duplicates from Dataset
I need help removing duplicates from my dataset. Please analyze the following data and provide a comprehensive deduplica...
Standardize Date Formats Across Files
I need to standardize date formats across multiple data files. Please analyze the provided date samples and create a com...
Validate Data Entry Format
You are a data validation specialist. I need you to validate the format of data entries and identify any formatting issu...
Visualize Geographic Sales Data
You are a data visualization expert specializing in geographic sales analysis. I need you to create a comprehensive visu...
Write Advanced SQL Stored Procedures
You are an expert database developer. Create a comprehensive SQL stored procedure based on the following requirements: ...
Write Advanced SQL Window Functions
You are an expert SQL developer specializing in analytical queries and window functions. I need you to write SQL window ...
Write Complex Excel Formulas
You are an Excel formula expert. I need you to create a complex Excel formula for the following scenario: **Data Contex...
Explore More Categories
Want 500+ Expert Prompts?
Get the Premium Prompt Pack — organized, tested, and ready to use.
Get it for $29