annamapule/South-African-Mining-Data-Analysis

**Click here to view the Interactive Live Tableau Dashboard** ## South African Opencast Mining Fleet Optimization 🚜🇿🇦 ### Business Problem: An opencast coal mine in Mpumalanga is missing its daily production targets. This project analyzes Fleet Management System (FMS) logs to isolate haul cycle bottlenecks and truck delays. ### Core Skills Demonstrated: * Relational Database Architecture (`CREATE TABLE` with Primary Keys) * High-Volume Data Ingestion (`INSERT OR IGNORE`) * Operational Metrics Analytics (`strftime` for cycle time calculations) * Data Aggregation & Profiling (`SUM`, `AVG`, `GROUP BY`) ### Operational Insights & Business Impact: * **Fleet Efficiency:** Truck `TR01` maintained an optimal loading performance profile, averaging **5.0 minutes** per load cycle and moving **382.5 tons** over 2 trips. * **Production Bottleneck:** Truck `TR02` experienced severe delays, averaging **20.5 minutes** per load cycle due to a recorded mechanical failure event, dragging down total material movement efficiency to the crusher.