Realization of Big Data Analytics Tool for optimization processes within the Finnish engineering company
Karapetyan, Karina (2016)
Karapetyan, Karina
Savonia-ammattikorkeakoulu
2016
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2016052610168
https://urn.fi/URN:NBN:fi:amk-2016052610168
Tiivistelmä
Big Data Analytics Tool offers an entire business picture for making both operational and strategic decisions from selecting the product price to establishing the priorities for the further vendor’s enhancement.
The purpose of the thesis was to explore the industrial system of Hydroline Oy and provide a software solution for the elaboration of the manufacture, due to the internal analyzing within the company.
For the development of Big Data Analytics Tool, several software programs and tools were employed. Java-written server controls all components in the project and visualizes the processed data via a user-friendly client web application. The SQL Server maintains data, observed from the ERP system. Moreover, it is responsible for the login and registration procedure to enforce the information security. In the Hadoop environment, two research methods were implemented. The Overall Equipment Effectiveness model investigated the production data to obtain daily, monthly and annual efficiency indices of equipment utilization, employees’ workload, resource management, quality degree, among others. The Machine Processing sample indicated the amount of machines in each working state. The server executes Hive queries via Secure Shell and forwards the analyzed data in the graphical form to the client.
The objectives set in the thesis were completed as the research progressed: as a result of the accomplished work, a fully functional Big Data Analytics Tool was carried out for Hydroline Oy. The work can be used as a RDI project to forecast possible fault rates, diminish the manufacturing loss and, most importantly, gain greater business value by modernizing the whole venture’s structure.
The purpose of the thesis was to explore the industrial system of Hydroline Oy and provide a software solution for the elaboration of the manufacture, due to the internal analyzing within the company.
For the development of Big Data Analytics Tool, several software programs and tools were employed. Java-written server controls all components in the project and visualizes the processed data via a user-friendly client web application. The SQL Server maintains data, observed from the ERP system. Moreover, it is responsible for the login and registration procedure to enforce the information security. In the Hadoop environment, two research methods were implemented. The Overall Equipment Effectiveness model investigated the production data to obtain daily, monthly and annual efficiency indices of equipment utilization, employees’ workload, resource management, quality degree, among others. The Machine Processing sample indicated the amount of machines in each working state. The server executes Hive queries via Secure Shell and forwards the analyzed data in the graphical form to the client.
The objectives set in the thesis were completed as the research progressed: as a result of the accomplished work, a fully functional Big Data Analytics Tool was carried out for Hydroline Oy. The work can be used as a RDI project to forecast possible fault rates, diminish the manufacturing loss and, most importantly, gain greater business value by modernizing the whole venture’s structure.