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

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 onemonth 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.