Utilização de software para automatização de base de dados e aumento na eficiência nos resultados na área de Supply Chain

Abstract

With the need for companies to generate dynamic reports with graphics, Microsoft Power BI dominated this subject and became the main intelligence tool in the market. The challenge of this work was to propose improvements in the Supply Chain department of the company LongPing High Tech by transforming an extensive database, called Sales Orders, into graphical results and better visualization, and Power BI was the appropriate tool to apply in this study. Thus, the proposed methodology was implemented based on the development of a job in Oracle to automate and reduce the time taken to extract the SAP database, resulting in a significant decrease from twenty-four to eight hours, considered as the first pilot project. Consequently, the WH Embarques report that shows the company's billing in various types of analysis, which its database is the Sales Order, that is, the frequency of automation increased from twenty-four to eight hours as well. Additionally, another improvement was applied by compiling all the company's data from 2019 to 2021 into a single Sales Orders and, later, the updated base of the year was gathered, so that the job in Oracle could execute in less time and, consequently, generate the database and the Shipments WH report with the highest daily frequency. This scenario was considered as a second pilot project. With that, two pilot projects were applied, the first with four months and the second with just one month, with the objective of guaranteeing the integrity of all the company's data. Thus, with the application of these two pilot projects, a significant reduction in the time between each report was achieved, from one day to just four hours and, consequently, a sixfold increase in the frequency of generating the company's official results during the day. The application of the methodology of this case study optimized and accelerated the dynamics of countless processes, motivating other departments to follow the same application of improvement.