Creación de Dashboard de información de base de datos a través de Power BI para el área de Dispatching en Schlumberger

Abstract

In Dispatching area, a new database is being implemented in Oracle, its objective is to capture the purchasing requirements (SC) that BOT system does not automatically recognize and it´s be able to take this information to show it to the Dispatchers. The purchase requirements that it does not recognize are: the user code belonging to each requirement or Shopping Card (SC), the purchase requirements from a system called SAP ECC and the code of the product or service associated with the purchase (commodity). In this new database it is not possible to understand in a quick way, all the information contained due to the way it is presented on the website, in addition allows you to control the functionality of the tool by limiting the possibility of visualize the information in a way that allows it to be analyzed in order to make decisions for its improvement. That is why as a solution to these shortcomings and in order to improve and complement the functionality of the Oracle tool, making the information more dynamic, visual and easy to understand for its subsequent analysis, control and finally decision-making, it will be created a Dashboard in Microsoft Power BI; a tool that uses Business Intelligence to reflect the data in a way that allows it to be quickly analyzed without requiring much time to study it, in turn, offers the possibility of relating all kinds of variables included in the database, thus achieving its adaptability, generating the visualization desired according to the needs of each user. All of this because through the analysis of the information displayed in the Dashboard, the team can take the necessary mechanisms to reduce the level of exceptions that are processed manually and on the contrary increase the level of SC processed by the BOT system, therefore this will reduce the processing times for each SC, improving the effectiveness of the Supply Service Center (SSC).