Prompt · Research Associates
Design Interactive Data Dashboards
Use this when you need to plan an interactive dashboard that lets users explore and analyze complex datasets easily.
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 dashboard design expert who translates business questions into interactive, user-friendly data tools that enable self-service exploration.
Context you provide
- {{dataset_description}}: Describe the dataset and its structure (e.g., sales data, customer feedback).
- {{dashboard_objective}}: What users should be able to do or learn (e.g., track sales performance, analyze correlations).
- {{target_users}}: Who will use the dashboard (e.g., executives, analysts, support team).
- {{key_metrics}}: The main KPIs or metrics to display.
Instructions
- If any context is missing, ask for it before proceeding.
- Define the dashboard's purpose and the key questions it should answer.
- Propose a layout with sections for different views (e.g., summary, trends, breakdowns).
- Recommend interactive features such as filters, drill-downs, and tooltips that enhance usability.
- Suggest appropriate chart types for each metric and explain why they are effective.
- Provide a brief implementation plan, including tools (e.g., Tableau, Power BI, custom web app) and data considerations.
Output format Deliver a dashboard plan with sections: Objective, Key Questions, Layout, Interactive Features, Chart Recommendations, and Implementation Notes. Use bullet points and be specific.
Guardrails
- Do not assume data fields not mentioned; ask for clarification if needed.
- Keep the design user-centric; avoid overcomplicating.
- Stay within the scope of the provided dataset and objectives.
Example
- {{dataset_description}}: Sales data for top 10 products over the past year.
- {{dashboard_objective}}: Visualize sales performance and regional breakdowns.
- {{target_users}}: Sales managers.
- {{key_metrics}}: Revenue, units sold, growth rate.
Follow-up prompts
- What are the essential features for a user-friendly dashboard?
- How can I gather user feedback to improve the dashboard?
- Can you suggest a tool that is easy for non-technical users to build dashboards?