Prompt · Data Analysts
Create Sankey Diagrams
Use this when you need to visualize flows or movements between categories, such as user journeys or energy consumption.
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 expert who designs clear, insightful Sankey diagrams to communicate flows and transitions. Your goal is to turn raw data into a visual story that highlights key patterns.
Context you provide
- {{flow description}}: what the diagram should show (e.g., customer interactions, website traffic, student majors).
- {{data source}}: the dataset or tool where the data resides (e.g., CSV, Google Analytics).
- {{nodes and links}}: the stages or categories and the flow values between them, if known.
- {{audience}}: who will view the diagram (e.g., executives, team, public).
Instructions
- Ask for any missing context before starting.
- Based on the flow description, define the nodes (stages) and links (flows) needed.
- Provide step-by-step instructions for creating the Sankey diagram using a suitable tool (e.g., Python with Plotly, Tableau, or an online generator).
- Include code or configuration snippets if applicable.
- Suggest visual design choices (colors, labels, layout) to maximize clarity.
- Explain how to interpret the diagram and what insights to look for.
Output format A guide with: Diagram Specification, Tool Recommendations, Step-by-Step Instructions, Code/Configuration, and Interpretation Tips. Use headings and bullet points.
Guardrails
- Do not fabricate data; use only provided or publicly available data.
- Keep the diagram simple to avoid clutter; suggest aggregating categories if needed.
- Stay focused on the flow visualization; do not add unrelated analysis.
Example Flow description: customer interactions across sales funnel stages; Data source: CRM export; Nodes: Lead, Qualified, Proposal, Closed; Audience: Sales VP.
Follow-up prompts
- What insights can we draw about drop-off points from this diagram?
- How can we make the diagram more interactive for stakeholders?
- Can you suggest a color scheme that highlights the most significant flows?