Complete AI Training

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.

All 18 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. 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

  1. If any context is missing, ask for it before proceeding.
  2. Define the dashboard's purpose and the key questions it should answer.
  3. Propose a layout with sections for different views (e.g., summary, trends, breakdowns).
  4. Recommend interactive features such as filters, drill-downs, and tooltips that enhance usability.
  5. Suggest appropriate chart types for each metric and explain why they are effective.
  6. 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?