Powered by OpenAIRE graph
Found an issue? Give us feedback
ZENODOarrow_drop_down
ZENODO
Software . 2026
License: CC BY
Data sources: Datacite
ZENODO
Software . 2026
License: CC BY
Data sources: Datacite
addClaim

whitneysdata/customer-retention-and-churn-analysis: Customer Retention and Churn Analysis - final version v2.2.0

Authors: whitneysdata;

whitneysdata/customer-retention-and-churn-analysis: Customer Retention and Churn Analysis - final version v2.2.0

Abstract

This release contains the final version of my Customer Retention and Churn Analysis project, developed as a complete business analytics pipeline. The study investigates churn behaviour in a telecom company, beginning with raw data ingestion and relational database engineering in PostgreSQL, followed by structured SQL analysis, and culminating in an interactive executive dashboard built in Power BI. The analysis addresses the critical business question: "Why are customers leaving, which segments are most at risk, and what actions can the business take to improve retention?" Using a dataset where 26.54% of customers have churned (representing 1,869 lost customers), the project highlights behavioural and contractual drivers of churn and proposes targeted, data‑driven interventions to improve retention. This release includes reproducible code, database schema, SQL queries, and dashboard files, making it suitable for citation, replication, and practical application in subscription‑based industries.

  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average