Glencore Coal Assets Australia
The health and safety of the operators of large mining equipment is a major focus for Glencore.
The challenge
Key challenges:
- near real-time integration of data replicated from eleven open-cut mine sites
- provisioning a database and supporting load processes that could consolidate data received from sites
- building an initial reporting suite tailored to the needs of OAMC personnel
- establishing a self-service capability to enable OAMC personnel to intuitively build their own reports.
The solution
An end-to-end data centralisation and reporting solution was provisioned that consisted of:
- a central SQL Server database where data from eleven mine sites is consolidated
- an automated near real-time data integration process
- a self-service semantic data model implemented with Microsoft Analysis Services
- a foundational set of Power BI reports that automatically refresh in near real-time (the reports present both live operational data as well as historical trends).
The outcome
The solution went live shortly after the establishment of the OAMC, and the reports enabled a key capability in the overall function of the OAMC. Providing visibility of driver fatigue data in the context of broader historical trends has allowed OAMC personnel to identify anomalies in real-time and take appropriate action. The self-service component of the solution provides a foundation upon which custom reports can be rapidly built by senior OAMC staff. The reporting solution has also assisted GCAA management in identifying longer-term initiatives for driving operator awareness improvements across their open-cut mines.