Difference between revisions of "ANLY482 AY2016-17 T1 Group4: Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
Line 3: Line 3:
 
<!--Header Start-->
 
<!--Header Start-->
 
{|style="background-color:#4c5974; color:#F5F5F5; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 
{|style="background-color:#4c5974; color:#F5F5F5; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
| style="padding:0.3em; font-size:100%; background-color:#4c5974;  border-bottom:0px solid #1e708d; text-align:center; color:#F5F5F5" width="10%" |  
+
| style="padding:0.3em; font-size:100%; background-color:#ed881e;  border-bottom:0px solid #1e708d; text-align:center; color:#F5F5F5" width="10%" |  
 
[[Image:TeamInsured_Home.png| 30px |link= ANLY482 AY2016-17 T1 Group4 ]] &nbsp;
 
[[Image:TeamInsured_Home.png| 30px |link= ANLY482 AY2016-17 T1 Group4 ]] &nbsp;
[[ANLY482 AY2016-17 T1 Group4  |<font color="#F5F5F5" size=2><b>HOME</b></font>]]
+
[[TeamInsured |<font color="#F5F5F5" size=2><b>HOME</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;  
| style="padding:0.3em; font-size:100%; background-color:#ed881e;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
+
| style="padding:0.3em; font-size:100%; background-color:#4c5974;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
[[Image:TeamInsured_About_Icon.png|30px|link=TeamInsured Project Overview ]] &nbsp;
+
[[Image:TeamInsured_About_Icon.png|30px|link=ANLY482 AY2016-17 T1 Group4: Project Overview ]] &nbsp;
[[TeamInsured Project Overview|<font color="#F5F5F5" size=2><b>PROJECT OVERVIEW</b></font>]]
+
[[ANLY482 AY2016-17 T1 Group4: Project Overview|<font color="#F5F5F5" size=2><b>PROJECT OVERVIEW</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="padding:0.3em; font-size:100%; background-color:#4c5974;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="12%" |  
 
| style="padding:0.3em; font-size:100%; background-color:#4c5974;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="12%" |  
[[Image:TeamInsured_Findings.png|30px|link=TeamInsured Findings]] &nbsp;
+
[[Image:TeamInsured_Findings.png|30px|link=ANLY482 AY2016-17 T1 Group4: Findings]] &nbsp;
[[TeamInsured Project Findings |<font color="#F5F5F5" size=2><b>PROJECT FINDINGS</b></font>]]
+
[[ANLY482 AY2016-17 T1 Group4: Project Findings |<font color="#F5F5F5" size=2><b>PROJECT FINDINGS</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="padding:0.3em; font-size:100%; background-color:#4c5974;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="12%" |  
 
| style="padding:0.3em; font-size:100%; background-color:#4c5974;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="12%" |  
[[Image:TeamInsured_PM.png|30px|link=TeamInsured Project Management]] &nbsp;
+
[[Image:TeamInsured_PM.png|30px|link=ANLY482 AY2016-17 T1 Group4: Project Management]] &nbsp;
[[TeamInsured Project Management |<font color="#F5F5F5" size=2><b>PROJECT MANAGEMENT</b></font>]]
+
[[ANLY482 AY2016-17 T1 Group4: Project Management |<font color="#F5F5F5" size=2><b>PROJECT MANAGEMENT</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="padding:0.3em; font-size:100%; background-color:#4c5974;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
 
| style="padding:0.3em; font-size:100%; background-color:#4c5974;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
[[Image:TeamInsured_Documentation.png|30px|link=TeamInsured Documentation]] &nbsp;
+
[[Image:TeamInsured_Documentation.png|30px|link=ANLY482 AY2016-17 T1 Group4: Documentation]] &nbsp;
[[TeamInsured Documentation | <font color="#F5F5F5" size=2><b>DOCUMENTATION</b></font>]]
+
[[ANLY482 AY2016-17 T1 Group4: Documentation | <font color="#F5F5F5" size=2><b>DOCUMENTATION</b></font>]]
 
|}  
 
|}  
 
<!--Header End-->
 
<!--Header End-->

Revision as of 17:54, 16 October 2016

TeamInsured Logo.png


TeamInsured Home.png   HOME

 

TeamInsured About Icon.png   PROJECT OVERVIEW

 

TeamInsured Findings.png   PROJECT FINDINGS

 

TeamInsured PM.png   PROJECT MANAGEMENT

 

TeamInsured Documentation.png   DOCUMENTATION


Background

At **UNDISCLOSED 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 **UNDISCLOSED 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 Tokio Marine 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