You have been hired by ABC bank as a Data mining consultant. The bank would like to get the hidden information from its customer database. How would you apply your data mining knowledge to get potentially useful information from the given data set?
You are required to use all the techniques which you have learnt from both lecture and tutorials. Below is the description about the data. There are 600 records in the customer database.
|
Attributes
|
Descriptions
|
|
Id
|
Customer Identification Number
|
|
age
|
Customer age
|
|
sex
|
Gender
|
|
region
|
Region
|
|
income
|
Income
|
|
married
|
Marital status
|
|
children
|
Number of children
|
|
car
|
Whether he own a car
|
|
save_act
|
Saving account
|
|
current_act
|
Current account
|
|
mortgage
|
Mortgage
|
|
pep
|
Personal Equity Plan (PEP) used to repay the mortgage balance outstanding at the end of the mortgage term.
|
Task:
- Report the preliminary understanding of the data in the form of histograms and data quality.
- Draw a graphs for categorical and numerical variables and report your findings.
- The bank would like come up with a new mortgage scheme and wanted to know who would be interested in new scheme. How you can help the bank to identify its customer who would be likely interested in the new mortgage scheme.
- Is there any association between car, save-act, current-act, mortgage and pep?
- Using the unsupervised clustering technique segment the customers and give the rules for each clusters.
You are required to submit a report (hard copy & soft copy) with proper outputs and relevant explanations..