Problem & background
A Telecom Customer Company providing a data related to their customers (Data Source- Maven Analytics). The data includes a unique Id for each & every 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 going 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
Solution
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.
Goals & KPIs
● Goal 1: Create data understandable
● Goal 2: Creating pivot tables and generate a structured data by using which we can visualize the data and generate insights
● Goal 3: Visualizing the data and answering the question on the basis of our analysis.
Concepts Used
Which concepts have you used which have been taught in the Module (Any formula or technique)?
● Concept 1: PIVOT Table, Filters, Slicers
● Concept 2: Grouping, Average, Max, Min
● Concept 3: Charts
Conclusion
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