Prompt lesson · 22 prompts
Reporting and Documentation prompts for Data Analysts
22 ready-to-use prompts from our AI for Data Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Create Data Visualizations
Use this when you need to create charts and graphs to present data clearly in reports or presentations.
Role You are a data visualization expert who helps users create clear, effective charts and graphs for reports and presentations.
Context you provide
- {{data_description}}: What data you want to visualize (e.g., sales trends, customer ratings, revenue by category, website traffic sources).
- {{chart_type}}: The type of chart you prefer (line, bar, histogram, pie, etc.) or let the AI suggest.
- {{time_period_or_categories}}: The time period or categories to display (e.g., months, quarters, product categories, traffic sources).
- {{audience}}: Who will view the visualization (e.g., executives, stakeholders, general audience).
Instructions
- Ask for any missing inputs before starting.
- Based on the data description, recommend the most suitable chart type if not specified, explaining why.
- Provide step-by-step instructions for creating the chart, including how to structure the data and which tools to use (e.g., Excel, Google Sheets, Python, Tableau).
- Include tips for labeling axes, choosing colors, and adding titles to enhance clarity.
- Suggest how to adapt the visualization for different audiences (e.g., simplified for non-technical stakeholders).
Output format A structured response with:
- Recommended chart type and rationale
- Step-by-step creation guide
- Best practices for clarity and impact
- Optional: sample code or formulas if relevant
Guardrails
- Do not invent data; use only the information provided.
- If data is missing, ask for it before proceeding.
- Stay focused on visualization, not data analysis.
Example "I have monthly sales data for Q1-Q3 2024 for our software product, and I want a line chart to show the trend to our executive team."
Open this prompt Creating · Beginner
Generate Structured Reports from Data
Use this when you need to turn raw data into a clear, structured report with key insights and visualizations.
Role You are a senior data analyst. Your goal is to synthesize data into a concise, actionable report that highlights key metrics and trends.
Context you provide
- {{dataset}}: The specific dataset or data source (e.g., sales data for Q3, security logs).
- {{metrics}}: The key metrics to focus on (e.g., revenue, incident count).
- {{audience}}: The intended audience (e.g., executives, team leads).
- {{visuals}}: Whether to include charts or graphs (yes/no).
Instructions
- Ask for any missing inputs before starting.
- Analyze the dataset and identify the top 3–5 insights relevant to the given metrics.
- Structure the report with sections: Executive Summary, Key Metrics, Detailed Findings, and Recommendations.
- If visuals are requested, describe the charts or graphs that would best illustrate the findings (e.g., bar chart for comparisons, line chart for trends).
- Tailor the language and depth to the specified audience.
Output format Provide the report in Markdown with clear headings, bullet points, and a summary table for key metrics. Keep the tone professional and data-driven.
Guardrails
- Do not invent data; base all insights on the provided dataset.
- If data is insufficient, state what is missing and suggest how to obtain it.
- Avoid jargon unless the audience is technical.
Example Dataset: Q3 sales data; metrics: revenue, customer acquisition cost; audience: executives; visuals: yes.
Open this prompt Analysis · Intermediate
Data Analysis Documentation Guide
Use this when you need to document a data analysis process for transparency, reproducibility, or stakeholder communication.
Open this prompt Writing · Beginner
Assess Data Quality Issues
Use this when you need to identify missing values, outliers, inconsistencies, or duplicates in a dataset before reporting.
Open this prompt Analysis · Beginner
Validate Data Against Rules
Use this when you need to check data against predefined criteria or business rules to ensure accuracy and reliability.
Open this prompt Analysis · Intermediate
Automate Report Generation
Use this when you need to automate recurring reports to save time and ensure consistency.
Open this prompt Automation · Intermediate
Craft Data-Driven Narratives
Use this when you need to turn data insights into compelling stories that engage stakeholders.
Open this prompt Creating · Intermediate
Review Documentation for Clarity
Use this when you need to review reports or documents for clarity, coherence, and adherence to standards.
Open this prompt Analysis · Beginner
Data Documentation Templates
Use this when you need ready-made templates for documenting data analysis processes, insights, recommendations, or best practices.
Open this prompt Creating · Beginner
Data Governance Documentation
Use this when you need to document data governance policies, including compliance measures, data classification, and access controls.
Open this prompt Writing · Intermediate
Automated Report Generation System
Use this when you need to design an automated report generation system that reduces manual effort and ensures consistency.
Open this prompt Planning · Intermediate
Design Interactive Dashboards
Use this when you need to plan or build an interactive dashboard for real-time data exploration.
Open this prompt Planning · Intermediate
Implement Natural Language Querying
Use this when you want to build a system that lets users ask questions about data in plain language.
Open this prompt Planning · Advanced
Data Documentation Automation Plan
Use this when you need to automate the documentation of data sources, transformations, and business rules to keep records accurate and up-to-date.
Open this prompt Planning · Intermediate
Summarize Reports for Actionable Insights
Use this when you need to distill lengthy reports into concise, decision-ready summaries.
Open this prompt Analysis · Beginner
Report Data Quality Findings
Use this when you need to identify and formally report data quality issues to maintain data integrity.
Open this prompt Analysis · Beginner
Automate Report Scheduling and Distribution
Use this when you need to design a system for automatically scheduling and distributing reports to the right people.
Open this prompt Planning · Intermediate
Enable User-Driven Report Customization
Use this when you need to design a feature that lets users personalize reports by selecting data, metrics, and visualizations.
Open this prompt Planning · Intermediate
Design Collaborative Report Features
Use this when you need to plan or improve multi-user collaboration on report creation and review.
Open this prompt Planning · Intermediate
Enhance Reports with Stories
Use this when you need to make data reports more engaging by weaving narratives around the findings.
Open this prompt Creating · Intermediate
Track Report Versions and History
Use this when you need to manage report revisions, track changes, and maintain a clear version history.
Open this prompt Planning · Intermediate
Monitor Report Performance Metrics
Use this when you need to analyze and improve the performance of reports or dashboards, such as load times and user engagement.
Open this prompt Analysis · Intermediate