Skip to Content
Author's profile photo Tammy Powlas

Customer Retention Use Case Updated

I’m following up from an old document Burn that Churn?  Checking Retention of Customers in Predictive Analysis and doing the same analysis but this time using SAP Predictive Analytics 2.2 Expert Analytics – the same data, the same model.  We’re looking at the attributes of customers retained and comparing them to those who have left (banking sample customers)

/wp-content/uploads/2015/08/1rnrprop_771356.jpg

Since we are trying to predict churn, that is the target variable, using the amount of deposits, investment amount, income and number of checking transactions.

/wp-content/uploads/2015/08/2run_771357.jpg

After running the model, you can see the execution status above.

/wp-content/uploads/2015/08/3rsummary_771358.jpg

Above is the model summary

/wp-content/uploads/2015/08/4confusionmatrix_771359.jpg

What is different from when I originally posted?  The above shows a confusion matrix, with a false positive 6% of the time, true positive 94% and a false negative 1% of the time after outputting the results to Excel:

Predicted Predicted
Actual No Yes Total Actual No Yes
No 1458 85 1543 No 94% 6%
Yes 14 986 1000 Yes 1% 99%
Total 1472 1071 2543

/wp-content/uploads/2015/08/churn_771360.jpg

I think you also need a big screen to better see/view the decision tree:

/wp-content/uploads/2015/08/5decisiontree_771361.jpg

The predicted values are the same as before, with younger people likely to “churn” and not be retained by the bank:

/wp-content/uploads/2015/08/wealth_771362.jpg

Reference

Learn more at Join ASUG at #SABOUC in Austin – Featuring SAP Predictive Analytics

Can’t make this conference?  Consider joining us at SAP TechEd:

In-Depth Learning with ASUG Pre-Conference Seminars at SAP TechEd

Take a deep dive into a particular topic during the ASUG Pre-Conference Seminars offered Monday, October 19 in Las Vegas. Join ASUG Volunteers for a full day, hands-on SAP BusinessObjects Design Studio Deep Dive.


Sign-up for pre-conference seminars during the registration process. If you have already registered and would like to add a pre-conference session, visit the following registration page.

Join Us for These Upcoming ASUG Webcasts

We hope to see you in person in Austin or Las Vegas

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Nice example Tammy - I enjoyed reading it!

      Based on the analysis and due to my soon-to-be-40 age, I am not very likely to "churn" my bank.