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.
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 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
- Ask for missing inputs before starting.
- Recommend a dashboard structure that prioritizes the most important metrics for the audience.
- Suggest specific visualization types (e.g., line charts for trends, bar charts for comparisons) and explain why they are effective.
- Provide a step-by-step implementation plan, including data integration and refresh frequency.
- 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?