# curlycodex/churn-analysis-customer-intelligence architecture

> Architecture diagram of the GitHub repository curlycodex/churn-analysis-customer-intelligence, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-07). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/curlycodex/churn-analysis-customer-intelligence
- Repository: https://github.com/curlycodex/churn-analysis-customer-intelligence

## Overview

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`](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb) (Analysis notebook), [`customer_churn_data_raw.xlsx`](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/customer_churn_data_raw.xlsx) (Raw customer data), [`exported_churn_data.csv`](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/exported_churn_data.csv) (Exported churn data), [`customer_churn.db`](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/customer_churn.db) (Churn database)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_analysis["Churn analysis"]
  node_notebook["Analysis notebook"]
  node_preparation["Data preparation"]
  node_sql["SQL analysis"]
  node_features["Feature engineering"]
  node_retention["Churn and retention"]
  node_customer["Customer analysis"]
  node_revenue["Revenue analysis"]
  node_visualization["Visualizations"]
end

subgraph group_data["Data assets"]
  node_rawdata["Raw customer data"]
  node_exported["Exported churn data"]
  node_database[("Churn database<br/>[customer_churn.db]")]
end

subgraph group_results["Business outputs"]
  node_insights["Retention insights"]
end

node_analyst(("Analyst"))

node_analyst -->|"runs analysis"| node_notebook
node_notebook -->|"produces insights"| node_insights
node_notebook -.->|"includes"| node_preparation
node_notebook -.->|"includes"| node_sql
node_notebook -.->|"includes"| node_features
node_notebook -.->|"includes"| node_retention
node_notebook -.->|"includes"| node_customer
node_notebook -.->|"includes"| node_revenue
node_notebook -.->|"includes"| node_visualization
node_notebook -.->|"may read"| node_rawdata
node_notebook -.->|"may read"| node_exported
node_notebook -.->|"may query"| node_database

click node_notebook "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb"
click node_preparation "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb"
click node_sql "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb"
click node_features "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb"
click node_retention "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb"
click node_customer "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb"
click node_revenue "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb"
click node_visualization "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb"
click node_rawdata "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/customer_churn_data_raw.xlsx"
click node_exported "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/exported_churn_data.csv"
click node_database "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/customer_churn.db"
click node_insights "https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_notebook,node_preparation,node_sql,node_features,node_retention,node_customer,node_revenue,node_visualization toneBlue
class node_rawdata,node_exported,node_database toneAmber
class node_insights toneMint
class node_analyst toneIndigo
```

## Components

### Churn analysis

- [Analysis notebook](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb): `churn_analysis.ipynb`
- [Data preparation](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb): `churn_analysis.ipynb`
- [SQL analysis](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb): `churn_analysis.ipynb`
- [Feature engineering](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb): `churn_analysis.ipynb`
- [Churn and retention](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb): `churn_analysis.ipynb`
- [Customer analysis](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb): `churn_analysis.ipynb`
- [Revenue analysis](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb): `churn_analysis.ipynb`
- [Visualizations](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb): `churn_analysis.ipynb`

### Data assets

- [Raw customer data](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/customer_churn_data_raw.xlsx): `customer_churn_data_raw.xlsx`
- [Exported churn data](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/exported_churn_data.csv): `exported_churn_data.csv`
- [Churn database](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/customer_churn.db): `customer_churn.db`

### Business outputs

- [Retention insights](https://github.com/curlycodex/churn-analysis-customer-intelligence/blob/main/churn_analysis.ipynb): `churn_analysis.ipynb`

### Other components

- **Analyst**

## Connections

- Analyst → Analysis notebook: runs analysis (evidence: `README.md`)
- Analysis notebook → Retention insights: produces insights (evidence: `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
