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

http://hdl.handle.net/10609/96386
Title: Power BI - De les dades al coneixement en uns minuts
Author: Puig Molins, Eduard
Tutor: Andrés Sanz, Humberto
Keywords: data warehouse
ETL
business intelligence
vertical integration
Microsoft Power BI
decision support system
Issue Date: 14-Jun-2019
Publisher: Universitat Oberta de Catalunya (UOC)
Abstract: The scope of work of this project is to apply specific techniques for processing Business Intelligence data. Also, make use of methodologies based on the project management model defined in PMBOK. The final purpose is to be able to present and defense in front of an Assessment Tribunal the knowledge and skills acquired during the Computer Engineering Degreee and end of degree project. This work project has been developed inside a real Company, in order to fill the existing data gaps. The final result is the vertical integration of the ERP together with a decision support system (DSS). In particular, developing business intelligence tooling to support the company's operational managing board. Moreover, it will also be helpful as a mechanism for the collection and analysis of data, since this tool allows end user to create and design their own reports in an easy way. Microsoft Power BI from Microsoft is the user interface, which allows us to access to the data warehouse. Data Warehouse created during the realization of this project work is the go-to source for data sets. Data Warehouse has been the pillar for the success of the project. It was created from the infornation source of the transaction processing system placed in the company, using business intelligence techniques, like Database denormalization, ETL processes (Extract, Transform and Load) and following multidimensional analysis methodology. However, besides all the mentioned above, without the active participation of the company team, sharing its vision, experience and knowledge, this project would have never been possible. Thanks to you all.
Language: Catalan
URI: http://hdl.handle.net/10609/96386
Appears in Collections:Bachelor thesis, research projects, etc.

Share:
Export:
Files in This Item:
File Description SizeFormat 
epuigmoTFG0619memoria.pdfMemoria del TFG3.25 MBAdobe PDFView/Open

This item is licensed under a Creative Commons License Creative Commons