Implementation of business intelligence system to analyze the data for mining mechanization – case study

Abstract

In this article, we focused on the experimental implementation of the Power BI application in the field of mining mechanization. This application was created to demonstrate how an interactive data visualization tool can streamline data exploration and provide new insights that can be used to optimize selected processes. The monitored company uses a large number of reports in connection with the organization of the company. They collect many data from the attendance system and the electronic resource planning system, but also a lot of operational data related to the performance of mining mechanization. These data are evaluated in the company only at one-month intervals. Our intention was to transform the data for the year 2021 and create various visual reports through the power BI program, which, thanks to detailed analysis and evaluation, will help to improve the management of mining mechanization. The source of information in our case were tables that contained very poorly arranged data that could not be imported into the Power BI program in the given state. After collecting the data, we had to transform them, which was a very time-consuming process. Due to limited resources, we had to adjust our original plan. From the entire portfolio of mining mechanization, which consists mainly of mining drills, loaders and trucks, we decided to only process data from mining trucks. The result will be a demonstration of the usability of the power BI system in a mining company to manage information related to mining trucks, but the same approach can be used for all types of mining mechanisms. Implementation of the power BI system was performed on data from one of the biggest underground mines in Slovakia.