Churn Customers Project
My Project
Project Title: Churn Customers Project
Status : Completed
Real-time data , Structured data , Qualitative and Quantitative data
I conducted an Exploratory Data Analysis (EDA) on customer churn data for a company called Databel, utilizing SQL for data manipulation. The analysis involved executing various SQL tasks, such as JOINs, SELECT queries, UPDATE and COALESCE statements, ALTER queries, and WINDOWS functions, as well as employing CASE statements to derive deeper insights. The focus of the analysis extended beyond merely calculating the churn rate—it aimed to understand the underlying reasons for customer churn and to propose strategies for its reduction.
Aggregate queries
The dataset comprised several key columns, including: ID, Churn Label, Account Length (in months), Local Calls, Local Mins, International Calls, International Mins, International Plan, Extra International Charges, Customer Service Calls, Average Monthly GB Download, Unlimited Data Plan, Extra Data Charges, State, Phone Number, Gender, Age, Under 30, Senior, Group, Number of Customers in Group, Contract Type, Payment Method, Monthly Charge, Total Charges, Churn Category, and Churn Reason.
To view the project in more detail, please click on the View More Button