The use of Business Intelligence to produce performance indicators in the shop floor: an application proposal in a manufacturing company / O uso de business intelligence para gerar indicadores de desempenho no chão-de-fábrica: uma proposta de aplicação em uma empresa de manufatura
AUTOR(ES)
Marcos Roberto Fortulan
DATA DE PUBLICAÇÃO
2006
RESUMO
The shop floor evolution in the last century has transformed it in a strategic area for the companies, through which is possible to reach and to satisfy the customers needs. This new shop floor generates today a great amount of data by the productive process controls, the ones which, in many cases, after its immediate use or in a short period, are discarded or stored inadequately, disabling or making impossible its access. These data, however, can come to have an important use as raw material for the production of useful information to the business administration. Together to the need that the companies have today to possess an appropriated performance measure system, it is possible to obtain, from the historical shop floor data, a good performance indicators group for the area. For that, these data must be modeled by systems specifically designed for this purpose. These systems have been treated as decision support systems (DSS) or Business Intelligence (BI). As solution for the problems above, it was made a review over the following themes: information systems, ERP, performance measure system, information quality, DSS/BI, as well as a review about the scientific works related to this thesis theme. Once consolidated these concepts, started the development of a BI dimensional model, that used Data Warehouse tools, On Line Analytical Processing (OLAP) and Data Mining. It was used the Analysis Services software, belonged to the Microsoft SQL Server 2000 database. In the following, the model was tested with real data from a metal-mechanic company branch, called here as company A. Through the model and of the real data, a series of analyses was accomplished with the intention of showing the model contribution, capacity, flexibility and use easiness, reaching the proposed objective
ASSUNTO(S)
business intelligence sistema de apoio à decisão data warehouse olap olap data mining and shop floor business intelligence data mining e chão-de-fábrica decision support systems data warehouse
Documentos Relacionados
- Uma proposta de aplicação de business intelligence no chão-de-fábrica
- Desenvolvimento de indicadores da manufatura enxuta utilizando ferramentas de business intelligence : uma aplicação na manufatura de calçados
- Proposal for design performance indicators as strategic support.
- Proposta de uma metodologia de gestão de mudanças: aplicação em uma empresa desenvolvedora de software
- Educação e estratégias dos trabalhadores de chão-de-fábrica para ocupação de cargos de chefia