# shwarnasrivastava23/saas-retention-analysis architecture

> Architecture diagram of the GitHub repository shwarnasrivastava23/saas-retention-analysis, 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/shwarnasrivastava23/saas-retention-analysis
- Repository: https://github.com/shwarnasrivastava23/saas-retention-analysis

## Overview

This repository is a product-analytics analysis and reporting project. Its workflow simulates signup and event data, loads the CSVs into SQLite, analyzes activation, retention, and acquisition-channel patterns, then presents findings and recommendations in a browser dashboard. The README documents the SQL and dashboard capabilities; their implementation details are not sampled, so those links are grounded in the README rather than inspected source.

Main entry points: [`product_analytics.db`](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/product_analytics.db) (Analytics database), [`analysis.py`](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py) (Analysis charts), [`summary.json`](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/summary.json) (Summary statistics), [`load_db.py`](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/load_db.py) (Database loader)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_generator["Data simulator<br/>[generate_data.py]"]
  node_users["Signup records<br/>[users.csv]"]
  node_events["Event log<br/>[events.csv]"]
  node_loader["Database loader<br/>[load_db.py]"]
  node_sqlite[("Analytics database")]
end

subgraph group_analysis["Analytics"]
  node_sqlqueries["SQL analysis queries<br/>[analysis.sql]"]
  node_funnel["Activation funnel<br/>[analysis.py]"]
  node_retention["Retention analysis<br/>[analysis.py]"]
  node_channels["Channel comparison<br/>[analysis.py]"]
  node_cohorts["Cohort analysis<br/>[analysis.py]"]
  node_summary["Summary statistics<br/>[summary.json]"]
end

subgraph group_report["Reporting"]
  node_charts["Analysis charts<br/>[analysis.py]"]
  node_dashboard["Browser dashboard<br/>[dashboard.html]"]
end

node_analyst(("Leadership / analyst"))

node_generator -->|"generates"| node_users
node_generator -->|"generates"| node_events
node_loader -->|"reads"| node_users
node_loader -->|"reads"| node_events
node_loader -->|"loads tables"| node_sqlite
node_sqlqueries -->|"queries"| node_sqlite
node_funnel -->|"queries"| node_sqlite
node_retention -->|"queries"| node_sqlite
node_channels -->|"queries"| node_sqlite
node_cohorts -->|"queries"| node_sqlite
node_funnel -->|"exports metrics"| node_summary
node_retention -->|"exports curves"| node_summary
node_channels -->|"exports rates"| node_summary
node_funnel -->|"renders"| node_charts
node_retention -->|"renders"| node_charts
node_channels -->|"renders"| node_charts
node_cohorts -->|"renders"| node_charts
node_dashboard -->|"displays"| node_summary
node_dashboard -->|"includes visuals"| node_charts
node_analyst -->|"views report"| node_dashboard

click node_generator "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/generate_data.py"
click node_users "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/users.csv"
click node_events "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/events.csv"
click node_loader "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/load_db.py"
click node_sqlite "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/product_analytics.db"
click node_sqlqueries "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.sql"
click node_funnel "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py"
click node_retention "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py"
click node_channels "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py"
click node_cohorts "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py"
click node_summary "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/summary.json"
click node_charts "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py"
click node_dashboard "https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/dashboard.html"

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_generator,node_users,node_events,node_loader,node_sqlite toneBlue
class node_sqlqueries,node_funnel,node_retention,node_channels,node_cohorts,node_summary toneAmber
class node_charts,node_dashboard toneMint
class node_analyst toneIndigo
```

## Components

### Data preparation

- [Data simulator](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/generate_data.py): `generate_data.py`
- [Signup records](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/users.csv): `users.csv`
- [Event log](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/events.csv): `events.csv`
- [Database loader](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/load_db.py): `load_db.py`
- [Analytics database](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/product_analytics.db): `product_analytics.db`

### Analytics

- [SQL analysis queries](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.sql): `analysis.sql`
- [Activation funnel](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py): `analysis.py`
- [Retention analysis](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py): `analysis.py`
- [Channel comparison](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py): `analysis.py`
- [Cohort analysis](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py): `analysis.py`
- [Summary statistics](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/summary.json): `summary.json`

### Reporting

- [Analysis charts](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/analysis.py): `analysis.py`
- [Browser dashboard](https://github.com/shwarnasrivastava23/saas-retention-analysis/blob/main/dashboard.html): `dashboard.html`

### Other components

- **Leadership / analyst**

## Connections

- Data simulator → Signup records: generates (evidence: `generate_data.py`)
- Data simulator → Event log: generates (evidence: `generate_data.py`)
- Database loader → Signup records: reads (evidence: `load_db.py`)
- Database loader → Event log: reads (evidence: `load_db.py`)
- Database loader → Analytics database: loads tables (evidence: `load_db.py`)
- SQL analysis queries → Analytics database: queries (evidence: `README.md`)
- Activation funnel → Analytics database: queries (evidence: `analysis.py`)
- Retention analysis → Analytics database: queries (evidence: `analysis.py`)
- Channel comparison → Analytics database: queries (evidence: `analysis.py`)
- Cohort analysis → Analytics database: queries (evidence: `analysis.py`)
- Activation funnel → Summary statistics: exports metrics (evidence: `analysis.py`)
- Retention analysis → Summary statistics: exports curves (evidence: `analysis.py`)
- Channel comparison → Summary statistics: exports rates (evidence: `analysis.py`)
- Activation funnel → Analysis charts: renders (evidence: `analysis.py`)
- Retention analysis → Analysis charts: renders (evidence: `analysis.py`)
- Channel comparison → Analysis charts: renders (evidence: `analysis.py`)
- Cohort analysis → Analysis charts: renders (evidence: `analysis.py`)
- Browser dashboard → Summary statistics: displays (evidence: `README.md`)
- Browser dashboard → Analysis charts: includes visuals (evidence: `README.md`)
- Leadership / analyst → Browser dashboard: views report (evidence: `README.md`)
