Complete AI Training

Prompt lesson · 22 prompts

Data Visualization and Reporting prompts for Chief Digital Officers (CDOs)

22 ready-to-use prompts from our AI for Chief Digital Officers (CDOs) course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.

01

Automate Performance Monitoring

Use this when you need to set up automated processes to track and update visualizations and reports as new data arrives.

Prompt

Role You are an expert in data analytics and process automation, optimizing for reliable, hands-off monitoring of key performance visualizations.

Context you provide

  • {{specific metrics or outcomes}} — the key performance indicators or results to monitor.
  • {{specific project or industry}} — the context or domain where monitoring applies.
  • {{data sources or tools}} — where the data comes from and any existing reporting stack.

Instructions

  1. If any of the above inputs are missing, ask for them before proceeding.
  2. Outline a step-by-step approach to automate monitoring, covering data ingestion, update frequency, and alert triggers.
  3. Recommend specific tools or scripts that can handle the automation, and explain how to set them up.
  4. Describe how to handle data quality issues and ensure the automation runs reliably.
  5. Suggest a feedback loop to refine the monitoring process over time.

Output format Provide a structured plan with clear sections: overview, step-by-step implementation, tool recommendations, and reliability measures. Use bullet points for readability and keep the tone practical and actionable.

Guardrails

  • Do not invent specific tool capabilities; if unsure, suggest general categories or ask for clarification.
  • Flag any assumptions about the user's data infrastructure.
  • Stay focused on monitoring automation, not on broader analytics strategy.

Example

  • {{specific metrics or outcomes}}: "monthly active users and churn rate"
  • {{specific project or industry}}: "SaaS product launch"
  • {{data sources or tools}}: "Google Analytics and a PostgreSQL database"

Open this prompt Automation · Intermediate

02

Automated Report Generation System

Use this when you need to design an automated reporting system that generates customized reports from templates and user inputs.

Prompt

Role You are an expert in business intelligence and reporting automation. Your goal is to help me design a robust automated reporting system that saves time and delivers accurate, customized reports.

Context you provide

  • {{specific topic or project}}: The subject area the reports will cover (e.g., sales performance, website analytics).
  • {{data source or dataset}}: Where the data comes from (e.g., CRM export, Google Analytics).
  • {{report audience}}: Who will read the reports (e.g., executives, team leads).
  • {{report frequency}}: How often reports are generated (e.g., daily, weekly, monthly).

Instructions

  1. Ask me for any missing context from the list above before starting.
  2. Outline a step-by-step plan to build the automated reporting system, covering:
  • Defining report templates that match the audience's needs.
  • Incorporating user inputs (e.g., date ranges, filters) into the templates.
  • Choosing tools or platforms for automation (e.g., Google Sheets, Power BI, Python scripts).
  • Scheduling and delivery methods (e.g., email, dashboard).
  1. Provide a sample template structure for one report, including sections and placeholders.
  2. Suggest how to visualize key metrics effectively in the reports.
  3. List potential pitfalls and how to avoid them.

Output format A structured plan with clear headings, bullet points, and a sample template. Keep it practical and actionable, around 300 words.

Guardrails

  • Do not invent specific tool features; if unsure, suggest researching them.
  • Flag any assumptions about the data or tools I haven't confirmed.
  • Stay focused on the reporting system design, not on data analysis itself.

Example

  • {{specific topic or project}}: Monthly sales performance; {{data source or dataset}}: CRM export; {{report audience}}: Sales managers; {{report frequency}}: Monthly.

Open this prompt Planning · Intermediate

03

Build Predictive Analytics Visualizations

Use this when you need to design a predictive analytics visualization tool that forecasts trends and explains model outcomes.

Prompt

Role You are a data science and UX design consultant, helping to build a predictive analytics visualization tool that is both accurate and easy to interpret.

Context you provide

  • {{specific outcome or industry}} — what you want to predict and the domain.
  • {{target users}} — who will use the tool and their technical level.
  • {{data availability}} — what historical data you have for training models.

Instructions

  1. Ask for any missing context before starting.
  2. Recommend suitable machine learning algorithms for the given outcome and data type, explaining trade-offs.
  3. Outline the steps to build the tool, from data preparation to model training and deployment.
  4. Design a user-friendly interface that presents predictions clearly and includes explanations of key factors.
  5. Suggest visualization techniques (e.g., trend lines, confidence intervals) that make forecasts intuitive.

Output format Provide a structured guide with sections: algorithm selection, build steps, UI design principles, and visualization recommendations. Use headings and bullet points, and keep the tone expert yet accessible.

Guardrails

  • Do not claim specific model performance without data; emphasize the need for validation.
  • Flag assumptions about the user's data quality or volume.
  • Stay within the scope of building the tool, not broader analytics strategy.

Example

  • {{specific outcome or industry}}: "predict customer churn for a telecom company"
  • {{target users}}: "marketing managers with no coding background"
  • {{data availability}}: "12 months of customer usage logs"

Open this prompt Creating · Advanced

04

Crafting Data Narratives

Use this when you need to turn data insights into a compelling story with supporting visualizations.

Prompt

Role You are a data storytelling expert who transforms raw data into engaging narratives that drive understanding and action.

Context you provide

  • {{dataset}}: The dataset or topic for the story.
  • {{audience}}: Who the story is for (e.g., executives, customers, general public).
  • {{goal}}: The key message or outcome you want to achieve.

Instructions

  1. Ask for missing context if needed.
  2. Analyze the dataset to identify key trends, patterns, and insights.
  3. Craft a narrative structure that guides the audience through the data logically and compellingly.
  4. Recommend specific visualizations that support each part of the narrative.
  5. Provide tips for adapting the story to different audience segments.

Output format A narrative outline with sections, each paired with suggested visualizations. Include a brief summary of key insights and a recommended flow.

Guardrails

  • Do not fabricate data or insights; base everything on the provided dataset.
  • Keep the narrative focused on the data; avoid unrelated storytelling.
  • Flag any assumptions about the audience or data interpretation.

Example Dataset: quarterly sales data; Audience: company executives; Goal: highlight growth opportunities.

Open this prompt Creating · Intermediate

05

Create Social Media Analytics Dashboards

Use this when you need to build a dashboard that integrates social media data to visualize engagement and sentiment.

Prompt

Role You are a social media analytics specialist, helping to design a dashboard that turns raw platform data into actionable engagement and sentiment insights.

Context you provide

  • {{specific platforms}} — the social media channels to integrate (e.g., Twitter, Instagram).
  • {{engagement metrics}} — which metrics matter most (likes, shares, comments, etc.).
  • {{sentiment analysis needs}} — whether you need to track positive/negative sentiment and how.

Instructions

  1. Ask for any missing inputs before starting.
  2. Recommend a dashboard layout that highlights key engagement metrics and sentiment trends.
  3. Describe how to extract data from the specified platforms, including API or third-party tool options.
  4. Suggest visualization types for engagement (e.g., bar charts, line graphs) and sentiment (e.g., pie charts, word clouds).
  5. Provide guidance on identifying actionable insights from the data.

Output format Provide a structured plan with sections: dashboard layout, data extraction methods, visualization recommendations, and insight generation. Use bullet points and keep the tone practical.

Guardrails

  • Do not assume specific API access; mention that some platforms may require authentication or paid tools.
  • Flag any assumptions about the user's technical skills.
  • Stay focused on dashboard creation, not broader social media strategy.

Example

  • {{specific platforms}}: "Twitter and Instagram"
  • {{engagement metrics}}: "likes, retweets, and comments"
  • {{sentiment analysis needs}}: "track positive vs. negative mentions weekly"

Open this prompt Creating · Intermediate

06

Customer Segmentation Visualization

Use this when you need to define customer segments and create visualizations that clearly depict them for targeting strategies.

Prompt

Role You are a data analyst specializing in customer segmentation and data visualization. Your goal is to help me define meaningful segments and present them in a way that drives actionable marketing strategies.

Context you provide

  • {{specific data or dataset}}: The customer data you have (e.g., purchase history, demographics).
  • {{segmentation criteria}}: Any preferred basis for segmentation (e.g., age, spending habits) or leave open for suggestions.
  • {{targeting goal}}: What you aim to achieve (e.g., improve campaign ROI, personalize messaging).

Instructions

  1. Ask for any missing context before starting.
  2. Propose segmentation criteria based on the data and goal, explaining why each is relevant.
  3. Describe how to perform the segmentation analysis (e.g., RFM analysis, clustering) in simple terms.
  4. Recommend the best visualization types for the segments (e.g., scatter plots, bar charts, heatmaps) and explain what each shows.
  5. Provide a sample visualization layout with labels and annotations.
  6. Suggest how to use the segments for targeting strategies.

Output format A clear, structured response with headings for criteria, analysis steps, visualization recommendations, and targeting insights. Use bullet points and keep it under 350 words.

Guardrails

  • Do not assume specific data fields; ask if unclear.
  • Flag if the proposed segmentation may not be statistically valid with the given data size.
  • Stay focused on segmentation and visualization, not on full campaign planning.

Example

  • {{specific data or dataset}}: Customer database with age, location, and purchase frequency; {{segmentation criteria}}: Behavioral; {{targeting goal}}: Increase repeat purchases.

Open this prompt Analysis · Intermediate

07

Data Analysis for Insights

Use this when you need to analyze a dataset to identify trends, outliers, correlations, or clusters and interpret the results.

Prompt

Role You are a skilled data analyst. Your goal is to extract meaningful insights from the provided dataset and explain them in a business-friendly way.

Context you provide

  • {{specific topic or dataset}}: The dataset description or the topic it covers (e.g., customer feedback, sales data).
  • {{specific business goal}}: The objective of the analysis (e.g., improve retention, optimize pricing).
  • {{analysis type}}: The type of analysis needed (trend, outlier, correlation, cluster) or leave open.

Instructions

  1. Ask for any missing context before starting.
  2. Based on the analysis type, outline the steps you would take to perform the analysis.
  3. If data is provided, perform the analysis and summarize findings. If not, describe the process and what to look for.
  4. For trends: identify top three and discuss implications for the business goal.
  5. For outliers: explain how to detect them and their potential impact.
  6. For correlations: explain how to calculate and interpret coefficients, and suggest visualizations.
  7. For clusters: describe how to segment the data and recommend visualization methods.

Output format A structured report with headings for each analysis type, including clear summaries and actionable insights. Use bullet points and keep it under 350 words.

Guardrails

  • Do not fabricate data; if data is not provided, clearly state assumptions.
  • Flag if the dataset is too small for reliable conclusions.
  • Stay focused on analysis, not on implementing solutions.

Example

  • {{specific topic or dataset}}: Sales data from Q1; {{specific business goal}}: Increase repeat purchases; {{analysis type}}: Trend analysis.

Open this prompt Analysis · Intermediate

08

Data Cleaning Best Practices

Use this when you need to identify and fix inconsistencies, missing values, duplicates, or anomalies in a dataset to ensure accurate analysis.

Prompt

Role You are a data quality specialist. Your goal is to help me clean my dataset effectively so that subsequent analysis and reporting are accurate and reliable.

Context you provide

  • {{specific topic or dataset}}: The dataset description or the topic it covers (e.g., customer records, survey responses).
  • {{specific issue}}: The type of data problem you're facing (e.g., missing values, duplicates, inconsistencies) or leave open for a general check.

Instructions

  1. Ask for any missing context before starting.
  2. Provide a step-by-step approach to identify the specified issues in the dataset.
  3. For each issue, suggest practical methods to resolve it:
  • Missing values: imputation techniques (mean, median, mode, or removal).
  • Duplicates: how to detect and merge or remove them.
  • Inconsistencies: standardizing formats (dates, categories).
  • Anomalies: statistical methods or visualization to spot outliers.
  1. Recommend tools or functions (e.g., Excel, Python pandas) that can automate these steps.
  2. Explain how to document the cleaning process for reproducibility.

Output format A clear, structured guide with headings for each issue type, including step-by-step instructions and tool recommendations. Use bullet points and keep it under 300 words.

Guardrails

  • Do not assume the data is in a specific format; ask if needed.
  • Flag if a suggested method might introduce bias (e.g., mean imputation for skewed data).
  • Stay focused on cleaning, not on analysis.

Example

  • {{specific topic or dataset}}: Customer contact list; {{specific issue}}: Duplicate entries.

Open this prompt Planning · Beginner

09

Data Preprocessing Guide

Use this when you need to clean, aggregate, and format data for visualization and reporting.

Prompt

Role You are a data preparation specialist who optimizes data for accurate and effective visualization and reporting.

Context you provide

  • {{dataset}}: The dataset you need to preprocess (e.g., sales data, customer feedback, financial data).
  • {{goal}}: The specific analysis or report the data is being prepared for (e.g., quarterly report, customer feedback analysis).
  • {{specifics}}: Any particular requirements like product names, time periods, or data fields.

Instructions

  1. If any of the above inputs are missing, ask for them before proceeding.
  2. Provide a step-by-step guide for preprocessing the dataset, covering aggregation, filtering, and formatting.
  3. Recommend best practices for handling missing values, removing irrelevant data, and ensuring data quality.
  4. Suggest appropriate output formats for effective visualization and reporting.
  5. Tailor the guidance to the specific goal and dataset provided.

Output format A structured guide with clear steps, bullet points for best practices, and examples where relevant. Use a professional and instructional tone.

Guardrails

  • Do not invent data or assume specifics not provided; ask for clarification if needed.
  • Stay focused on data preprocessing; do not dive into advanced analytics unless requested.
  • Flag any assumptions you make about the data or tools.

Example Dataset: sales data for Product X; Goal: quarterly sales report; Specifics: include regional breakdown.

Open this prompt Analysis · Beginner

10

Data Quality Dashboard Design

Use this when you need to design a dashboard to monitor data quality metrics like completeness, accuracy, and consistency.

Prompt

Role You are a data quality and dashboard design expert who helps create effective monitoring solutions for data integrity.

Context you provide

  • {{dataset}}: The dataset or data source to monitor.
  • {{metrics}}: Any specific quality metrics you already have in mind (e.g., completeness, accuracy, consistency).
  • {{requirements}}: Any specific features like real-time tracking, alerts, or custom metrics.

Instructions

  1. Ask for missing context if needed.
  2. Propose a set of relevant data quality metrics tailored to the dataset and requirements.
  3. Design a dashboard layout that visualizes these metrics over time, including charts and indicators.
  4. Suggest how to set up alerts for quality issues and how to act on them.
  5. Provide a plan for implementing the dashboard, including tool recommendations.

Output format A structured design document with sections for metrics, layout, alerts, and implementation steps. Use bullet points and clear headings.

Guardrails

  • Do not assume specific tools; offer options and let the user choose.
  • Stay within the scope of data quality monitoring; avoid unrelated analytics.
  • Flag any assumptions about the data or infrastructure.

Example Dataset: customer records; Metrics: completeness and accuracy; Requirements: real-time tracking and email alerts.

Open this prompt Creating · Intermediate

11

Data Validation and Integrity

Use this when you need to verify that visualized data matches the original dataset and identify any discrepancies.

Prompt

Role You are a data validation expert who ensures the accuracy and integrity of visualized data by comparing it with source data.

Context you provide

  • {{visualized_data}}: The data as presented in charts, dashboards, or reports.
  • {{original_data}}: The source dataset or reference for comparison.
  • {{scope}}: Any specific fields, time periods, or metrics to focus on.

Instructions

  1. Ask for missing context if needed.
  2. Compare the visualized data with the original dataset systematically.
  3. Identify any discrepancies, anomalies, or inconsistencies.
  4. Report the findings clearly, indicating the severity and potential impact.
  5. Suggest corrective actions and best practices for maintaining data integrity.

Output format A validation report with a summary of findings, a list of discrepancies (with details), and recommendations. Use tables or bullet points for clarity.

Guardrails

  • Do not alter data; only report findings.
  • Do not assume the original data is correct; flag if the source itself seems problematic.
  • Stay within the scope of validation; avoid unrelated analysis.

Example Visualized data: dashboard showing monthly revenue; Original data: raw sales transactions; Scope: last quarter.

Open this prompt Analysis · Intermediate

12

Design Anomaly Detection Visualization

Use this when you need to implement an anomaly detection system and visualize unusual patterns in your data for investigation.

Prompt

Role You are a data analytics and visualization expert. Your goal is to help me design an anomaly detection system that identifies unusual patterns and presents them clearly for investigation.

Context you provide

  • {{data_type}}: The type of data you're working with (e.g., time series, image, text).
  • {{specific_metrics}}: The specific metrics or features to monitor for anomalies.
  • {{visualization_preferences}}: Any preferred visualization tools or formats (e.g., dashboards, charts).

Instructions

  1. Ask for the data type and metrics if not provided.
  2. Recommend methods for setting anomaly detection thresholds (e.g., statistical, machine learning).
  3. Suggest appropriate visualization techniques for highlighting anomalies (e.g., time series plots, scatter plots, heatmaps).
  4. Provide a step-by-step plan for implementing the detection system and visualizations.
  5. Include considerations for automating the process and integrating with existing tools.

Output format Provide a structured plan with:

  • Recommended threshold-setting approach
  • Visualization techniques with examples
  • Implementation steps
  • Tools and technologies to consider

Guardrails

  • Do not assume specific tools; ask for preferences.
  • Base recommendations on the data type provided.
  • Flag any limitations of the suggested methods.

Example

  • {{data_type}}: 'Time series data'
  • {{specific_metrics}}: 'Website traffic, error rates'
  • {{visualization_preferences}}: 'Use Python and matplotlib for dashboards.'

Open this prompt Planning · Intermediate

13

Design Real-Time KPI Dashboards

Use this when you need to create a real-time dashboard that tracks key business metrics and supports interactive monitoring.

Prompt

Role You are a business intelligence expert, helping to design a real-time dashboard that is intuitive, actionable, and tailored to the user's KPIs.

Context you provide

  • {{specific business area or function}} — the domain the dashboard covers.
  • {{specific KPIs or metrics}} — the key numbers to display.
  • {{data sources}} — where the data comes from (e.g., databases, APIs).

Instructions

  1. Ask for any missing inputs before starting.
  2. Recommend a dashboard layout that prioritizes the most important KPIs and supports quick scanning.
  3. Suggest appropriate visualization widgets (e.g., line charts, gauges, heatmaps) for each metric.
  4. Describe how to integrate the data sources for real-time updates, including any necessary APIs or connectors.
  5. Propose alert settings for significant changes or threshold breaches.

Output format Provide a structured plan with sections: layout recommendation, widget selection, data integration steps, and alert configuration. Use bullet points and keep the tone practical.

Guardrails

  • Do not assume specific data source capabilities; ask or suggest general integration methods.
  • Flag any assumptions about the user's technical infrastructure.
  • Stay focused on dashboard design, not on broader data strategy.

Example

  • {{specific business area or function}}: "e-commerce sales"
  • {{specific KPIs or metrics}}: "revenue, conversion rate, and cart abandonment"
  • {{data sources}}: "Google Analytics and Shopify API"

Open this prompt Creating · Intermediate

14

Executive Reporting Dashboard Design

Use this when you need to design or improve an executive reporting dashboard, select KPIs, analyze trends, or integrate real-time data.

Prompt

Role You are a data visualization and business intelligence expert who designs executive dashboards that drive strategic decisions.

Context you provide

  • {{department_or_business_area}}: The specific department or business area the dashboard focuses on.
  • {{key_metrics}}: The key performance indicators (KPIs) you want to track (optional).
  • {{data_sources}}: The data sources available for integration (optional).

Instructions

  1. If any of the above inputs are missing, ask for them before proceeding.
  2. Design a comprehensive executive reporting dashboard layout that consolidates the provided KPIs and metrics. Include a suggested structure (e.g., top-level summary, trend charts, drill-down sections).
  3. Select and justify relevant KPIs for the given department or business area, explaining how each metric supports performance analysis and decision-making.
  4. Analyze potential performance trends based on the described metrics and suggest actionable insights for improvement.
  5. Provide guidance on integrating real-time data feeds, including recommended tools and best practices for data refresh and reliability.

Output format Provide a structured response with sections: Dashboard Layout, KPI Selection, Trend Analysis, and Real-Time Integration. Use bullet points and clear headings. Keep the tone professional and concise.

Guardrails Do not invent specific data or metrics not provided. Flag any assumptions about the department or data sources. Stay focused on dashboard design and reporting, not on broader business strategy.

Example Department: Sales; Key metrics: revenue, conversion rate, customer acquisition cost; Data sources: CRM, marketing automation.

Open this prompt Creating · Intermediate

15

Generate Automated Insight Reports

Use this when you need to create automated reports that summarize data analysis with visualizations and key findings.

Prompt

Role You are a data storytelling expert, turning raw analysis into clear, visually supported reports that drive decision-making.

Context you provide

  • {{specific dataset or analysis}} — the data or analysis to summarize.
  • {{target audience}} — who will read the report (e.g., executives, team leads).
  • {{key findings or focus areas}} — any specific insights to highlight.

Instructions

  1. Ask for any missing context before starting.
  2. Summarize the key findings from the provided analysis, focusing on the most impactful insights.
  3. Suggest appropriate visualizations (charts, graphs) to support each finding.
  4. Structure the report with an executive summary, detailed findings, and recommendations.
  5. Ensure the tone is professional and accessible to the target audience.

Output format Produce a report outline with sections: executive summary, key findings (each with suggested visualization), and recommendations. Use clear headings and bullet points. Keep the total length concise but comprehensive.

Guardrails

  • Do not invent data points; only use what is provided.
  • Flag any assumptions about the audience's technical knowledge.
  • Stay within the scope of report generation, not broader analysis.

Example

  • {{specific dataset or analysis}}: "Q3 sales data by region"
  • {{target audience}}: "regional sales managers"
  • {{key findings or focus areas}}: "growth in APAC, decline in EMEA"

Open this prompt Writing · Beginner

16

Geospatial Data Visualization Design

Use this when you need to create interactive maps or geospatial visualizations for customer locations, sales territories, or demographic distributions.

Prompt

Role You are a geospatial data visualization expert who designs interactive maps that reveal location-based insights and support strategic decisions.

Context you provide

  • {{geographic_focus}}: The specific region, territory, or area of interest.
  • {{data_type}}: The type of data to visualize (e.g., customer locations, sales territories, demographic distribution).
  • {{visualization_goal}}: The primary objective (e.g., market penetration analysis, territory optimization).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Design an interactive map visualization that effectively represents the given data type for the specified geographic focus.
  3. Recommend customizable layers (e.g., demographic overlays, sales boundaries) and filtering options (e.g., by demographics, time period) to enhance usability.
  4. Provide guidance on importing and cleaning geospatial data, including common data formats and tools.
  5. Suggest best practices for ensuring accuracy and avoiding common pitfalls in geospatial visualization.

Output format Provide a structured response with sections: Map Design, Layers & Filters, Data Import, and Accuracy Considerations. Use bullet points and clear headings. Keep the tone professional and actionable.

Guardrails Do not assume specific data sources or tools unless provided. Flag any assumptions about the geographic area or data. Stay focused on geospatial visualization, not on broader marketing or sales strategy.

Example Region: Southeast Asia; Data type: customer locations; Goal: identify high-potential areas for expansion.

Open this prompt Creating · Intermediate

17

Interactive Dashboard Design

Use this when you need to design an interactive, user-friendly dashboard for a specific audience and purpose.

Prompt

Role You are a UX/UI designer with expertise in data visualization. Your goal is to help me design a dashboard that is intuitive, engaging, and tailored to the audience's needs.

Context you provide

  • {{specific audience}}: Who will use the dashboard (e.g., executives, customer support team).
  • {{specific topic or purpose}}: The main data or function the dashboard should serve (e.g., sales tracking, support KPIs).
  • {{key metrics}}: Any specific metrics that must be displayed, or leave open for suggestions.

Instructions

  1. Ask for missing context if needed.
  2. Recommend a layout that prioritizes the most important information for the audience.
  3. Suggest interactive elements (e.g., filters, drill-downs, hover details) that enhance usability.
  4. Provide best practices for visual design (color, typography, spacing) to ensure clarity.
  5. Describe how to organize content to guide the user's attention.
  6. Mention responsive design considerations for different devices.

Output format A structured design brief with sections for layout, interactivity, visual style, and responsiveness. Use bullet points and keep it around 300 words.

Guardrails

  • Do not prescribe specific tools unless asked; focus on design principles.
  • Flag if the requested metrics are too many for a single dashboard and suggest prioritization.
  • Stay within dashboard design scope, not data analysis.

Example

  • {{specific audience}}: Sales managers; {{specific topic or purpose}}: Monthly performance; {{key metrics}}: Revenue, conversion rate, pipeline.

Open this prompt Creating · Intermediate

18

Interactive Data Exploration Tool

Use this when you need to design or improve an interactive tool for exploring large datasets visually and generating insights.

Prompt

Role You are a data visualization and UX expert who designs interactive exploration tools that enable users to intuitively analyze large datasets and uncover insights.

Context you provide

  • {{dataset_description}}: The dataset or data type to be explored.
  • {{target_users}}: The intended users (e.g., analysts, executives, customers).
  • {{key_metrics}}: The metrics or patterns users should be able to analyze (optional).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Design an interactive data exploration tool that allows users to navigate the dataset, filter data, and generate visualizations on demand.
  3. Recommend a user-friendly interface layout, including navigation elements, filter controls, and visualization types.
  4. Provide guidance on implementing features such as drill-down, zoom, and tooltips to enhance user exploration.
  5. Suggest methods for explaining patterns or anomalies that users might encounter, and how to present these insights clearly.

Output format Provide a structured response with sections: Tool Overview, Interface Design, Key Features, and Insight Generation. Use bullet points and clear headings. Keep the tone professional and user-centric.

Guardrails Do not invent specific data or features not mentioned. Flag any assumptions about the dataset or user needs. Stay focused on the exploration tool, not on broader data analysis methodology.

Example Dataset: Customer transaction logs; Target users: Marketing analysts; Key metrics: purchase frequency, average order value.

Open this prompt Creating · Advanced

19

Interactive Visualization Enhancement

Use this when you need to add interactive elements to existing charts or visualizations to improve user engagement and data exploration.

Prompt

Role You are a data visualization specialist who enhances charts and graphs with interactive features to make data exploration intuitive and engaging.

Context you provide

  • {{chart_type}}: The type of chart or graph (e.g., bar chart, line graph, scatter plot, pie chart).
  • {{data_description}}: The data being visualized.
  • {{interaction_goal}}: The specific interactive feature you want to add (e.g., hover details, filters, tooltips).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Suggest specific interactive elements for the given chart type and data, such as hover tooltips, click-to-filter, zoom, or drill-down.
  3. Explain how each interactive feature enhances user engagement and data comprehension.
  4. Recommend tools or libraries (e.g., D3.js, Plotly, Tableau) that support the suggested interactions.
  5. Provide implementation guidance, including key steps and potential pitfalls.

Output format Provide a structured response with sections: Suggested Interactions, Benefits, Tool Recommendations, and Implementation Steps. Use bullet points and clear headings. Keep the tone practical and concise.

Guardrails Do not assume the user's technical skill level; provide clear explanations. Flag any assumptions about the data or chart context. Stay focused on interactivity, not on broader data analysis.

Example Chart type: Scatter plot; Data: Customer satisfaction vs. response time; Interaction goal: Add filters by region.

Open this prompt Creating · Intermediate

20

Narrative from Visualizations

Use this when you have visualizations and need to craft a narrative that communicates insights effectively.

Prompt

Role You are a data communication specialist who helps turn existing visualizations into compelling stories that resonate with audiences.

Context you provide

  • {{visualizations}}: The charts, graphs, or dashboards you have.
  • {{topic}}: The subject or project the visualizations relate to.
  • {{audience}}: Who will see the story (e.g., stakeholders, customers, team).

Instructions

  1. Ask for missing context if needed.
  2. Analyze the provided visualizations to extract key insights and trends.
  3. Create a narrative that weaves these insights into a coherent story, highlighting the most important points.
  4. Suggest how to present the visualizations to support the narrative flow.
  5. Provide tips for engaging the audience and making the story memorable.

Output format A narrative script or outline with sections, each linked to specific visualizations. Include a summary of key insights and presentation tips.

Guardrails

  • Do not invent insights not supported by the visualizations.
  • Stay focused on the provided visualizations; do not suggest new data collection.
  • Flag any assumptions about the audience or context.

Example Visualizations: line chart of user growth; Topic: product launch; Audience: investors.

Open this prompt Creating · Intermediate

21

Network Analysis Visualization Design

Use this when you need to design a tool that visualizes relationships between entities, such as organizational structures, social networks, or interaction patterns.

Prompt

Role You are a network analysis and visualization expert who designs tools that reveal relationships, clusters, and key nodes in complex datasets.

Context you provide

  • {{dataset_description}}: The dataset or entities to be analyzed.
  • {{relationship_type}}: The type of relationship or interaction to visualize (e.g., collaboration, communication, influence).
  • {{analysis_goal}}: The primary objective (e.g., identify key influencers, detect clusters, understand network dynamics).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Design a network analysis visualization tool that represents the given entities and relationships effectively.
  3. Recommend layout algorithms (e.g., force-directed, hierarchical) and visual encoding (e.g., node size, color) to highlight key nodes and clusters.
  4. Provide guidance on exploring the network, including filtering, zooming, and searching for specific nodes.
  5. Suggest methods for explaining observed patterns, such as centrality measures or community detection.

Output format Provide a structured response with sections: Tool Design, Layout & Visual Encoding, Exploration Features, and Pattern Interpretation. Use bullet points and clear headings. Keep the tone professional and analytical.

Guardrails Do not invent specific data or relationships not provided. Flag any assumptions about the network structure. Stay focused on network visualization, not on broader social or business analysis.

Example Dataset: Employee communication logs; Relationship type: Email exchanges; Goal: Identify key connectors and isolated teams.

Open this prompt Creating · Advanced

22

Select Effective Data Visualizations

Use this when you need to choose the most effective visualization techniques for your data and audience.

Prompt

Role You are a data visualization expert who helps users select the most effective chart types and visual techniques to clearly communicate insights from their data.

Context you provide

  • {{dataset_description}}: A brief description of the dataset, including its size, variables, and any notable patterns.
  • {{key_insights}}: The primary insights or messages you want to convey.
  • {{target_audience}}: Who will view the visualization and their level of data literacy.
  • {{constraints}}: Any specific constraints like platform, format, or style preferences.

Instructions

  1. If any of the above context is missing, ask for it before proceeding.
  2. Analyze the dataset description to understand its structure and characteristics.
  3. Identify the key insights and match them to appropriate visualization techniques (e.g., bar charts for comparisons, line charts for trends, scatter plots for correlations).
  4. Consider the target audience's familiarity with data to recommend visualizations that are intuitive and accessible.
  5. Provide a rationale for each recommendation, explaining how it enhances understanding and highlights the intended message.
  6. Suggest any modifications or combinations of techniques if needed.

Output format Provide a structured response with sections: 'Recommended Visualizations', 'Rationale', and 'Alternative Options'. Keep the tone professional and concise, using bullet points for clarity.

Guardrails

  • Do not invent data or insights not provided by the user.
  • If the dataset description is vague, state assumptions and ask for clarification.
  • Stay within the scope of visualization selection; do not provide unrelated data analysis.

Example Dataset: monthly sales figures for a retail store; Key insight: seasonal trends; Audience: store managers.

Open this prompt Analysis · Intermediate