# naveenofficial916-tech/zomato_restaurant_data_analytics architecture

> Architecture diagram of the GitHub repository naveenofficial916-tech/zomato_restaurant_data_analytics, 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/naveenofficial916-tech/zomato_restaurant_data_analytics
- Repository: https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics

## Overview

This repository is a Zomato analytics and engineering project: it generates synthetic platform data, provides a Medallion Lakehouse pipeline, and exposes operational, commercial, and customer analytics through several tools. The documented workflow runs data generation and quality checks before analysis; the separate Spark pipeline transforms raw data through Bronze, Silver, and Gold. Excel consumes Gold exports, while the browser dashboard loads its JSON data directly. The graph also preserves the documented SQL, Power BI, ML, geospatial, and pricing capabilities. Some subsystem links are documented rather than source-verified.

Main entry points: [`data/raw`](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/tree/main/data/raw) (Raw datasets), [`run_project.py`](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/run_project.py) (Project runner), [`pyspark_delta/03_gold_aggregation.py`](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pyspark_delta/03_gold_aggregation.py) (Gold data marts), [`web_dashboard/app.js`](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/web_dashboard/app.js) (Interactive dashboard)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data foundation"]
  node_generator["Synthetic data generator"]
  node_raw[("Raw datasets")]
  node_quality["Data quality audit"]
end

subgraph group_lakehouse["Lakehouse pipeline"]
  node_bronze["Bronze ingestion"]
  node_silver["Silver enrichment"]
  node_gold[("Gold data marts")]
  node_databricks["Databricks pipeline"]
end

subgraph group_analytics["Analytics engines"]
  node_sql["SQL analytics"]
  node_ml["Delivery prediction"]
  node_recommender["Restaurant recommender"]
  node_pricing["Surge simulation"]
end

subgraph group_reporting["Reporting surfaces"]
  node_excel["Executive workbook"]
  node_powerbi["Power BI model"]
  node_measures["DAX measures<br/>[dax_measures.dax]"]
  node_webdata["Dashboard data<br/>[data.json]"]
  node_webapp["Interactive dashboard<br/>[app.js]"]
  node_webui["Dashboard page<br/>[index.html]"]
end

subgraph group_operations["Operational insights"]
  node_geo["Kitchen opportunity finder"]
  node_orchestrator["Project runner<br/>[run_project.py]"]
end

node_user(("Project user"))
node_tiles["OpenStreetMap tiles"]

node_user -->|"runs workflow"| node_orchestrator
node_orchestrator -->|"runs"| node_generator
node_generator -->|"writes datasets"| node_raw
node_orchestrator -->|"runs audit"| node_quality
node_quality -->|"validates"| node_raw
node_raw -->|"ingested as"| node_bronze
node_bronze -->|"cleaned into"| node_silver
node_silver -->|"aggregated into"| node_gold
node_raw -->|"reads raw data"| node_databricks
node_databricks -->|"materializes marts"| node_gold
node_raw -.->|"analyzed in"| node_sql
node_raw -->|"trains from"| node_ml
node_raw -->|"scores from"| node_recommender
node_raw -->|"simulates from"| node_pricing
node_raw -->|"finds demand from"| node_geo
node_gold -->|"loads summaries"| node_excel
node_gold -.->|"modeled for"| node_powerbi
node_powerbi -->|"uses measures"| node_measures
node_user -->|"opens dashboard"| node_webui
node_webui -.->|"loads script"| node_webapp
node_webapp -->|"fetches JSON"| node_webdata
node_webapp -->|"loads map tiles"| node_tiles
node_orchestrator -->|"runs"| node_ml
node_orchestrator -->|"runs"| node_recommender
node_orchestrator -->|"runs"| node_geo
node_orchestrator -->|"runs"| node_pricing
node_orchestrator -->|"builds"| node_excel

click node_generator "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/python_data_gen/generate_zomato_data.py"
click node_raw "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/tree/main/data/raw"
click node_quality "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/data_quality/data_validation_suite.py"
click node_bronze "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pyspark_delta/01_bronze_ingestion.py"
click node_silver "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pyspark_delta/02_silver_transformation.py"
click node_gold "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pyspark_delta/03_gold_aggregation.py"
click node_databricks "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pyspark_delta/databricks_notebook_pipeline.py"
click node_sql "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/tree/main/sql_analytics"
click node_ml "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/ml_models/predict_delivery_time.py"
click node_recommender "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/ml_models/restaurant_recommender.py"
click node_pricing "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pricing_engine/surge_pricing_simulator.py"
click node_geo "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/geo_analytics/cloud_kitchen_finder.py"
click node_excel "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/excel_reports/build_excel_dashboard.py"
click node_powerbi "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/power_bi/power_bi_data_model.md"
click node_measures "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/power_bi/dax_measures.dax"
click node_webdata "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/web_dashboard/data.json"
click node_webapp "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/web_dashboard/app.js"
click node_webui "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/web_dashboard/index.html"
click node_orchestrator "https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/run_project.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_generator,node_raw,node_quality,node_user toneBlue
class node_bronze,node_silver,node_gold,node_databricks toneAmber
class node_sql,node_ml,node_recommender,node_pricing toneMint
class node_excel,node_powerbi,node_measures,node_webdata,node_webapp,node_webui toneRose
class node_geo,node_orchestrator,node_tiles toneIndigo
```

## Components

### Data foundation

- [Synthetic data generator](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/python_data_gen/generate_zomato_data.py): `python_data_gen/generate_zomato_data.py`
- [Raw datasets](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/tree/main/data/raw): `data/raw`
- [Data quality audit](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/data_quality/data_validation_suite.py): `data_quality/data_validation_suite.py`

### Lakehouse pipeline

- [Bronze ingestion](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pyspark_delta/01_bronze_ingestion.py): `pyspark_delta/01_bronze_ingestion.py`
- [Silver enrichment](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pyspark_delta/02_silver_transformation.py): `pyspark_delta/02_silver_transformation.py`
- [Gold data marts](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pyspark_delta/03_gold_aggregation.py): `pyspark_delta/03_gold_aggregation.py`
- [Databricks pipeline](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pyspark_delta/databricks_notebook_pipeline.py): `pyspark_delta/databricks_notebook_pipeline.py`

### Analytics engines

- [SQL analytics](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/tree/main/sql_analytics): `sql_analytics`
- [Delivery prediction](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/ml_models/predict_delivery_time.py): `ml_models/predict_delivery_time.py`
- [Restaurant recommender](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/ml_models/restaurant_recommender.py): `ml_models/restaurant_recommender.py`
- [Surge simulation](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/pricing_engine/surge_pricing_simulator.py): `pricing_engine/surge_pricing_simulator.py`

### Reporting surfaces

- [Executive workbook](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/excel_reports/build_excel_dashboard.py): `excel_reports/build_excel_dashboard.py`
- [Power BI model](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/power_bi/power_bi_data_model.md): `power_bi/power_bi_data_model.md`
- [DAX measures](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/power_bi/dax_measures.dax): `power_bi/dax_measures.dax`
- [Dashboard data](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/web_dashboard/data.json): `web_dashboard/data.json`
- [Interactive dashboard](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/web_dashboard/app.js): `web_dashboard/app.js`
- [Dashboard page](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/web_dashboard/index.html): `web_dashboard/index.html`

### Operational insights

- [Kitchen opportunity finder](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/geo_analytics/cloud_kitchen_finder.py): `geo_analytics/cloud_kitchen_finder.py`
- [Project runner](https://github.com/naveenofficial916-tech/zomato_restaurant_data_analytics/blob/main/run_project.py): `run_project.py`

### Other components

- **Project user**
- **OpenStreetMap tiles**

## Connections

- Project user → Project runner: runs workflow (evidence: `run_project.py`)
- Project runner → Synthetic data generator: runs (evidence: `run_project.py`)
- Synthetic data generator → Raw datasets: writes datasets (evidence: `python_data_gen/generate_zomato_data.py`)
- Project runner → Data quality audit: runs audit (evidence: `run_project.py`)
- Data quality audit → Raw datasets: validates (evidence: `data_quality/data_validation_suite.py`)
- Raw datasets → Bronze ingestion: ingested as (evidence: `pyspark_delta/01_bronze_ingestion.py`)
- Bronze ingestion → Silver enrichment: cleaned into (evidence: `README.md`)
- Silver enrichment → Gold data marts: aggregated into (evidence: `README.md`)
- Raw datasets → Databricks pipeline: reads raw data (evidence: `pyspark_delta/databricks_notebook_pipeline.py`)
- Databricks pipeline → Gold data marts: materializes marts (evidence: `pyspark_delta/databricks_notebook_pipeline.py`)
- Raw datasets → SQL analytics: analyzed in (evidence: `README.md`)
- Raw datasets → Delivery prediction: trains from (evidence: `ml_models/predict_delivery_time.py`)
- Raw datasets → Restaurant recommender: scores from (evidence: `ml_models/restaurant_recommender.py`)
- Raw datasets → Surge simulation: simulates from (evidence: `pricing_engine/surge_pricing_simulator.py`)
- Raw datasets → Kitchen opportunity finder: finds demand from (evidence: `geo_analytics/cloud_kitchen_finder.py`)
- Gold data marts → Executive workbook: loads summaries (evidence: `excel_reports/build_excel_dashboard.py`)
- Gold data marts → Power BI model: modeled for (evidence: `README.md`)
- Power BI model → DAX measures: uses measures (evidence: `README.md`)
- Project user → Dashboard page: opens dashboard (evidence: `README.md`)
- Dashboard page → Interactive dashboard: loads script
- Interactive dashboard → Dashboard data: fetches JSON (evidence: `web_dashboard/app.js`)
- Interactive dashboard → OpenStreetMap tiles: loads map tiles (evidence: `web_dashboard/app.js`)
- Project runner → Delivery prediction: runs (evidence: `run_project.py`)
- Project runner → Restaurant recommender: runs (evidence: `run_project.py`)
- Project runner → Kitchen opportunity finder: runs (evidence: `run_project.py`)
- Project runner → Surge simulation: runs (evidence: `run_project.py`)
- Project runner → Executive workbook: builds (evidence: `run_project.py`)
