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
Issue
Section
License
Copyright (c) 2023 Brazilian Journal of Production Engineering
This work is licensed under a Creative Commons Attribution 4.0 International License.
All works published in the Brazilian Journal of Production Engineering (BJPE) are licensed under Creative Commons Attribution 4.0 International (CC BY 4.0).
This means that:
Anyone can copy, distribute, display, adapt, remix, and even commercially use the content published in the journal;
Provided that due credit is given to the authors and to BJPE as the original source;
No additional permission is required for reuse, as long as the license terms are respected.
This policy complies with the principles of open access, promoting the broad dissemination of scientific knowledge.
2.png)
