25+ Best ChatGPT Prompts for Data Analyst Reporting
As a data analyst, you spend countless hours wrangling data and crafting impactful reports. This collection of AI prompts for data reporting is designed to be your secret weapon. Leverage these data analyst ChatGPT prompts to automate summaries, identify key trends, and draft executive-level insights in seconds, freeing you to focus more on strategic analysis.
Quickly create a high-level summary for stakeholders based on key performance indicators.
Act as a senior data analyst. I'm preparing a report for the executive team. Based on the following KPI data for [Time Period, e.g., Q3 2023], write a concise, 3-paragraph executive summary. Highlight the top 3 achievements, 2 areas for concern, and provide one strategic recommendation. The audience is non-technical.
KPI Data:...
Draft TL;DR for Monthly Performance Report
Distill a dense monthly performance report into a few key bullet points for quick consumption.
I have a detailed monthly performance report. I need a 'Too Long; Didn't Read' (TL;DR) section for an internal newsletter. Convert the key findings from the text below into 5 clear, impactful bullet points. Focus on what has changed since last month.
Report Text:...
Detect Anomalies in [Metric] Time-Series Data
Scan a dataset to flag potential outliers or anomalies that require further investigation.
Analyze the following time-series dataset for [Metric, e.g., daily sales]. Identify any significant outliers or anomalies. For each anomaly, specify the date, the value, and suggest 2 potential business reasons for its occurrence (e.g., marketing campaign, holiday, technical issue).
Dataset:...
Formulate Hypotheses for a [Metric] Trend
Brainstorm potential reasons behind a specific trend to guide your deeper analysis.
I've observed a [e.g., 15% increase/decrease] in [Metric, e.g., user engagement] over the last [Time Period, e.g., 6 weeks]. Based on this trend, generate 5 distinct hypotheses that could explain this change. Categorize them as internal factors (e.g., product changes, marketing efforts) and external factors (e.g., competitor actions, seasonality).
Uncover Potential Correlations in [Dataset Topic] Data
Quickly identify potential relationships between different variables in your dataset.
Given the following dataset summary, identify the top 3 most interesting potential correlations. For each correlation, explain in simple terms what the relationship might mean for the business and suggest a next step for analysis to validate it.
Dataset Columns & Summary Stats:...
Explain [KPI] Fluctuation for Stakeholders
Draft a clear, data-backed explanation for a significant change in a key metric.
Our [KPI, e.g., Customer Acquisition Cost (CAC)] increased by [Percentage, e.g., 25%] last month. Based on the contributing factors below, write a clear, concise explanation for a stakeholder report. Structure the explanation with a main cause, secondary contributing factors, and the expected impact.
Contributing Factors:...
Outline Root Cause Analysis for [Metric] Drop
Structure a root cause analysis to investigate why a key performance indicator has declined.
Our key metric, [Metric Name, e.g., 'Add to Cart' rate], dropped from [X%] to [Y%] this week. I need to perform a root cause analysis. Create a structured investigation plan. Provide a list of 5-7 specific questions I should answer with data, covering user segments, traffic sources, device types, and recent product changes.
Build a Data-Driven Narrative for [Audience]
Turn a list of findings into a compelling story for a presentation or report.
Transform the following data points into a cohesive narrative for a business presentation. The story should have a clear beginning (the situation), middle (the findings/conflict), and end (the conclusion/recommendation). The target audience is the marketing department.
Data Points:...
Simplify Complex Data Findings for Non-Technical Audience
Translate a complex analytical result into simple terms for a non-technical audience.
Translate the following technical finding into a simple, one-paragraph explanation for a non-technical manager. Use an analogy to make the concept easier to understand. Avoid jargon like 'p-value', 'standard deviation', or 'regression model'.
Technical Finding:...
Structure a Data Analysis Report on [Topic]
Generate a logical structure for a new data analysis report to ensure all key areas are covered.
I need to create a comprehensive report on [Topic, e.g., Q3 E-commerce Sales Performance]. Generate a standard report outline including the following sections: Executive Summary, Key Questions, Methodology, Detailed Findings (broken down by sub-topics like Traffic, Conversion, and AOV), and Recommendations & Next Steps.
Generate SQL Query from Business Request
Convert a business request into a functional SQL query to pull the necessary data.
Act as an expert SQL developer. Write a SQL query for a PostgreSQL database based on the following request. The tables are `users` (user_id, signup_date, country) and `orders` (order_id, user_id, order_date, amount).
Request: 'I need to find the total number of users and total revenue from users who signed up in the UK during the first half of 2023.'
Suggest Optimizations for a Slow SQL Query
Get suggestions on how to improve the performance of a slow or inefficient SQL query.
Act as a database administrator. The following SQL query is running slowly. Analyze it and provide 3 specific recommendations to improve its performance. Explain why each recommendation would help.
Slow Query:...
Break Down Complex SQL Query for Junior Analysts
Break down a complex SQL query into a step-by-step explanation for documentation or for a junior analyst.
Explain the following complex SQL query in plain English. Break down what each part of the query does, including the CTEs, joins, and window functions, as if you were explaining it to a new data analyst.
Complex Query:...
Create Python Script for [Dataset] Exploratory Data Analysis
Create a Python script using pandas and matplotlib for initial exploratory data analysis.
Write a Python script using the pandas and matplotlib libraries to perform exploratory data analysis (EDA) on a CSV file named 'sales_data.csv'. The script should:
1. Load the CSV into a DataFrame.
2. Print the first 5 rows (`.head()`)....
Troubleshoot Python Pandas Error in [Snippet]
Get help identifying the cause of a common error in a Python data analysis script.
I'm getting an error in my Python script using pandas. Explain the likely cause of this error and provide 2 possible ways to fix it.
Code:...
Prepare QBR Summary for [Theme] Presentation
Generate a comprehensive summary for a QBR presentation based on key data points.
Act as a principal analyst. Draft a summary for a Quarterly Business Review (QBR) presentation. The theme is '[Theme, e.g., 'Driving Profitable Growth']'. Use the data points below to create a narrative that covers Wins, Challenges, and Strategic Priorities for the next quarter.
Data Points:...
Develop Customer Segmentation Models from Data
Generate potential customer segmentation strategies based on available data.
I need to segment our customer base to personalize marketing campaigns. Based on the available data fields below, suggest 3 distinct segmentation models (e.g., RFM, behavioral, demographic). For each model, specify which data fields to use and what the resulting segments might look like.
Available Data Fields: `user_id`, `last_purchase_date`, `total_spend`, `purchase_frequency`, `country`, `device_type`, `browsed_categories`.
Outline Data Quality Checks for [Dataset Topic]
Outline a series of checks to perform on a new dataset to ensure its quality and reliability.
I have just received a new dataset about [Dataset Topic, e.g., customer product reviews]. Create a data quality assessment plan. List at least 5 specific checks I should perform. For each check, describe the goal and the method (e.g., check for null values in the 'rating' column, check for duplicate review IDs, validate date formats).
Analyze [KPI] Performance Across User Segments
Draft a summary comparing the performance of a key metric across different user segments.
Write a short analysis comparing the performance of [KPI, e.g., 30-day retention rate] across the following user segments. Identify which segment is the best-performing and which is the worst-performing. Suggest one action item for each of the underperforming segments.
Data:...
Generate Simple Forecast for [Metric] Next Quarter
Generate a simple, qualitative forecast for a metric based on historical data and upcoming events.
Based on the historical data and upcoming business initiatives provided below, write a short forecast for [Metric, e.g., Monthly Recurring Revenue (MRR)] for next quarter. Provide a projected range and justify your reasoning.
Historical Data:...
Compose Email Summary for Stakeholders on [Analysis Topic]
Compose a concise email updating key stakeholders on the results of a recent analysis.
I just completed an analysis on [Topic, e.g., the impact of our new feature on user engagement]. Draft a clear and concise email to stakeholders summarizing the findings. The email should include: a brief background, 3 key bullet-point findings, and one clear recommendation. The tone should be professional and action-oriented.
Key Findings:...
Create Effective Titles & Captions for [Chart Type] Charts
Create clear, descriptive titles and insightful captions for data visualizations.
I have created a chart for a report. Help me make it more effective by generating a title and a caption for it. The title should be a clear statement of the main finding. The caption should add context or point out a key insight.
Chart Description:...
Build Regex for [Data Field] Extraction in Data Cleaning
Create a regular expression to extract or validate information from a messy text field.
I have a column in my dataset called `log_entry` that contains unstructured text. I need to extract the user ID, which is always prefixed with 'user_id='. Write a regular expression (regex) that can extract this ID.
Example `log_entry` strings:...
Draft Project Outcome Summary for [Project Goal]
Create a final summary for a completed data analysis project, focusing on results and business impact.
Write a one-page summary of a completed data analysis project. The goal was to [Project Goal, e.g., understand the drivers of customer churn]. Structure the summary with these sections:
1. Business Problem
2. Analytical Approach...
Identify Leading & Lagging Indicators for [Business Goal]
Identify leading and lagging indicators for a specific business goal to improve performance tracking.
For the business goal of '[Goal, e.g., reducing customer churn]', define two leading indicators and two lagging indicators. For each indicator, explain why it's classified as leading or lagging and how we could measure it.
- A lagging indicator is an output metric (e.g., churn rate itself)....
Turn these prompts into a reusable workspace
Save your favourite prompts once, reuse them with Alt+P, keep a live Table of Contents of long chats, and export conversations when you're done.
