# avinaash-02/de-mini-project-db architecture

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

- Interactive diagram: https://gitdiagram.com/avinaash-02/de-mini-project-db
- Repository: https://github.com/avinaash-02/de-mini-project-db

## Overview

This repository is a notebook-based data analytics pipeline, organized around bronze ingestion, silver cleaning, and gold modeling and analysis. Its domain outputs include customer, date, geography, product, and seller dimensions; order, payment, and review facts; curated tables and a cube; and business KPIs. The tree indicates an orchestration configuration, but no README or source excerpts were provided. Accordingly, workflow links are shown as unverified, and the graph does not assert particular inputs, storage systems, or execution behavior.

Main entry points: [`03_gold/curated_table_notebook/nb_curated_table.ipynb`](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/curated_table_notebook/nb_curated_table.ipynb) (Curated tables), [`03_gold/nb_gold_schema_creation.ipynb`](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/nb_gold_schema_creation.ipynb) (Gold schema), [`02_silver/nb_data_cleaning_silver.ipynb`](https://github.com/avinaash-02/de-mini-project-db/blob/main/02_silver/nb_data_cleaning_silver.ipynb) (Data cleaning), [`03_gold/Dim_Table_Notebook`](https://github.com/avinaash-02/de-mini-project-db/tree/main/03_gold/Dim_Table_Notebook) (Dimension tables)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingest["Bronze ingestion"]
  node_bronze["Data ingestion"]
end

subgraph group_clean["Silver cleaning"]
  node_silver["Data cleaning"]
end

subgraph group_model["Gold data model"]
  node_gold_schema["Gold schema"]
  node_dimensions["Dimension tables"]
  node_dim_customer["Customer dimension"]
  node_dim_date["Date dimension<br/>[nb_dim_date.ipynb]"]
  node_dim_geography["Geography dimension"]
  node_dim_products["Product dimension"]
  node_dim_sellers["Seller dimension"]
  node_facts["Fact tables"]
  node_fact_order_items["Order item facts"]
  node_fact_orders["Order facts"]
  node_fact_payments["Payment facts"]
  node_fact_reviews["Review facts"]
end

subgraph group_analytics["Gold analytics"]
  node_curated["Curated tables"]
  node_cube["Analytics cube"]
  node_kpi_aov["Average order value<br/>[nb_kpi_aov.ipynb]"]
  node_kpi_delivery["Delivery metrics"]
  node_kpi_clv["Customer lifetime value<br/>[nb_kpi_clv.ipynb]"]
  node_kpi_late["Late deliveries"]
  node_kpi_rating["Low ratings"]
  node_kpi_customer_types["Customer segments"]
  node_kpi_fulfilment["Order fulfilment"]
  node_kpi_location["Orders by location"]
  node_kpi_payment["Payment distribution"]
  node_kpi_monthly_revenue["Monthly revenue"]
  node_kpi_product_revenue["Product revenue"]
  node_kpi_seller_revenue["Seller revenue"]
  node_kpi_top_products["Top products"]
  node_kpi_top_sellers["Top sellers"]
  node_all_kpis["Combined KPIs<br/>[nb_all_kpis.ipynb]"]
end

subgraph group_orchestration["Orchestration"]
  node_pipeline["Pipeline config"]
end

node_bronze -.->|"feeds forward"| node_silver
node_silver -.->|"feeds forward"| node_gold_schema
node_gold_schema -.->|"supports modeling"| node_dimensions
node_gold_schema -.->|"supports modeling"| node_facts
node_dimensions -.->|"may inform"| node_curated
node_facts -.->|"may inform"| node_curated
node_curated -.->|"may feed"| node_cube
node_curated -.->|"may feed"| node_all_kpis

click node_pipeline "https://github.com/avinaash-02/de-mini-project-db/blob/main/04_orchestration/orchestration_pipeline.yaml"
click node_bronze "https://github.com/avinaash-02/de-mini-project-db/blob/main/01_bronze/nb_data_ingestion_bronze.ipynb"
click node_silver "https://github.com/avinaash-02/de-mini-project-db/blob/main/02_silver/nb_data_cleaning_silver.ipynb"
click node_gold_schema "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/nb_gold_schema_creation.ipynb"
click node_dimensions "https://github.com/avinaash-02/de-mini-project-db/tree/main/03_gold/Dim_Table_Notebook"
click node_dim_customer "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_customer.ipynb"
click node_dim_date "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_date.ipynb"
click node_dim_geography "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_geography.ipynb"
click node_dim_products "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_products.ipynb"
click node_dim_sellers "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_sellers.ipynb"
click node_facts "https://github.com/avinaash-02/de-mini-project-db/tree/main/03_gold/Fact_Table_Notebook"
click node_fact_order_items "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Fact_Table_Notebook/nb_fact_order_items.ipynb"
click node_fact_orders "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Fact_Table_Notebook/nb_fact_orders.ipynb"
click node_fact_payments "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Fact_Table_Notebook/nb_fact_payments.ipynb"
click node_fact_reviews "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Fact_Table_Notebook/nb_fact_reviews.ipynb"
click node_curated "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/curated_table_notebook/nb_curated_table.ipynb"
click node_cube "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/cube_notebook/nb_cube_notebook.ipynb"
click node_kpi_aov "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_aov.ipynb"
click node_kpi_delivery "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_avg_delivery_dates.ipynb"
click node_kpi_clv "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_clv.ipynb"
click node_kpi_late "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_late_delivery.ipynb"
click node_kpi_rating "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_low_rating.ipynb"
click node_kpi_customer_types "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_new_returning_customers.ipynb"
click node_kpi_fulfilment "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_order_fulfilment.ipynb"
click node_kpi_location "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_orderby_city_state.ipynb"
click node_kpi_payment "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_payment_distribution.ipynb"
click node_kpi_monthly_revenue "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_revenue_by_month.ipynb"
click node_kpi_product_revenue "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_revenue_by_products.ipynb"
click node_kpi_seller_revenue "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_revenue_by_sellers.ipynb"
click node_kpi_top_products "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_top_products.ipynb"
click node_kpi_top_sellers "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_top_sellers.ipynb"
click node_all_kpis "https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpis_notebook/nb_all_kpis.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_bronze toneBlue
class node_silver toneAmber
class node_gold_schema,node_dimensions,node_dim_customer,node_dim_date,node_dim_geography,node_dim_products,node_dim_sellers,node_facts,node_fact_order_items,node_fact_orders,node_fact_payments,node_fact_reviews toneMint
class node_curated,node_cube,node_kpi_aov,node_kpi_delivery,node_kpi_clv,node_kpi_late,node_kpi_rating,node_kpi_customer_types,node_kpi_fulfilment,node_kpi_location,node_kpi_payment,node_kpi_monthly_revenue,node_kpi_product_revenue,node_kpi_seller_revenue,node_kpi_top_products,node_kpi_top_sellers,node_all_kpis toneRose
class node_pipeline toneIndigo
```

## Components

### Bronze ingestion

- [Data ingestion](https://github.com/avinaash-02/de-mini-project-db/blob/main/01_bronze/nb_data_ingestion_bronze.ipynb): `01_bronze/nb_data_ingestion_bronze.ipynb`

### Silver cleaning

- [Data cleaning](https://github.com/avinaash-02/de-mini-project-db/blob/main/02_silver/nb_data_cleaning_silver.ipynb): `02_silver/nb_data_cleaning_silver.ipynb`

### Gold data model

- [Gold schema](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/nb_gold_schema_creation.ipynb): `03_gold/nb_gold_schema_creation.ipynb`
- [Dimension tables](https://github.com/avinaash-02/de-mini-project-db/tree/main/03_gold/Dim_Table_Notebook): `03_gold/Dim_Table_Notebook`
- [Customer dimension](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_customer.ipynb): `03_gold/Dim_Table_Notebook/nb_dim_customer.ipynb`
- [Date dimension](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_date.ipynb): `03_gold/Dim_Table_Notebook/nb_dim_date.ipynb`
- [Geography dimension](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_geography.ipynb): `03_gold/Dim_Table_Notebook/nb_dim_geography.ipynb`
- [Product dimension](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_products.ipynb): `03_gold/Dim_Table_Notebook/nb_dim_products.ipynb`
- [Seller dimension](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Dim_Table_Notebook/nb_dim_sellers.ipynb): `03_gold/Dim_Table_Notebook/nb_dim_sellers.ipynb`
- [Fact tables](https://github.com/avinaash-02/de-mini-project-db/tree/main/03_gold/Fact_Table_Notebook): `03_gold/Fact_Table_Notebook`
- [Order item facts](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Fact_Table_Notebook/nb_fact_order_items.ipynb): `03_gold/Fact_Table_Notebook/nb_fact_order_items.ipynb`
- [Order facts](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Fact_Table_Notebook/nb_fact_orders.ipynb): `03_gold/Fact_Table_Notebook/nb_fact_orders.ipynb`
- [Payment facts](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Fact_Table_Notebook/nb_fact_payments.ipynb): `03_gold/Fact_Table_Notebook/nb_fact_payments.ipynb`
- [Review facts](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/Fact_Table_Notebook/nb_fact_reviews.ipynb): `03_gold/Fact_Table_Notebook/nb_fact_reviews.ipynb`

### Gold analytics

- [Curated tables](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/curated_table_notebook/nb_curated_table.ipynb): `03_gold/curated_table_notebook/nb_curated_table.ipynb`
- [Analytics cube](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/cube_notebook/nb_cube_notebook.ipynb): `03_gold/cube_notebook/nb_cube_notebook.ipynb`
- [Average order value](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_aov.ipynb): `03_gold/kpi_notebook/nb_kpi_aov.ipynb`
- [Delivery metrics](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_avg_delivery_dates.ipynb): `03_gold/kpi_notebook/nb_kpi_avg_delivery_dates.ipynb`
- [Customer lifetime value](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_clv.ipynb): `03_gold/kpi_notebook/nb_kpi_clv.ipynb`
- [Late deliveries](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_late_delivery.ipynb): `03_gold/kpi_notebook/nb_kpi_late_delivery.ipynb`
- [Low ratings](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_low_rating.ipynb): `03_gold/kpi_notebook/nb_kpi_low_rating.ipynb`
- [Customer segments](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_new_returning_customers.ipynb): `03_gold/kpi_notebook/nb_kpi_new_returning_customers.ipynb`
- [Order fulfilment](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_order_fulfilment.ipynb): `03_gold/kpi_notebook/nb_kpi_order_fulfilment.ipynb`
- [Orders by location](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_orderby_city_state.ipynb): `03_gold/kpi_notebook/nb_kpi_orderby_city_state.ipynb`
- [Payment distribution](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_payment_distribution.ipynb): `03_gold/kpi_notebook/nb_kpi_payment_distribution.ipynb`
- [Monthly revenue](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_revenue_by_month.ipynb): `03_gold/kpi_notebook/nb_kpi_revenue_by_month.ipynb`
- [Product revenue](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_revenue_by_products.ipynb): `03_gold/kpi_notebook/nb_kpi_revenue_by_products.ipynb`
- [Seller revenue](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_revenue_by_sellers.ipynb): `03_gold/kpi_notebook/nb_kpi_revenue_by_sellers.ipynb`
- [Top products](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_top_products.ipynb): `03_gold/kpi_notebook/nb_kpi_top_products.ipynb`
- [Top sellers](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpi_notebook/nb_kpi_top_sellers.ipynb): `03_gold/kpi_notebook/nb_kpi_top_sellers.ipynb`
- [Combined KPIs](https://github.com/avinaash-02/de-mini-project-db/blob/main/03_gold/kpis_notebook/nb_all_kpis.ipynb): `03_gold/kpis_notebook/nb_all_kpis.ipynb`

### Orchestration

- [Pipeline config](https://github.com/avinaash-02/de-mini-project-db/blob/main/04_orchestration/orchestration_pipeline.yaml): `04_orchestration/orchestration_pipeline.yaml`

## Connections

- Data ingestion → Data cleaning: feeds forward
- Data cleaning → Gold schema: feeds forward
- Gold schema → Dimension tables: supports modeling
- Gold schema → Fact tables: supports modeling
- Dimension tables → Curated tables: may inform
- Fact tables → Curated tables: may inform
- Curated tables → Analytics cube: may feed
- Curated tables → Combined KPIs: may feed
