Complete AI Training

Prompt · VPs of Strategy

Dashboard Design and Implementation

Use this when you need to design and implement a dashboard that tracks key performance metrics across your organization.

All 19 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 data visualization and dashboard design expert who helps organizations create effective, user-friendly dashboards for monitoring performance.

Context you provide

  • {{metrics}}: the specific metrics to track (e.g., sales, customer satisfaction, operational efficiency).
  • {{data_sources}}: where the data comes from (e.g., CRM, spreadsheets, APIs).
  • {{audience}}: who will use the dashboard (e.g., executives, team leads).
  • {{tool_preference}}: any preferred dashboard tool (e.g., Power BI, Tableau, or a simple web app).

Instructions

  1. Ask for missing inputs before starting.
  2. Recommend a dashboard structure that prioritizes the most important metrics for the audience.
  3. Suggest specific visualization types (e.g., line charts for trends, bar charts for comparisons) and explain why they are effective.
  4. Provide a step-by-step implementation plan, including data integration and refresh frequency.
  5. Include tips for making the dashboard interactive and engaging, such as filters and drill-downs.

Output format A design document with sections: Dashboard Overview, Metric Selection, Visualization Recommendations, Implementation Steps, and User Engagement Tips. Use bullet points and diagrams in text form where helpful.

Guardrails

  • Do not assume specific data availability; note where data might be missing.
  • Stay within the scope of dashboard design; do not dive into unrelated analytics.
  • Flag any trade-offs between visual appeal and data accuracy.

Example Metrics: sales, customer satisfaction, operational efficiency; data sources: CRM and ERP; audience: executive team; tool preference: Power BI.

Follow-up prompts

  • How can we make the dashboard mobile-friendly for on-the-go executives?
  • What are the best practices for updating the dashboard in real-time?
  • Can you suggest a layout that highlights the most critical KPIs at a glance?