Portfolio Project: Insurance Risk & Claims Risk, Customer Churn and Business Intelligence - Part 5

🚀 Video Overview
Welcome to my ALX Data Club Capstone Project presentation on Insurance Risk Analytics.

bit ly/Insuranceprojectfolder
Put . in the space above for Data for project

We tackle a real-world business problem for a healthcare insurance provider struggling with rising claim costs, inconsistent customer behavior, and financial strain on reserves. Currently, the company lacks a standardized framework to evaluate risk, leading to reactive underwriting and pricing.

Using data analytics and business intelligence, We built a custom Risk Score Model to identify high-risk corporate clients and individual policyholders, optimize premium pricing, and safeguard long-term profitability.

💼 The Business Problem
The Challenge: The insurance firm provides medical coverage plans to employees across multiple corporate organizations. Without a proactive Risk Score system, management struggles to identify high-risk entities before expensive claims hit, impacting fraud detection, premium pricing, and financial sustainability.

Key Risk Assumptions Analyzed:
Demographics & Lifestyle: Impact of Age, BMI, and Smoking habits on claim amounts.
Financials & Frequency: Correlation between salary levels, claim frequency, and historical claim costs.
Corporate Exposure: Tracking organizations with high claim-to-premium ratios.

📊 Key Business Questions Answered
Which customers and corporate organizations pose the highest financial risk?
What demographic or lifestyle factors contribute most to high medical claims?
Are current premium structures sufficient to cover claim expenses across branches?
How can predictive analytics forecast future claims and optimize investment strategies for reserves?

🛠️ Tools & Tech Stack Used
Data Cleaning & Transformation: [GCP Console / SQL / Python / Excel]
Risk Score Modeling: [Python / Pandas / Scikit-Learn]
Business Intelligence & Dashboards: [Power BI]

Видео Portfolio Project: Insurance Risk & Claims Risk, Customer Churn and Business Intelligence - Part 5 канала ALX DATA CLUB