PRISM Insurance Pvt. Ltd. needed a single view of their policy portfolio, claim performance, and customer demographics to make faster, data-driven operational decisions.
Open the PDF above to view the full dashboard
| Metric | Value |
|---|---|
| Total Premium Collected | ₹5.98M |
| Total Coverage Amount | ₹600.55M |
| Total Claim Amount | ₹16.91M |
- Auto and Health policies contribute the highest share of premium income
- Claim settlement rate reveals operational bottleneck in pending approvals
- Adult age group (31–60) accounts for the largest claim burden
- Gender distribution is roughly equal — no significant gender bias in claims
- Pending claims in Life and Travel segments need priority attention
- Which policy type generates the most premium revenue?
- How efficient is the company at settling claims?
- Which age group drives the highest claim amounts?
- What is the gender breakdown of policyholders?
- How do claim approvals vary across policy types?
| Tool | Usage |
|---|---|
| Power BI Desktop | Dashboard, KPI cards, donut and bar charts |
| DAX | Claim rate, settlement % measures |
| Power Query | Data transformation |
| Excel / CSV | Source data — InsuranceData.csv |
InsuranceData.csv— raw datasetInsurance analysis.pbix— Power BI source fileInsurance analysis.pdf— dashboard export
Mehul Prajapati — BTech CSE, Dr. Ram Manohar Lohia Awadh University (2026)
Power BI DAX Insurance Analytics KPI Dashboard Claims Analysis