AnalyticsAAA Customer Churn Case Study

AnalyticsAAAis an Australia-based world-leading commercial data analytics company that essentially collects, prepares, analyzes, and visualizes data for various clients such as businesses and governments.AnalyticsAAAprides itself on offering personalized information for all levels of management and business operations. They collect comprehensive organizational (and external) data to provide a complete analysis and present it in a way that the audience (whoever it may be) understands.

After graduating from college, you joinedAnalyticsAAAas an analyst. Due to your excellent education, you are progressing quickly in the company. While the recognition is also financially expressed, it also means that you have started to receive a broad range of tasks and duties (ranging from data extraction, transformation, and visualizations to statistical data analyses). In order to progress to the next step, Business Analytics lead, you need to show that you are capable of not only performing the individual task but also supporting evidence-based strategic decision-making through your business knowledge and communicating your conclusions effectively.

EcommerceABC,a leading E-commerce company, has contactedAnalyticsAAAregarding their challenges related to customer churn. As customerchurnhas increased over the past,EcommerceABCis struggling financially. The company's management believes that it needs to know and predict the customers who are likely to churn so that it can approach these customers to offer promotions accordingly. The churn rate, also known as the rate of attrition or customer churn is the rate at which customers stop doing business with an entity.EcommerceABCmeasures customer churn by looking at whether a customer discontinues the service with them. Customers churn meansEcommerceABCloses customers as they stop doing business withEcomerceABCand move to another online provider. The churn rate and growth rate are diametrically opposite factors, as the former measures the loss of customers and the other measures the acquisition of customers.

EcommerceABCapproachedAnalyticsAAAand asked for analytics services to understand the drivers of their customer churn and inform their decision-making. They have sentAnalyticsAAAall sorts of data and - since it is a major client with an urgent problem -AnalyticsAAAhas decided to put their best people on the case. Therefore, you are responsible for completing the analysis and preparing a report thatEcommerceABC can use to minimize customer churn.Please complete the attached report and help EcommerceABC find ways to address their issue of excessive customer churn.

1. Descriptive analysis of customer churn via PBI

Your business analytics team is requested to integrate data and develop a PowerBI report for analytical purposes to illustrate answers to key managerial questions from the marketing department and the product management teams. The data required for this task is "powerbi_data.csv". For each question, (1) include a screenshot of only the relevantvisualization(s) (2.1.1,2.2.1, and2.3.1) and (2) provide an answer in the respective deliverable section (2.1.2,2.2.2, and2.3.2).

Below are some examples of visualizations and a visualization dashboard

IPTeleConnect Churn Analysis Average Subscription Tenure by Churn Flag Churn by International Plan Churn Subscription Tenure (in Months) Churn . No . Yes 100 % No 36.34 Yes 33,30 Percentage 50 % Churn by Age Group Chum . No . Yes 0 % No Yes International Plan 72 %% Churn by Tariff Plan Churn . No . Yes Percentage Tariff Plan 20 16-20 21:30 31:40 41-50 51-60 20% 40% 60% 80% 100% Age Group Share of Churn/Non ChurnIPTeleConnect Churn Analysis # Customers # Churned # Active Churn Rate 2766 806 1960 29.14 % Durchschnitt von Yearly Call Duration (in Average Customer Value by Customer Complaints by Churn Mins) nach Churn Churn Flag Flag Churn 4864 THEL Yes Average Weekly Data Usage by Churn Durchschnitt von Net Customer Spend Complaints Churn Tes Churn Churn3 Churn by International Plan Churn 0 No 0 Yes 100% 50% 9}? Percentage 50'66 m N0 Ya International Man 3 Churn by International Plan Churn 0 No 0 Yes 100% 50% 9}? Percentage 50'66 m N0 Ya International Man 3 Churn by International Plan Churn 0 No 0 Yes 100% 50% 9}? Percentage 50'66 m N0 Ya International Man