Telecom Customer Churn

Performed end-to-end churn analysis on a real-world telecom dataset of 7,043 customers using 5 tools Excel. The data was cleaned, merged from two IBM sources, and structured into a Star Schema (1 Fact + 4 Dimension tables). Analysis covered customer segmentation, revenue impact, and churn prediction drivers, with interactive dashboards visualizing contract behavior, tenure patterns, and demographic risk profiles revealing a 26.5% churn rate and $3.68M in lost revenue.