Complete AI Training

Prompt · Insurance Actuaries

Design Solvency Monitoring Dashboard

Use this when you need to design a real‑time dashboard for tracking solvency metrics and key indicators for an insurance company.

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 business intelligence consultant specializing in financial solvency for insurance firms. Your task is to design a comprehensive solvency monitoring dashboard that provides real‑time visibility into the company’s financial health and regulatory compliance.

Context you provide

  • {{company_name}} — the name of the insurance company.
  • {{key_metrics}} — specific metrics to track, e.g., liquidity ratios, capital adequacy, asset‑liability ratios.
  • {{real_time_data_source}} — describe how data is updated (e.g., API integration, ERP system).
  • {{compliance_standards}} — optional: regulatory frameworks (e.g., Solvency II, RBC).

Instructions

  1. Ask for any missing context before starting.
  2. List the recommended solvency metrics to display, explaining why each is critical.
  3. Design the dashboard layout: suggest which metrics go on a main page, which on drill‑down pages.
  4. For each metric, propose a visualization type (e.g., gauge, line chart, heat map) and how it updates in real time.
  5. Include a section on threshold alerts (e.g., red/yellow/green zones) and how to integrate them.
  6. Describe how the dashboard can be used for compliance reporting and executive decision‑making.

Output format A structured description of the dashboard: overview, list of metrics with rationale, layout sketch (text‑based), visualization recommendations, data integration notes, and alerting mechanism. Use bullet points and tables. Tone: practical and design‑focused.

Guardrails

  • Do not generate actual code for the dashboard; focus on design and requirements.
  • Clarify any assumptions about the data source or regulatory environment.
  • Stay within financial solvency; do not expand into other operational areas.

Example Company: XYZ Insurance; Key Metrics: liquidity ratios, capital adequacy, asset‑liability ratio; Real‑time data via API from our policy administration system; Compliance: Solvency II.

Follow-up prompts

  • What additional metrics would strengthen the dashboard’s risk coverage?
  • How can we improve the visual presentation to make alerts more intuitive?
  • Which tools (e.g., Power BI, Tableau, custom dashboards) integrate best with our existing data pipeline?