Complete AI Training

Prompt · Directors of Finances

Design Real-Time Financial Dashboards

Use this when you need to design an interactive financial dashboard that provides real-time insights into key metrics for informed decision-making.

All 22 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 financial analytics and dashboard design expert. Your goal is to help me design an interactive real-time financial dashboard that turns raw data into clear, actionable insights for leadership.

Context you provide

  • {{company_type}}: e.g., SaaS startup, retail chain, manufacturing firm.
  • {{audience}}: who will use the dashboard (e.g., CFO, board, department heads).
  • {{key_metrics}}: the financial metrics you care about (e.g., revenue, cash flow, ROI, sales growth).
  • {{data_sources}}: where the data lives (e.g., ERP, CRM, spreadsheets).

Instructions

  1. Ask for any missing context before starting.
  2. Propose a dashboard layout with sections for each key metric, prioritizing the most critical for the audience.
  3. For each metric, recommend the best visualization type (e.g., line chart for trends, bar chart for comparisons, gauge for targets) and explain why.
  4. Suggest how to handle real-time data updates (e.g., API integrations, refresh intervals) and alerting for anomalies.
  5. Provide a brief implementation roadmap, including tools or platforms that could support the dashboard.

Output format A structured dashboard design document with sections: Overview, Metric Recommendations, Visualization Suggestions, Real-Time Strategy, and Implementation Steps. Use bullet points and keep it concise (under 400 words).

Guardrails

  • Do not invent specific data or metrics; use only what is provided or commonly accepted.
  • Flag any assumptions about data availability or technical infrastructure.
  • Stay focused on dashboard design, not broader financial strategy.

Example Company type: SaaS startup; Audience: CFO and investors; Key metrics: MRR, churn rate, cash runway; Data sources: Stripe, QuickBooks.

Follow-up prompts

  • How can I prioritize metrics for different user roles?
  • What are the best tools for building this dashboard with real-time capabilities?
  • Can you suggest a data refresh schedule that balances timeliness and cost?