RuhTech Case Study: Customer Churn Analysis

Data Analytics for Telecommunications Company

Overview:
This project transformed customer behavior, subscription, service, and billing data into retention insights. SQL analysis and Power BI dashboards helped expose the reasons customers leave and where action can reduce churn.

Approach:
- Prepared and cleaned approximately 70,000 customer records.
- Analyzed churn relationships across contract type, pricing, tenure, support, and demographics.
- Built interactive Power BI dashboards for business stakeholders.
- Converted findings into practical retention recommendations.

Key Findings:
- Month-to-month customers showed higher churn risk.
- Higher monthly charges increased cancellation likelihood.
- Support and security gaps correlated with customer loss.

Impact:
The work helped turn raw customer data into clear, human-centered retention recommendations.