This project analyze 'Prism insurance Pvt Ltd data to evaluate policy performance ,claim trends ,customer demographics and risk factor, enabling data driven decision decision through interactive dashboard and insights .also we perform sentiment analysis regarding customer feedback
Analyze prism insurance pvt.ltd data to monitor buisness health across policies, claims,customers and product lines -spotting performance gaps,risk trends and oppurtunities for operational or product improvement.
1.Importing data from postgresql database into power bi 2.performing data profilling 3.adding slicers and visualized charts 4.performing sentimental analysis using python
some of the key insights from the dashboard are
- Travel shows the highest premium amount (~2.5 M),followed by Health (~1.2 M) .Other lines are notably smaller now suggesting travel is a top revenue driver now.
2.Adults and elders generate the bullk of claim amounts ,with adults much higher than young adults .This signals higher exposure or utilization among older segments .
3.~58% active vs 42% inactive policies nearly half of the policies are not active .which could imply lapses ,cancellations or long term inactivity needing attention
4.Gender splits is balanced in total count indicating no such skewness in customer count by gender
- rejected and pending claim amount are sizeable if this mirrors financial impacts or customer dissatisfaction there's room to streamline claim processing or communication.
1.Given travel's outsized premium contribution review pricing ,coverage,and risk control herefirst;consider whether to expand or tighten offering depending on claims trends and profitability
2.Target adult and elder segments with tailored risk management or preventive programs
3.Investigate causes of high inactive policy share
- Reduce pending and rejected claims through process improvements.