# satish-shrestha-4u/restrodine-restaurant-intelligence architecture

> Architecture diagram of the GitHub repository satish-shrestha-4u/restrodine-restaurant-intelligence, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-22). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/satish-shrestha-4u/restrodine-restaurant-intelligence
- Repository: https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence

## Overview

RestroDine is a Streamlit restaurant-intelligence dashboard backed by synthetic restaurant data and precomputed analytical outputs. Managers explore financial performance, a weather-aware 14-day revenue forecast, workforce requirements and roster coverage, customer feedback and RFM segments, and menu profitability. The documented analytical workflow prepares data, produces forecasts and planning/management analyses, then presents saved outputs in the app; the forecast also feeds workforce planning. The source excerpts show forecast/weather and staffing logic, but not the notebook implementations or the app’s full data-loading code, so those links rely on README statements.

Main entry points: [`forecast_pipeline.py`](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/forecast_pipeline.py) (Revenue forecasting), [`outputs`](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/tree/main/outputs) (Analytical outputs), [`data_clean`](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/tree/main/data_clean) (Clean datasets), [`notebooks/01a_data_cleaning.ipynb`](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/01a_data_cleaning.ipynb) (Data preparation)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_rawdata[("Synthetic source data")]
  node_prep["Data preparation"]
  node_cleandata[("Clean datasets")]
end

subgraph group_analytics["Business analytics"]
  node_revenue["Revenue analysis"]
end

subgraph group_planning["Forecast and workforce"]
  node_forecast["Revenue forecasting"]
  node_weather["Weather service"]
  node_workforce["Workforce planning"]
  node_workbook["Workforce analysis"]
  node_model["Saved forecast model"]
end

subgraph group_insights["Customer and menu"]
  node_customer["Customer intelligence"]
  node_menu["Menu engineering"]
end

subgraph group_experience["Dashboard and storage"]
  node_outputs[("Analytical outputs")]
  node_app["Streamlit dashboard<br/>[app.py]"]
  node_mysql[("MySQL database<br/>[schema.sql]")]
  node_loader["Database loader<br/>[load_database.py]"]
end

node_manager(("Restaurant manager"))

node_rawdata -->|"prepares"| node_prep
node_prep -->|"produces"| node_cleandata
node_cleandata -->|"analyzes"| node_revenue
node_revenue -->|"informs"| node_forecast
node_forecast -->|"requests weather"| node_weather
node_model -->|"loads model"| node_forecast
node_forecast -->|"provides demand"| node_workforce
node_workforce -->|"supports analysis"| node_workbook
node_cleandata -->|"analyzes"| node_customer
node_cleandata -->|"analyzes"| node_menu
node_forecast -->|"writes forecasts"| node_outputs
node_workforce -->|"writes planning results"| node_outputs
node_customer -->|"produces insights"| node_outputs
node_menu -->|"produces insights"| node_outputs
node_outputs -->|"reads results"| node_app
node_manager -->|"explores insights"| node_app
node_loader -->|"loads tables"| node_mysql

click node_rawdata "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/tree/main/data"
click node_prep "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/01a_data_cleaning.ipynb"
click node_cleandata "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/tree/main/data_clean"
click node_revenue "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/02_revenue_intelligence.ipynb"
click node_forecast "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/forecast_pipeline.py"
click node_workforce "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/forecast_pipeline.py"
click node_workbook "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/03_workforce_intelligence.ipynb"
click node_customer "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/04_customer_intelligence.ipynb"
click node_menu "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/05_menu_intelligence.ipynb"
click node_outputs "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/tree/main/outputs"
click node_model "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/models/restrodine_prophet_calendar_weather.json"
click node_app "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/app.py"
click node_mysql "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/data/schema.sql"
click node_loader "https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/load_database.py"

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_rawdata,node_prep,node_cleandata toneBlue
class node_revenue toneAmber
class node_forecast,node_weather,node_workforce,node_workbook,node_model toneMint
class node_customer,node_menu toneRose
class node_outputs,node_app,node_mysql,node_loader,node_manager toneIndigo
```

## Components

### Data preparation

- [Synthetic source data](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/tree/main/data): `data`
- [Data preparation](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/01a_data_cleaning.ipynb): `notebooks/01a_data_cleaning.ipynb`
- [Clean datasets](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/tree/main/data_clean): `data_clean`

### Business analytics

- [Revenue analysis](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/02_revenue_intelligence.ipynb): `notebooks/02_revenue_intelligence.ipynb`

### Forecast and workforce

- [Revenue forecasting](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/forecast_pipeline.py): `forecast_pipeline.py`
- **Weather service**
- [Workforce planning](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/forecast_pipeline.py): `forecast_pipeline.py`
- [Workforce analysis](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/03_workforce_intelligence.ipynb): `notebooks/03_workforce_intelligence.ipynb`
- [Saved forecast model](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/models/restrodine_prophet_calendar_weather.json): `models/restrodine_prophet_calendar_weather.json`

### Customer and menu

- [Customer intelligence](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/04_customer_intelligence.ipynb): `notebooks/04_customer_intelligence.ipynb`
- [Menu engineering](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/notebooks/05_menu_intelligence.ipynb): `notebooks/05_menu_intelligence.ipynb`

### Dashboard and storage

- [Analytical outputs](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/tree/main/outputs): `outputs`
- [Streamlit dashboard](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/app.py): `app.py`
- [MySQL database](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/data/schema.sql): `data/schema.sql`
- [Database loader](https://github.com/satish-shrestha-4u/restrodine-restaurant-intelligence/blob/main/load_database.py): `load_database.py`

### Other components

- **Restaurant manager**

## Connections

- Synthetic source data → Data preparation: prepares (evidence: `README.md`)
- Data preparation → Clean datasets: produces (evidence: `README.md`)
- Clean datasets → Revenue analysis: analyzes (evidence: `README.md`)
- Revenue analysis → Revenue forecasting: informs (evidence: `README.md`)
- Revenue forecasting → Weather service: requests weather (evidence: `forecast_pipeline.py`)
- Saved forecast model → Revenue forecasting: loads model (evidence: `README.md`)
- Revenue forecasting → Workforce planning: provides demand (evidence: `README.md`)
- Workforce planning → Workforce analysis: supports analysis (evidence: `README.md`)
- Clean datasets → Customer intelligence: analyzes (evidence: `README.md`)
- Clean datasets → Menu engineering: analyzes (evidence: `README.md`)
- Revenue forecasting → Analytical outputs: writes forecasts (evidence: `README.md`)
- Workforce planning → Analytical outputs: writes planning results (evidence: `README.md`)
- Customer intelligence → Analytical outputs: produces insights (evidence: `README.md`)
- Menu engineering → Analytical outputs: produces insights (evidence: `README.md`)
- Analytical outputs → Streamlit dashboard: reads results (evidence: `README.md`)
- Restaurant manager → Streamlit dashboard: explores insights (evidence: `README.md`)
- Database loader → MySQL database: loads tables (evidence: `load_database.py`)
