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.
