Complete AI Training

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.

All 26 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 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

  1. Ask for any missing context before starting.
  2. Design a dashboard layout that prioritizes the most important KPIs at the top.
  3. Recommend interactive features such as drill-downs, filters, and time-series comparisons.
  4. Suggest chart types that best represent each KPI (e.g., gauges, line charts, heatmaps).
  5. 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?