How prachi-mate/supermarket-data-analysis works
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 Database Load Commands · fact1.csv Fact Data · customer1.csv Customer Data · product1.csv Product Data
Components 12
Data and Database
- Customer Data
customer1.csv - Product Data
product1.csv - Transaction Data
transaction1.csv - Fact Data
fact1.csv - Database Load Commands
prachidbcommands.txt - Local MySQL
Analysis
- Database Connector
prachidbconnect.py - OLAP Operations
prachidbconnect.py - KMeans Clustering
prachikmeans.py - Cluster Labels and Centroids
prachikmeans.py
Visualization
- Tableau Visualizations
prachibivisualization.twb
Other components
- Local fact.csv
Connections 11
- Customer Data → Fact Data: combines into
README.md - Product Data → Fact Data: combines into
README.md - Transaction Data → Fact Data: combines into
README.md - Customer Data → Database Load Commands: loads
README.md - Product Data → Database Load Commands: loads
README.md - Transaction Data → Database Load Commands: loads
README.md - Database Load Commands → Local MySQL: populates
README.md - Database Connector → Local MySQL: queries
prachidbconnect.py - Database Connector → OLAP Operations: performs
prachidbconnect.py - KMeans Clustering → Local fact.csv: reads
prachikmeans.py - KMeans Clustering → Cluster Labels and Centroids: prints
prachikmeans.py