A Unified Manufacturing Data Platform
Hackathon Submission for Summer Open 2025
PlantUnify is a centralized data platform that ingests, standardizes, and visualizes production reports from seven independent manufacturing plants. Each plant had historically used inconsistent Excel formats, making performance tracking and decision-making at HQ time-consuming and error-prone.
Our solution automates this process end-to-end.
- ✅ Flexible ingestion of 7 different Excel formats
- ✅ Mapping & standardization pipeline with custom JSON maps
- ✅ Data cleaning including type enforcement and downtime conversion
- ✅ Unified KPIs across all plants:
- Total Bottles Produced
- Defect Rate
- Downtime (Minutes)
- Shift-wise Distribution
- ✅ Interactive Streamlit dashboard for HQ visibility
- Python
- Pandas (data wrangling)
- Streamlit (dashboard UI)
- Plotly (visualizations)
- JSON (schema mapping)