Customer churn analysis is performed by organizations to find out the trend of the customers who are dissatisfied with the services offered by them. An international telecom company has a table CustChurn in their database which stores the customer related data. The following chart represents the column names and their descriptions.

The company wants to build and select the best model so it can be used for predictive purposes with new customers so that the churn rate can be reduced.

• Study and understand the scenario clearly and create the table named CustChurn and engineer/ insert data relevant to the scenario. (all SQL scripts required in solution)
• Give a brief description of your data (in about 15 lines) explaining the effect of various factors (columns) on the customer churn.
• Perform Data Mining through Decision Tree algorithm on the data. The Key, Input and Predict columns are mentioned in the above table. (screenshots of all the steps required in the solution)

Key Input Predict Column Name RecordID (kry) Accounturion Stt.Code AreaCode Type Int Int Phone IntPlan Y/N Y/N Int Int Int Int Description Primary key duration of account activity State of Customer Area of Customer Phone no. of Customer Interational Plan activated? Voice Mail Plan activated? No. of Voice Mail Messages Total Day minutes used Total Day calls made Total Day Charge Total Evening Minutes Total Evening calls made Total Evening Charge Total Night Minutes Total Night calls made Total Night Charge Total International Minutes Total International calls made Total Intermational Charge No. of Customer Service Calls Made Customer Churn (1=Chuen, O=Not Chur) Int Int YMailPlan VMailMessage Day Mins Day Calls Day Charge EveMins EveCalls Evehag NightMins NightCalls NightCharge LUMins LECalls Charge CostServiceCalls Churn Int Int Int Int Int Int Int Int 0/1 Key Input Predict Column Name RecordID (kry) Accounturion Stt.Code AreaCode Type Int Int Phone IntPlan Y/N Y/N Int Int Int Int Description Primary key duration of account activity State of Customer Area of Customer Phone no. of Customer Interational Plan activated? Voice Mail Plan activated? No. of Voice Mail Messages Total Day minutes used Total Day calls made Total Day Charge Total Evening Minutes Total Evening calls made Total Evening Charge Total Night Minutes Total Night calls made Total Night Charge Total International Minutes Total International calls made Total Intermational Charge No. of Customer Service Calls Made Customer Churn (1=Chuen, O=Not Chur) Int Int YMailPlan VMailMessage Day Mins Day Calls Day Charge EveMins EveCalls Evehag NightMins NightCalls NightCharge LUMins LECalls Charge CostServiceCalls Churn Int Int Int Int Int Int Int Int 0/1