Analyze and create a video presentation of your Consulting Plan for the following case study: Predicting Customer Churn at QWE, Inc.
Assignment and Process
Read and analyze the PREDICTING CUSTOMER CHURN AT QWE INC. case using the discussion questions below.
Present, in a multimedia PPT presentation (should take me 5-8 minutes to watch), your consulting plan covering your points and recommendations about Predicting Customer Churn at QWE, Inc. case.
Assignment Questions
Is Wall’s belief about the dependence of churn rates on customer age supported by the data? To get a sense of intuition, try visualizing this dependence (Hint: no need to run any statistical tests).
To start, run a single regression model that best predicts the probability that a customer leaves.
What is the predicted probability that Customer 672 will leave between December 2011 and February 2012? Is that high or low? Did that customer actually leave?
What about Customers 354 and 5,203?
How sensible is the approach with a single model? Can you suggest a better approach?
Provide updated estimates of probabilities that Customers 672, 354, and 5,203 will leave.
What factors contribute the most to the predicted probabilities that these customers will leave?
Answer Wall’s “ultimate question”: provide the list of 100 customers with highest churn probabilities and the top three drivers of churn for each customer.
Consulting Plan
Your consulting plan should include:
Introduction
Situation analysis
Identification and analysis of issues and opportunities
Development and evaluation of your alternatives
Presentation of your recommendations and related rationale