Application of business intelligence for inventory management and control
DOI:
https://doi.org/10.47456/bjpe.v9i5.42589Keywords:
Inventory management, Microsoft Power BI, Power AppsAbstract
The constant need of organizations to serve their customers with efficiency, effectiveness and agility, makes it necessary to develop good inventory management. Therefore, technological tools have been developed and used by organizations in the management of data related to inventory. Given this scenario, the present study was developed with the objective of creating an application for management and inventory control through the Business Intelligence tool (Power BI), with indicators that will show all inputs and outputs of inputs in real time in a food sector company. To identify the company's needs, the sector's routines were monitored and the way in which the managerial reports on incoming and outgoing goods were created were monitored. Thus, an application was developed in Power Apps Software to improve the process of capturing information related to stock, inputs and outputs. Power BI Software was used to monitor and analyze indicators and stock levels. Thus, it was observed that the application can provide an 80% reduction in the time spent posting inputs and outputs of items, in addition to reducing, by 33%, the time with checking items of higher purchase priority.
Downloads
References
Banzato, E. (2005) Tecnologia da informação aplicada à logística. 1ª ed. São Paulo/SP: IMAM.
Batista, E. O. (2012). Sistemas de Informação: O Uso Consciente da Tecnologia para o Gerenciamento. São Paulo: Saraiva.
Bowersox, D. J. & Closs, D. J. (2001). Logística empresarial: o processo de integração da cadeia de suprimento. São Paulo, Atlas.
Castro, L. A. (2020). Dashboard em Power BI: Consolidação e análise de indicadores de performance de usinas de beneficiamento. Revista Científica Multidisciplinar Núcleo do Conhecimento, 18, 21-30.
Council of Logistics Management. (1996). Recuperado de www.clm1.org.br. Article 1.
Dias, M. A. P. (1993) Administração de materiais: uma abordagem logística. São Paulo: Atlas.
Dalfovo, O. & Tamborlin, N. (2010). Business Intelligence. Joinville/SC: Clube dos Autores.
Dias, M. A. (2012). Administração de materiais: uma abordagem logística. 6ª ed., São Paulo: Atlas.
Fleury, P. F., Wanke, P., & Figueiredo, K. F. (2003). Logística e gerenciamento da cadeia de suprimentos: planejamento do fluxo de produtos e dos recursos. São Paulo, Atlas.
Martins, P. G. & ALT, P. R. C. (2004). Administração de materiais e recursos patrimoniais. São Paulo: Saraiva.
Microsoft. Power-Apps. (2022). Preços do Power Apps. Recuperado de https://powerapps.microsoft.com/pt-br/pricing/
Microsoft. Power-Apps (2022). Adicionar conexões de dados a aplicativos de tela. Recuperado de https://learn.microsoft.com/pt-br/power-apps/maker/canvas-apps/add-dataconnection
Morais, R. R. (2015). Logística empresarial. Curitiba: InterSaberes, 259p.
Moura, A. R. (2002). LOG&MAN Logística, Movimentação e Armazenagem de Materiais. Guia do visitante da MOVIMAT.
Ramalho, A. V. O. (2019). Automatização de indicadores utilizando software de Business Intelligence. Monografia (Graduação em Engenharia de Controle e Automação) - Escola de Minas, Universidade Federal de Ouro Preto, Ouro Preto.
Soares, A. C. F. (2017). Análise de Ferramentas de Business Intelligence com destaque dos serviços de BI na Cloud Computing.
Viana, J. J. (2002). Administração de materiais: um enfoque prático. São Paulo: Atlas.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Brazilian Journal of Production Engineering
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Atribuição-NãoComercial-CompartilhaIgual
CC BY-NC-SA
This license lets others remix, adapt, and build upon your work non-commercially, as long as they credit you and license their new creations under the identical terms.
