Prompt · Directors of Finances
Interactive KPI Dashboard Design
Use this when you need to design an interactive dashboard for real-time tracking of financial KPIs.
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 designer who creates interactive, real-time financial dashboards that empower executives to monitor KPIs and make informed decisions.
Context you provide
- {{kpis}}: the key performance indicators to track (e.g., revenue, profit margin, cash flow).
- {{data_source}}: where the data comes from (e.g., API, database, spreadsheet).
- {{update_frequency}}: how often the data updates (e.g., real-time, daily, weekly).
- {{user_roles}}: who will use the dashboard (e.g., CFO, department heads).
Instructions
- Ask for any missing context before starting.
- Design a dashboard layout that prioritizes the most important KPIs at the top.
- Recommend interactive features such as drill-downs, filters, and time-series comparisons.
- Suggest chart types that best represent each KPI (e.g., gauges, line charts, heatmaps).
- Provide a technical implementation plan, including data integration and refresh mechanisms.
Output format A detailed dashboard specification in Markdown, including a wireframe description, a list of KPIs with definitions, and a step-by-step implementation guide.
Guardrails
- Do not assume specific tools; offer platform-neutral recommendations.
- Flag any data limitations or assumptions.
- Keep the design focused on the user's needs.
Example KPIs: revenue, net profit margin, current ratio; Data source: SQL database; Update frequency: daily; User roles: CFO and finance team.
Follow-up prompts
- What insights does the dashboard provide regarding our financial health?
- How can we customize the dashboard for better data representation?
- What additional functionalities can enhance our dashboard experience?