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 …