# prachi-mate/supermarket-data-analysis architecture

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

- Interactive diagram: https://gitdiagram.com/prachi-mate/supermarket-data-analysis
- Repository: https://github.com/prachi-mate/supermarket-data-analysis

## Overview

This repository is a small supermarket analytics project: CSV tables are loaded into a local database, queried for OLAP summaries, analyzed with KMeans, and visualized in Tableau. The main workflow is documented in the README; the database connector and KMeans code are excerpted, but the SQL commands and Tableau workbook were not inspected, so their internal behavior and data wiring are not inferred.

Main entry points: [`prachidbcommands.txt`](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachidbcommands.txt) (Database Load Commands), [`fact1.csv`](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/fact1.csv) (Fact Data), [`customer1.csv`](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/customer1.csv) (Customer Data), [`product1.csv`](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/product1.csv) (Product Data)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data and Database"]
  node_customer_csv["Customer Data<br/>[customer1.csv]"]
  node_product_csv["Product Data<br/>[product1.csv]"]
  node_transaction_csv["Transaction Data<br/>[transaction1.csv]"]
  node_fact_csv["Fact Data<br/>[fact1.csv]"]
  node_load_commands["Database Load Commands"]
  node_mysql[("Local MySQL")]
end

subgraph group_analysis["Analysis"]
  node_db_connector["Database Connector<br/>[prachidbconnect.py]"]
  node_olap["OLAP Operations<br/>[prachidbconnect.py]"]
  node_kmeans["KMeans Clustering<br/>[prachikmeans.py]"]
  node_kmeans_output["Cluster Labels and Centroids<br/>[prachikmeans.py]"]
end

subgraph group_visualization["Visualization"]
  node_tableau["Tableau Visualizations"]
end

node_kmeans_input["Local fact.csv"]

node_customer_csv -->|"combines into"| node_fact_csv
node_product_csv -->|"combines into"| node_fact_csv
node_transaction_csv -->|"combines into"| node_fact_csv
node_customer_csv -->|"loads"| node_load_commands
node_product_csv -->|"loads"| node_load_commands
node_transaction_csv -->|"loads"| node_load_commands
node_load_commands -->|"populates"| node_mysql
node_db_connector -->|"queries"| node_mysql
node_db_connector -->|"performs"| node_olap
node_kmeans -->|"reads"| node_kmeans_input
node_kmeans -->|"prints"| node_kmeans_output

click node_customer_csv "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/customer1.csv"
click node_product_csv "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/product1.csv"
click node_transaction_csv "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/transaction1.csv"
click node_fact_csv "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/fact1.csv"
click node_load_commands "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachidbcommands.txt"
click node_db_connector "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachidbconnect.py"
click node_olap "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachidbconnect.py"
click node_kmeans "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachikmeans.py"
click node_kmeans_output "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachikmeans.py"
click node_tableau "https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachibivisualization.twb"

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_customer_csv,node_product_csv,node_transaction_csv,node_fact_csv,node_load_commands,node_mysql toneBlue
class node_db_connector,node_olap,node_kmeans,node_kmeans_output toneAmber
class node_tableau toneMint
class node_kmeans_input toneIndigo
```

## Components

### Data and Database

- [Customer Data](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/customer1.csv): `customer1.csv`
- [Product Data](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/product1.csv): `product1.csv`
- [Transaction Data](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/transaction1.csv): `transaction1.csv`
- [Fact Data](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/fact1.csv): `fact1.csv`
- [Database Load Commands](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachidbcommands.txt): `prachidbcommands.txt`
- **Local MySQL**

### Analysis

- [Database Connector](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachidbconnect.py): `prachidbconnect.py`
- [OLAP Operations](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachidbconnect.py): `prachidbconnect.py`
- [KMeans Clustering](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachikmeans.py): `prachikmeans.py`
- [Cluster Labels and Centroids](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachikmeans.py): `prachikmeans.py`

### Visualization

- [Tableau Visualizations](https://github.com/prachi-mate/supermarket-data-analysis/blob/master/prachibivisualization.twb): `prachibivisualization.twb`

### Other components

- **Local fact.csv**

## Connections

- Customer Data → Fact Data: combines into (evidence: `README.md`)
- Product Data → Fact Data: combines into (evidence: `README.md`)
- Transaction Data → Fact Data: combines into (evidence: `README.md`)
- Customer Data → Database Load Commands: loads (evidence: `README.md`)
- Product Data → Database Load Commands: loads (evidence: `README.md`)
- Transaction Data → Database Load Commands: loads (evidence: `README.md`)
- Database Load Commands → Local MySQL: populates (evidence: `README.md`)
- Database Connector → Local MySQL: queries (evidence: `prachidbconnect.py`)
- Database Connector → OLAP Operations: performs (evidence: `prachidbconnect.py`)
- KMeans Clustering → Local fact.csv: reads (evidence: `prachikmeans.py`)
- KMeans Clustering → Cluster Labels and Centroids: prints (evidence: `prachikmeans.py`)
