# tanav23/servigo architecture

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

- Interactive diagram: https://gitdiagram.com/tanav23/servigo
- Repository: https://github.com/tanav23/servigo

## Overview

ServiGo is an analytics portfolio workflow, not a deployed marketplace service: synthetic records are generated, validated and prepared through ETL, then analyzed in SQL and presented in Excel and Power BI. The main domain stages include orders, partner performance, onboarding and availability; the dashboard documents city/category cancellation analysis and quality reporting. Source excerpts show portions of data generation, but do not establish most handoffs or the internals of the deliverables, so those relationships are documented workflow edges rather than source-verified calls.

Main entry points: [`sql_Servigo.sql`](https://github.com/tanav23/servigo/blob/main/sql_Servigo.sql) (KPI and Analysis Queries), [`generate_data.py`](https://github.com/tanav23/servigo/blob/main/generate_data.py) (Synthetic Data Generator), [`ServiGo_ETL.yxmd`](https://github.com/tanav23/servigo/blob/main/ServiGo_ETL.yxmd) (Data Integration ETL), [`orders_integrated_clean.csv`](https://github.com/tanav23/servigo/blob/main/orders_integrated_clean.csv) (Clean Orders)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Synthetic Data"]
  node_generator["Synthetic Data Generator<br/>[generate_data.py]"]
  node_validation["Data Validation<br/>[validate_data.py]"]
end

subgraph group_prep["Data Preparation"]
  node_orders["Clean Orders"]
  node_availability["Clean Availability"]
  node_etl["Data Integration ETL<br/>[ServiGo_ETL.yxmd]"]
end

subgraph group_analysis["KPI Analysis"]
  node_sql["KPI and Analysis Queries<br/>[sql_Servigo.sql]"]
end

subgraph group_reporting["Reporting"]
  node_excel["Executive KPI Report"]
  node_dashboard["Interactive Operations Dashboard"]
end

node_analyst(("Analyst"))

node_analyst -->|"generates data"| node_generator
node_generator -->|"validates output"| node_validation
node_generator -->|"prepares inputs"| node_etl
node_etl -->|"produces"| node_orders
node_etl -->|"produces"| node_availability
node_analyst -->|"runs analysis"| node_sql
node_orders -->|"analyzes"| node_sql
node_availability -.->|"analyzes"| node_sql
node_sql -->|"summarizes KPIs"| node_excel
node_sql -.->|"supplies analysis"| node_dashboard
node_analyst -->|"reviews results"| node_dashboard

click node_generator "https://github.com/tanav23/servigo/blob/main/generate_data.py"
click node_validation "https://github.com/tanav23/servigo/blob/main/validate_data.py"
click node_orders "https://github.com/tanav23/servigo/blob/main/orders_integrated_clean.csv"
click node_availability "https://github.com/tanav23/servigo/blob/main/availability_monthly_clean.csv"
click node_etl "https://github.com/tanav23/servigo/blob/main/ServiGo_ETL.yxmd"
click node_sql "https://github.com/tanav23/servigo/blob/main/sql_Servigo.sql"
click node_excel "https://github.com/tanav23/servigo/blob/main/Servigo_Analysis.xlsx"
click node_dashboard "https://github.com/tanav23/servigo/blob/main/ServiGo_Operations_Dashboard.pbix"

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_validation toneBlue
class node_orders,node_availability,node_etl toneAmber
class node_sql toneMint
class node_excel,node_dashboard toneRose
class node_analyst toneIndigo
```

## Components

### Synthetic Data

- [Synthetic Data Generator](https://github.com/tanav23/servigo/blob/main/generate_data.py): `generate_data.py`
- [Data Validation](https://github.com/tanav23/servigo/blob/main/validate_data.py): `validate_data.py`

### Data Preparation

- [Clean Orders](https://github.com/tanav23/servigo/blob/main/orders_integrated_clean.csv): `orders_integrated_clean.csv`
- [Clean Availability](https://github.com/tanav23/servigo/blob/main/availability_monthly_clean.csv): `availability_monthly_clean.csv`
- [Data Integration ETL](https://github.com/tanav23/servigo/blob/main/ServiGo_ETL.yxmd): `ServiGo_ETL.yxmd`

### KPI Analysis

- [KPI and Analysis Queries](https://github.com/tanav23/servigo/blob/main/sql_Servigo.sql): `sql_Servigo.sql`

### Reporting

- [Executive KPI Report](https://github.com/tanav23/servigo/blob/main/Servigo_Analysis.xlsx): `Servigo_Analysis.xlsx`
- [Interactive Operations Dashboard](https://github.com/tanav23/servigo/blob/main/ServiGo_Operations_Dashboard.pbix): `ServiGo_Operations_Dashboard.pbix`

### Other components

- **Analyst**

## Connections

- Analyst → Synthetic Data Generator: generates data (evidence: `README.md`)
- Synthetic Data Generator → Data Validation: validates output (evidence: `README.md`)
- Synthetic Data Generator → Data Integration ETL: prepares inputs (evidence: `README.md`)
- Data Integration ETL → Clean Orders: produces (evidence: `README.md`)
- Data Integration ETL → Clean Availability: produces (evidence: `README.md`)
- Analyst → KPI and Analysis Queries: runs analysis (evidence: `README.md`)
- Clean Orders → KPI and Analysis Queries: analyzes (evidence: `README.md`)
- Clean Availability → KPI and Analysis Queries: analyzes
- KPI and Analysis Queries → Executive KPI Report: summarizes KPIs (evidence: `README.md`)
- KPI and Analysis Queries → Interactive Operations Dashboard: supplies analysis
- Analyst → Interactive Operations Dashboard: reviews results (evidence: `README.md`)