Desenvolvimento e implantação de um ambiente de inteligência de negócios para gestão, parametrização e projeção de materiais

Abstract

The Business Intelligence (BI) environment, when developed and implemented, allows, in a simple way, to gather, organize, store, analyze and facilitate the discovery of relationships and information with data from different sources, gathered by companies throughout their history. Decision making becomes challenging and complex, regardless of level or scale. In most companies there is a large volume of operational level data, especially in the areas of planning and control of production and inventories covering various systems and spreadsheets. This dissertation aims to know methods for the development of a data warehouse (DW), the process of extracting, transforming and loading data (ETL) and graphical dashboards (BI) and researching the challenges and results obtained by the new work published. In addition, develop and implement the BI environment following an action research methodology to apply the knowledge obtained for the projection and control of stocks in a multinational company of advanced energy solutions. With the implementation of this BI environment, a positive evolution for inventory management was proven through the updating of purchase parameters, the increase went from 8% to 82% in one year, resulting in significant savings in terms of inventory reduction and increase turnover and cash flow. First, it is expected to increase the amount of data by expanding to other production lines in the company to have the same BI environment, optimizing the time to obtain information for decision-making in inventory management with a focus on reducing high levels and having the availability of information in an increasingly simple way, through graphical panels on dashboards. Finally, share the tool with other company plants in Brazil and around the world.