BUSINESS INTELLIGENCE IN THE TOOL MANAGEMENT USED BY THE CUT AND CNC MACHINES OF THE ORNAMENTAL ROCKS INDUSTRY

Abstract

In the ornamental stone industry, improving production processes is a constant challenge for managers looking for solutions that improve the competitiveness of the companies. The management of cutting and computerized cut command machine tools is one of the areas where this improvement in management processes can have a positive effect on the competitiveness and productivity of companies. With this purpose, a model based on business intelligence methodologies was developed to systematize and automate the management process. The proposed model consists of the following layers: acquisition, extract, transform and load, storage and access and analysis. The acquisition layer consists of the interface with data available in various formats. The extract, transform and load process aims to extract data from these repositories and load them into a data warehouse. While the access and analysis phase is based on the use of software tools with graphical user interface with advanced analysis reporting features. The technology infrastructure is supported by the open source Tibco Jaspersoft Community Edition software package, which provides tools for the practical implementation of the defined model. With this work, it is hoped to implement the defined business intelligence model thus giving answers to the problems identified by providing information for the decision-making that corresponds to the needs of the managers.