A Telecom Customer Company providing a data related to their customers (Data Source- Maven Analytics). The data includes a unique Id for every each customer called as Customer ID, demographic information of the customers, and various services used by the customer, customer’s monthly charges and average revenue generated by the customer, also provide data about customer’s status i.e. Churned, Stayed, Joined. The Data provided is recorder within the last quarter Q2-2022.
Here we are suppose to analyze the data, clean the data and then use it to generate insights. Here we suppose to find out is the company losing high value customer and will also provide some suggestion to reduce the churning. Will also sneak deep to understand which are the top 12 cities where the customer churning is high and what will be the major reason for
I will prefer to use Microsoft excel to clean the data, transforming into desired data and visualize it. The data we are using is comparatively small and can be handle by Microsoft Excel hence it is most easy choice to select within different software. We will use slicer, Pivot table and various charts to generates insights and a good looking dashboard.
Methodology & Project scope
Our final motive of this analysis is to calculate and answer some of the analysis questions and make this calculation logical and understandable.
Firstly, the most important thing is to prepare a data dictionary, without understanding the data dictionary, it will be difficult to know about data, understanding the column names and what actual story the data tells you, this can only happen after knowing the data dictionary
Data dictionary contains 3 columns and a lot of important information about the data.
For initializing the calculation or analysis part, I am going to generate pivot tables and will perform required mathematical operations to understand the data and generate insights.
Visualization is generated right after the pivot table and also answered some of the important questions of my analysis.
This analysis will help the Telecom company to know more about their customer , why customer churn is happening and also will provide some crucial suggestion to minimize the Customer churn.
Comments