Difference between revisions of "ANLY482 AY2016-17 T1 Group4: Project Overview"
Jump to navigation
Jump to search
| Line 32: | Line 32: | ||
==Background== | ==Background== | ||
| − | At | + | At the insurance company, serving happiness to customers has always been the main focus. As such, we at Team Insured have been tasked to assist Tokio Marine's customer base, specifically for the Life Insurance side of the business. |
<br><br> | <br><br> | ||
| − | The three main things that | + | The three main things that the insurance company requires our help for to do analysis on: |
* Average Product Holdings per Customer | * Average Product Holdings per Customer | ||
* Customer Segmentation | * Customer Segmentation | ||
* Agent Segmentation. | * Agent Segmentation. | ||
<br> | <br> | ||
| − | Deeper analysis such as Need Based Analysis has also been requested. These are the three general objectives that are to be pursued for this project, so as to help | + | Deeper analysis such as Need Based Analysis has also been requested. These are the three general objectives that are to be pursued for this project, so as to help the insurance company understand their customers better. |
<br> | <br> | ||
Revision as of 23:58, 16 October 2016
Background
At the insurance company, serving happiness to customers has always been the main focus. As such, we at Team Insured have been tasked to assist Tokio Marine's customer base, specifically for the Life Insurance side of the business.
The three main things that the insurance company requires our help for to do analysis on:
- Average Product Holdings per Customer
- Customer Segmentation
- Agent Segmentation.
Deeper analysis such as Need Based Analysis has also been requested. These are the three general objectives that are to be pursued for this project, so as to help the insurance company understand their customers better.
Data Source
Flat Files
The initial files were given as text files in .txt format. Using Windows Powershell, we were able to convert it to CSV format, which could then be imported into the MySQL Server.
import-csv tabdelimitedfile.txt -delimiter "`t" | export-csv csvfile.csv -NoTypeInformation
Methodology
