Significant advances have been made on the shop floor in recent decades, involving substantial investments in infrastructure, automation, training and information systems which have transformed the shop floor into a strategic area for companies. Today, the shop floor generates large quantities of data; however, because they are dispersed or disorganized, these data are not used to the best possible advantage as a source of valuable information. In view of this deficiency, this paper proposes the implementation of a Business Intelligence system, using Data Warehouse and OLAP tools specifically applied to the shop floor. Our objective is to develop a system that uses production data, transforming them into information to aid managers in decision-making, thereby enhancing the company’s competitiveness. A prototype of the system was built with simulated data to test the viability of this proposal.
decision-making support system; business intelligence; data warehouse; OLAP; shop floor