Problem Statement Case Study using SQL, Python and Tableau

This segment will help you understand the problem statement behind this case study. In the forthcoming video, Favio will explain the scenario and the objectives that we will have to achieve in this case study.

So, as you saw in the video, you will be playing the role of an analyst working for a telecom company that provides home phone and internet services to 7,043 customers across Southern California. A new competitor has moved into the area, and the company you are working for is concerned about losing its existing customers. It wants to come up with a solution so that it does not have to worry about customers leaving.

Based on this case, the senior management of your company has defined the business objectives listed below, and it wants you to offer suggestions that can help achieve these objectives:

• Understand which services provided by the company are not performing well, so that the product team can improve the quality of such services and ensure the existing customers are happy with them
• Identify which variables are affecting the customers’ churn, based on existing data
• Identify the services that are being received well by the customers so that the company can use them to attract new customers
• Identify high-value customers so that the company can provide them with a premium membership to retain them for as long as possible

In the next video, Favio will explain the data that has been collected in the past quarter.
 

So, now that you have watched the video, you must have understood the data that we have at hand. You can download the data dictionary from the link provided below:

In the next segment, you will be learning about some key metrics that we will be analyzing throughout the case study to come up with our solution.