Please use this identifier to cite or link to this item:

http://hdl.handle.net/10609/90505
Title: Solució BI per al control i anàlisi dels processos de producció d'una enginyeria civil
Author: Jiménez Gallego, Marta
Tutor: Martínez Fontes, Xavier
Keywords: data warehouse
business intelligence
ETL
dashboard
process control
Issue Date: Jan-2019
Publisher: Universitat Oberta de Catalunya (UOC)
Abstract: The final Project consists in the elaboration of a system to control and analyze the processes performed in a Civil Engineering Company, as a solution to solve the problems identified in its management and in its information control. The project covers all necessary phases for the implementation of the prototype system, which has been divided into three parts: Analysis of Requirements, Design and Implementation. In the Analysis of Requirements, the procedures of the organization and the data sources have been studied to identify the needs. In the Design phase, the data model of the DataWarehouse and the mockups of the graphical interface have been designed using DCU techniques in order to obtain a good user experience. In the Implementation phase, the ETL processes have been carried out using the application Spoon, of the Pentaho platform. Qlik Sense Desktop has been used to elaborate the prototype's dashboard. The final product is a dashboard with several screens, which allows the control and analysis of the organization's production processes. Given its high level of interaction the tool is very flexible and at the same time, its use is intuitive and simple, suitable for non-expert staff. In short, the objective of the project has been to enter the BI world and allow the company to know and analyze the efficiency of the processes and the way in which they are carried out with the aim of improving the decision-making regarding the production processes and optimize them. In the same vein, different future working lines have been established after the detection of possible improvements in the management of processes.
Language: Catalan
URI: http://hdl.handle.net/10609/90505
Appears in Collections:Bachelor thesis, research projects, etc.

Share:
Export:
Files in This Item:
File Description SizeFormat 
mjimenezgallTFG0119memòria.pdfMemòria del TFG3.53 MBAdobe PDFView/Open

This item is licensed under a Creative Commons License Creative Commons