Health Factors & Insurance Costs Report
This section analyzes how health metrics—cholesterol, heart disease history, smoking status, and daily steps—impact insurance costs.
- Average Insurance Cost per Cholesterol Level (Bar Chart): Highest in "200 to 225" mg/dL, lowest in "225 to 250".
- Cholesterol Level Categories (Pie Chart): 79.93% lower risk, 11.85% moderate, 8.22% higher risk.
- Disease History by Gender/Smoking (Treemap): Heart disease and smoking status strongly affect costs.
- Average Daily Steps (Gauge): 5.22K, moderate activity.
Lifestyle and Demographic Influence on Insurance Cost Report
Explores how occupation, age, gender, exercise, alcohol, and location influence insurance expenses.
- Insurance Cost per Occupation (Bar Chart): "Student" and "Business" highest.
- By Gender (Donut Chart): Males 65.63%, females 34.37% of costs.
- By Exercise Category (Bar Chart): "Moderate" exercise highest total cost.
- By Age Groups (Line Chart): Sharp cost rise after age 50–59.
- By Alcohol Consumption (Bar Chart): "Rare" highest, "Daily" lowest.
- By Location (Map): Regional variation in premiums.
Customer Engagement and Insurance Cost Analysis Report
Examines how engagement with healthcare, doctor visits, insurance tenure, BMI, and glucose levels impact costs.
- Top 5 Doctor Visits (Funnel Chart): 2 visits most common.
- By Doctor Visits (Bar Chart): 10 visits = highest average cost.
- By Insurance Years (Bar Chart): Years 3 and 7 = highest average costs.
- Average Daily Steps by Age (Line): Peaks at 20–29, 40–49.
- Average BMI (Gauge): 31.39
- Average Glucose Level (Gauge): 167.53
Recommendations & Conclusion
- Refine Risk Assessment for Cholesterol: Investigate anomalies in "225 to 250" mg/dL group.
- Targeted Occupation Marketing: Develop products for "Student" and "Business" groups.
- Gender-Specific Product Review: Review higher male costs.
- Promote Preventative Care: Incentivize check-ups and step goals.
- Analyze Customer Lifetime Value: Use insurance tenure data.
- Geographic Risk Profiling: Adjust pricing by region.
The Power BI dashboards reveal the complex interplay of health, lifestyle, demographics, and engagement on insurance costs. Leveraging these insights enables better risk assessment, product innovation, and customer retention.