Skip to content

An analysis of the customer churn rate of a telecommunication company based in California and presents recommendations on how to minimize the attrition for the long-term success of the company.

Notifications You must be signed in to change notification settings

mulongocheloti/Churn-Analysis

Repository files navigation

Customer Churn Analysis | Telecom Company Q2' 2022

This report provides an analysis of the customer churn rate of a telecommunication company based in California and presents recommendations on how to minimize the attrition for the long-term success of the company.

Analysis Scope

The analysis scope of this report includes customer segregation, distribution, and demographics analysis. Through this analysis, we have identified several key factors that may be contributing to the high churn rate, including competition from other companies in the market, poor customer service, contract type and tenure of clients, network coverage and reliability issues, limited product offerings, and lack of competitive pricing.

Overview

Distribution Analysis

Demographics Analysis

Customer Segregation

Action Plan

To address these issues, the report recommends several steps the company can take, including performing a competitor analysis, improving customer service, conducting marketing campaigns with good ROI, investing in network upgrades, expanding product offerings, and reviewing pricing structure.

Plan to Action

Technologies Used

The report was created using various technologies, including Power BI for data transformation, data modeling, and visualization, and PowerPoint for presentation.

[Open Report in Power BI](https://app.powerbi.com/groups/me/reports/f0cb6d1f-893a-412b-9fb2-97d7c4928dec?pbi_source=PowerPoint)

About

An analysis of the customer churn rate of a telecommunication company based in California and presents recommendations on how to minimize the attrition for the long-term success of the company.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published