How curlycodex/churn-analysis-customer-intelligence works
This is a customer-churn analysis project, with a notebook as its only apparent runtime code. The documented workflow uses Python and SQL to prepare and analyze customer data, then presents churn patterns, revenue impact, and retention insights. The repository also contains raw and exported data files and a SQLite database. The notebook was not excerpted, so its actual data wiring and the sequence among analysis stages cannot be verified; dashed links mark those uncertainties.
Main entry points: churn_analysis.ipynb Analysis notebook · customer_churn_data_raw.xlsx Raw customer data · exported_churn_data.csv Exported churn data · customer_churn.db Churn database
Components 13
Churn analysis
- Analysis notebook
churn_analysis.ipynb - Data preparation
churn_analysis.ipynb - SQL analysis
churn_analysis.ipynb - Feature engineering
churn_analysis.ipynb - Churn and retention
churn_analysis.ipynb - Customer analysis
churn_analysis.ipynb - Revenue analysis
churn_analysis.ipynb - Visualizations
churn_analysis.ipynb
Data assets
- Raw customer data
customer_churn_data_raw.xlsx - Exported churn data
exported_churn_data.csv - Churn database
customer_churn.db
Business outputs
- Retention insights
churn_analysis.ipynb
Other components
- Analyst
Connections 12
- Analyst → Analysis notebook: runs analysis
README.md - Analysis notebook → Retention insights: produces insights
README.md - Analysis notebook → Data preparation: includes
- Analysis notebook → SQL analysis: includes
- Analysis notebook → Feature engineering: includes
- Analysis notebook → Churn and retention: includes
- Analysis notebook → Customer analysis: includes
- Analysis notebook → Revenue analysis: includes
- Analysis notebook → Visualizations: includes
- Analysis notebook → Raw customer data: may read
- Analysis notebook → Exported churn data: may read
- Analysis notebook → Churn database: may query