Restructuring an ETL Process and Data-Base Model for Online Analysis

• Main Author: Silva, Francisco Alagôa Pedro Batista da
• Publication Date: 2022
• Format: Master thesis
• Language: eng
• Source: Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
• Download full: http://hdl.handle.net/10362/155507
• topic: Data Warehouse; Dimensional Modeling; Online Querying; ETL; Domínio/Área Científica::Engenharia e Tecnologia::Engenharia Eletrotécnica, Eletrónica e Informática

In an ever-growing technological world, there is a lot of value in being able to quickly analyze data and make decisions in order to maintain a successful business. Imaginary Cloud is a growing Software Development and UX/UI company, and with such growth, there is an increased amount of data to be stored and processed. Therefore, it is of great importance that each department can easily access their respective data, to increase the speed of their decision-making process. In order to better analyze its performance, the company intends on developing a dash-board system for internal use that allows the visualization of relevant data dynamically, in-cluding key performance indicators. The purpose of this project will be to work alongside Imaginary Cloud to develop a tool that extracts information from multiple sources as efficiently as possible and create a central-ized database to hold the extracted data, expected to be ever expanding. The database must be optimized for the retrieval of data in real data, so that it can be queried by the dashboard system (not to be developed in this project) at the user’s request. In the end, the existence of this tool should have a major impact on how easy each de-partment can access and interpret data, allowing for more informed and faster decision mak-ing, and increasing the overall company’s efficiency.