Diseño de sistema data warehouse sobre una arquitectura en la nube aplicado a caso de estudio.

Abstract

This degree project aims to design a Cloud Data Warehouse system on a Cloud architecture for a medium-sized commercial company. This project is carried out to streamline the processes of information management, control, monitoring, and updating of the data of the branches that the company Bikes Extreme Ecuador has. Likewise, the present project will serve as an adequate reading of the data generated by sales, supplier management, and customer control for decision-making by the company's management. Concerning the method applied, the CRISP-DM methodology was first proposed for the data's adequacy, management, and transformation. CRISP-DM establishes a series of steps to configure the data to be worked on. Second, the MSF methodology was used to implement the necessary infrastructure in Cloud the Cloud for the construction of the Cloud Data Warehouse. In addition, a data visualization tool was used to present results easily and adequately. Finally, it can be concluded that adequate control and analysis of the information were achieved through the present investigation and with the appropriate implementation of this type of infrastructure. Additionally, the data visualization tool achieved a correct way of presenting the information. Therefore, this tool efficiently contributed to a correct interpretation of the data provided by the infrastructure and correct decision-making by the company's directive mentioned above.