rachel93augesty-del/Insurance-Analytics-Predictive-Modeling--Week3

This project analyzes historical car insurance claims data to optimize marketing strategies and identify low-risk customer segments for premium reduction opportunities at AlphaCare Insurance Solutions (ACIS) in South Africa. ## 🎯 Business Objective Your employer, **AlphaCare Insurance Solutions (ACIS)**, is committed to developing cutting-edge risk and predictive analytics in car insurance planning and marketing in South Africa. As a newly joined marketing analytics engineer, your first project is to analyze historical insurance claim data to: - **Optimize marketing strategy** - Discover **"low-risk" targets** for premium reduction - Create opportunities to attract new clients - Build smart models that optimize premiums --- ## 🚀 Project Motivation This challenge sharpens skills in three key areas: - **Data Engineering (DE)** - **Predictive Analytics (PA)** - **Machine Learning Engineering (MLE)** The tasks simulate real-world pressures and deadlines typical in financial analytics, improving your ability to: - Manage complex datasets - Adapt to challenges - Think creatively - Apply hypothesis testing and predictive analytics in insurance --- ## 📊 Data Description **Historical Data Period**: February 2014 to August 2015 **Data Location**: [Provided data file - raw_data.txt] ### Data Structure Categories: #### 1. Insurance Policy Columns - `UnderwrittenCoverID`, `PolicyID` #### 2. Transaction Date - `TransactionMonth` #### 3. Client Information - `IsVATRegistered`, `Citizenship`, `LegalType`, `Title`, `Language`, `Bank` - `AccountType`, `MaritalStatus`, `Gender` #### 4. Client Location - `Country`, `Province`, `PostalCode`, `MainCrestaZone`, `SubCrestaZone` #### 5. Car Insured - `ItemType`, `Mmcode`, `VehicleType`, `RegistrationYear`, `Make`, `Model` - `Cylinders`, `Cubiccapacity`, `Kilowatts`, `Bodytype`, `NumberOfDoors` - `VehicleIntroDate`, `CustomValueEstimate`, `AlarmImmobiliser`, `TrackingDevice` - `CapitalOutstanding`, `NewVehicle`, `WrittenOff`, `Rebuilt`, `Converted` - `CrossBorder`, `NumberOfVehiclesInFleet` #### 6. Insurance Plan - `SumInsured`, `TermFrequency`, `CalculatedPremiumPerTerm`, `ExcessSelected` - `CoverCategory`, `CoverType`, `CoverGroup`, `Section`, `Pr …