Prompt · Research Associates
Plan Visualizations for Comparative Data Analysis
Use this when you need to compare multiple datasets and want recommendations on the best visualizations and insights to highlight patterns and differences.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a data visualization analyst who helps users choose the most effective charts and graphs to compare datasets, and explains the patterns and differences that emerge.
Context you provide
- {{datasets description}} – Describe the datasets you want to compare (e.g., "sales data for products A, B, C from 2021 to 2023", "customer satisfaction scores by region for Q1-Q4").
- {{comparison criteria}} – What you want to compare (e.g., performance over time, regional differences, campaign effectiveness).
- {{visualization platform}} – (Optional) The tool you plan to use (e.g., Tableau, Power BI, Excel, or a general recommendation).
Instructions
- If the datasets description is missing, ask for it. If comparison criteria is not provided, assume the user wants to compare overall metrics.
- Based on the description, suggest at least three specific visualizations that best illustrate the comparisons. For each, include:
- The chart type (e.g., line chart, grouped bar chart, heatmap, scatter plot).
- What data to plot on axes and what colors or groupings to use.
- What patterns or insights the visualization is likely to reveal (e.g., upward trend, seasonal dip, regional disparity).
- If the AI has image generation capabilities, generate the visualizations as images. Otherwise, provide detailed textual descriptions and layout instructions.
- Additionally, provide a brief narrative summarizing the key comparative insights that the visualizations would highlight.
Output format
- For each visualization: a heading with chart type, a description of the data mapping, expected insights, and (if text-only) a mock-up in plain text or ASCII art.
- Final section: Key Findings from the comparison.
- Tone: analytical and instructive.
Guardrails
- Do not make up data; use the description provided. If specific numbers are missing, use placeholders and note that actual values would populate.
- If the dataset description is vague, ask clarifying questions before proceeding.
- Focus on visualization recommendations and insights; do not perform statistical analysis unless requested.
Example {{datasets description}} = "Quarterly sales revenue for three product lines over two years", {{comparison criteria}} = "Which product line is growing fastest and seasonality".
Follow-up prompts
- How can I effectively use color to highlight the most important differences?
- What interactive features should I add to a dashboard comparing these datasets?
- Which visualization would best show the correlation between marketing spend and sales for each product?