Desarrollo e implementación de un Power Bi y un Power Apps para el mejoramiento de la productividad del seguimiento en las órdenes de compra en el área de Cameron VIM CELL de Schlumberger

Abstract

Schlumberger Global Oilfield & Equipment, is a French oilfield services company, founded in 1926. Today it is the largest company in the oil and gas sector, recognized for its quality and innovative services in the sector. (Schlumberger, s.f) The business practice was carried out in the purchasing area NAM (North America) for Cameron Indirectos, where the student was assigned different tasks within the department, among the main ones are: follow-up of purchase orders, processing of purchase orders. purchases that are open, provide full support to obtain the efficient payment of each one of the invoices and management of the shared mail of NAM Cameron VIM CELL (department where open and stagnant purchase orders are processed). In accordance with the foregoing, in the exercise of the practice, the lack of effective monitoring of open purchase orders was evidenced, which resulted in low efficiency. According to Chiavenato (2004) in his book Introduction to the General Theory of Administration "efficiency is to use the available resources correctly". However, despite the agents' efforts, the number of expired purchase orders increased greatly, which led to cancellations and freezing of contracts with suppliers. Consequently, a Power BI will be developed through Power Apps, which will first allow the storage of large amounts of data, which will give way to the personalized assignment by country of the purchase orders to each agent and second to have a better vision of the orders that have been previously assigned and that are in process. In this way, it is expected to increase the daily productivity of each of the agents that will be reflected in the results thrown in Power BI in the form of statistics, which will allow knowing the number of orders that are stagnant, those that have been released success and the number of days each agent takes to process and send to the finance department. Keywords: purchase order, technology, productivity, agent, supplier.