Telecom Customer Churn Analysis

Introduction : Churn data for a fictional Telecommunications company that provides phone and internet services to 7,043 customers in California, and includes details about customer demographics, location, services, and current status.

Situation : You'll be assuming the role of a BI Consultant for Maven Communications, a California-based Telecommunications company. You've been hired to help the company improve retention by identifying high value customers and churn risks, and have been asked to present your findings to the CMO in the form of a single page report or dashboard.

About the dataset : This dataset contains 2 tables, in CSV format: • The Customer Churn table contains information on all 7,043 customers from a Telecommunications company in California in Q2 2022. • Each record represents one customer, and contains details about their demographics, location, tenure, subscription services, status for the quarter (joined, stayed, or churned), and more! • The Zip Code Population table contains complimentary information on the estimated populations for the California zip codes in the Customer Churn table.

Recommended Analysis: i) How many customers joined the company during the last quarter? How many customers joined? ii) What is the customer profile for a customer that churned, joined, and stayed? Are they different? iii) What seem to be the key drivers of customer churn? iv)Is the company losing high value customers? If so, how can they retain them?