A smart monitoring solution to track and analyze open-pit mining operations. This project focuses on optimizing cycle durations, reducing downtime, and visualizing real-time performance using Tableau dashboards.

Problem Statement: The mine is unable to meet production expectations due to equipment inefficiencies, despite no increase in demand. Manual tracking is ineffective due to the mine’s size.

Key Objectives:
- Clean and structure operational data using Python
- Build SQL stored procedures for OEE calculation
- Visualize metrics like equipment availability, loading efficiency, and fuel-to-distance ratio
- Recommend improvements based on Tableau insights

Dashboard Focus:
- Equipment availability
- Real-time cycle completion tracking
- High/Low performing machines
- Operational Efficiency & Accuracy