Customer Churn in Telecom Industry

with Microsoft PowerBI
Project Background

Welcome to my portfolio project, where I apply my Power BI skills to a real-world dataset from the Databel, a fictional subscription-based telecom company. In this case study, I delve into the crucial task of reducing customer churn rates. By analyzing the provided dataset, I aim to uncover insights that will help understand the reasons behind customer churn and identify strategies to mitigate it effectively.

Objective

The primary objective of this Power BI project is to gain a comprehensive understanding of customer churn rates in the telecom industry.

Question

Why are customers churning at their current rate, and how can we effectively reduce churn in the telecom industry?

Data
  • Dataset provided from Datacamp
Skills
  • Applying data modeling techniques for creating measures and calculated columns
  • Explore the data and use analytical skills to uncover patterns and trends within the dataset
  • Transform and manipulate data using Power Query Editor in Power BI
Tools
  • PowerBI
PowerBI Report

In this portfolio project, I applied my Power BI skills to analyze customer churn rates in the telecom industry. Through a comprehensive exploration of the provided dataset from Databel, a subscription-based telecom company, I aimed to uncover valuable insights into why customers are churning and how to effectively reduce churn. The project consists of ten insightful report pages, each focusing on a different aspect of the analysis. From Churn Demographics to Payment and Contract details, these report pages provide a holistic view of the data, offering actionable insights and recommendations for improving customer retention. I invite you to explore the interactive Power BI report below to gain a deeper understanding of the project findings and the strategies to address churn-related challenges.