ChatGPT Prompts for Data Analyst Dashboard Summaries
As a data analyst, you spend hours interpreting complex dashboards. ChatBoost accelerates your workflow by turning raw data and visualizations into clear, concise summaries with a single click. Use our curated prompt library (Alt+P) to instantly generate executive summaries, identify key trends, and articulate insights, making your reporting 3-5x faster.
Summarize key KPIs for executives, focusing on business impact and critical insights.
Act as a senior data analyst. Based on the following KPI data, write a 3-bullet point executive summary for a non-technical audience. Focus on business impact and key takeaways. Data:
[Paste your KPI data: e.g., Metric, Current Value, Previous Value, % Change]
Uncover Top Positive Data Trends
Pinpoint and explain the most significant positive trends, their magnitude, and business implications.
Analyze the provided time-series data. Identify the top 3 most significant positive trends. For each trend, briefly explain the metric, the magnitude of the change, and its potential business implication. Data:
[Paste time-series data, e.g., Date, Metric1, Metric2, ...]
Detect Critical Negative Trends
Isolate and articulate the most concerning negative trends, their impact, and potential root causes.
Analyze the provided performance data. Identify the top 3 most concerning negative trends. For each, state the metric, the negative change, and suggest a potential root cause to investigate. Data:
[Paste performance data with period-over-period comparison]
Interpret Bar Chart Insights
Translate complex bar chart visualizations into concise, actionable summaries.
I have a bar chart with the following characteristics. Provide a summary of the key insights.
- Title: [Chart Title]...
Narrate Line Graph Trends
Narrate the story of a line graph, detailing overall trends, peaks, troughs, and rates of change.
Summarize the story told by this line graph. Identify the overall trend, any significant peaks or troughs, and the rate of change between key points.
- Title: [Chart Title]...
Generate Actionable Data Recommendations
Generate concrete, data-driven recommendations with clear 'What,' 'Why,' and 'Expected Outcome.'
Given the following data insights, propose 3 concrete, data-driven recommendations. For each recommendation, state the 'What', 'Why' (based on the data), and 'Expected Outcome'.
Insights:...
Identify Data Anomalies & Outliers
Scan time-series data to identify significant anomalies, their values, and possible causes.
Review the following daily metric data. Identify any significant anomalies or outliers that deviate from the expected pattern. For each anomaly, specify the date, the metric value, and a possible hypothesis for its cause.
Data:...
Compare Period-Over-Period Performance
Summarize performance comparison between two periods, highlighting significant changes and overall trends.
Write a summary comparing this week's performance to last week's based on the data below. Highlight the most significant percentage changes (both positive and negative) and provide a concluding sentence on the overall weekly trend.
Data:...
Analyze Scatter Plot Relationships
Analyze scatter plots to describe variable relationships, correlation strength, and outliers.
Describe the relationship between the two variables in this scatter plot. Is the correlation positive, negative, or non-existent? Is the relationship strong or weak? Are there any obvious outliers?
- Title: [Chart Title]...
Optimize Conversion Funnels
Analyze conversion funnel data to calculate drop-off rates, identify bottlenecks, and suggest improvements.
Analyze the following user conversion funnel data. Calculate the conversion rate at each step and the drop-off rate between steps. Identify the stage with the highest drop-off and suggest one reason why this might be happening.
Funnel Data:...
Develop Testable Data Hypotheses
Formulate clear, testable hypotheses from data observations in an 'If-Then-Because' format.
Based on the following observation, formulate a clear, testable hypothesis in the 'If we [action], then [expected outcome] because [reasoning]' format.
Observation: [e.g., 'Mobile users have a 30% lower conversion rate than desktop users, but they view twice as many product pages.']
Break Down Monthly Recurring Revenue (MRR) Changes
Explain net MRR growth by analyzing New, Expansion, Churn, and Contraction components.
Summarize the Monthly Recurring Revenue (MRR) changes based on the following data. Explain the net MRR growth and highlight which component (New, Expansion, Churn, or Contraction) had the biggest impact.
Data:...
Extract Heatmap Insights for UX
Interpret heatmap data to identify 'hot' and 'cold' spots, revealing user behavior implications.
I have a heatmap of user clicks on our main dashboard. Describe the key insights. Where are the 'hot spots' (most clicks) and 'cold spots' (fewest clicks)? What does this imply about user behavior?
Heatmap Description:...
Formulate Critical Business Questions from Data
Generate critical, high-impact business questions from dashboard data to guide deeper analysis.
Given the following dashboard data, formulate 3 critical business questions that a stakeholder might ask. The questions should prompt deeper analysis.
Data Summary:...
Summarize Customer Churn Analysis
Provide a concise summary of churn rate, comparing trends and identifying primary business risks.
Summarize the customer churn analysis below. State the monthly churn rate, compare it to the previous month, and mention the leading reason for churn if available. What is the primary business risk this poses?
Data:...
Tailor Data Summaries by Department
Rewrite general data summaries, focusing on metrics and insights relevant to specific departments like Marketing or Product.
Rewrite the following general data summary specifically for the [Marketing/Product/Sales] team. Focus only on the metrics and insights relevant to their goals.
General Summary:...
Qualitative Metric Forecasting
Generate qualitative forecasts for key metrics based on historical trends, stating expected direction and justification.
Based on the historical data and trend for the past 6 months, provide a qualitative forecast for [Metric Name] for the next month. Mention if you expect it to increase, decrease, or stay flat, and provide a one-sentence justification.
Data:...
Interpret Pie Chart Distributions
Summarize key takeaways from pie charts, highlighting dominant categories and their proportions.
Summarize the key takeaway from a pie chart with the following data. Highlight the top 2 categories that make up the majority of the whole.
- Title: [Chart Title, e.g., 'Website Traffic by Source']...
Compare User Segment Performance
Analyze user segmentation data to compare performance, identify highest/lowest performing segments, and key behavioral differences.
Analyze the following user segmentation data. Which segment is the highest-performing and which is the lowest-performing based on [Key Metric, e.g., 'Conversion Rate']? State one key difference in their behavior.
Data:...
Craft Impactful Data Headlines
Condense critical data insights into punchy, attention-grabbing headlines for stakeholders.
Based on the data insight below, write a single, impactful 'data headline' that grabs a stakeholder's attention.
Insight: [e.g., 'Our new feature, launched last month, now accounts for 40% of all user activity and has reduced churn by 15% among users who adopt it.']
Acknowledge Data Limitations & Biases
Identify potential data limitations or caveats to prevent misinterpretation by stakeholders.
After reviewing the following data and summary, identify one potential limitation or caveat that should be mentioned to stakeholders to ensure they don't misinterpret the results.
Data Summary: [e.g., 'Our user survey shows 90% of respondents love the new feature.']...
Summarize A/B Test Outcomes
Summarize A/B test results for non-technical audiences, declaring the winner, lift, and statistical significance.
Summarize the results of the following A/B test for a non-technical audience. Declare the winning variant, state the primary metric's lift, and confirm if the result is statistically significant.
Test Data:...
Analyze Customer Lifetime Value (LTV) by Channel
Summarize LTV data, comparing performance across acquisition channels and evaluating LTV to CAC ratios.
Analyze the Customer Lifetime Value (LTV) data below. Which acquisition channel brings in the most valuable customers? How does the LTV to CAC ratio look for that channel?
Data:...
Translate Technical Metrics to Business Impact
Translate technical findings into clear business impact statements, connecting them to revenue, cost, or customer satisfaction.
Translate the following technical finding into a business impact statement. Connect the metric to either revenue, cost, or customer satisfaction.
Technical Finding: [e.g., 'We reduced the average page load time from 3.5 seconds to 1.5 seconds.']...
Draft Weekly Performance TL;DR Summaries
Generate concise, 2-sentence 'Too Long; Didn't Read' summaries for weekly performance updates, covering highs and areas for improvement.
Write a 2-sentence TL;DR for a weekly performance update based on these key points. The first sentence should cover the good news, and the second should cover the area for improvement.
Key Points:...
Summarize Sales Pipeline Health
Provide a high-level overview of sales pipeline health, including value, conversion rates, and deal size.
Summarize the health of the sales pipeline based on the following data. Comment on the total pipeline value, the conversion rate from MQL to SQL, and the average deal size.
Data:...
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.
