When starting the project, our client did not have a system that fulfilled the requirements of the company. The vast amount of data used for complex calculations was stored in an Excel file. Over the years, the amount of gathered information grew, causing a slower development of the file. With the new records’ inputting, the risk of losing data (due to overexploitation of Excel) has increased.
The second problem was the lack of data consistency. So far, when entering data, the representation of , which was recorded in a shortened way, employees had to take special care to not make any mistake. The lack of unification of terms and signs caused data discrepancy during analysis.