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.
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.
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
- Ask for any missing context before starting.
- List the recommended solvency metrics to display, explaining why each is critical.
- Design the dashboard layout: suggest which metrics go on a main page, which on drill‑down pages.
- For each metric, propose a visualization type (e.g., gauge, line chart, heat map) and how it updates in real time.
- Include a section on threshold alerts (e.g., red/yellow/green zones) and how to integrate them.
- 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?