Please use this identifier to cite or link to this item: http://hdl.handle.net/10609/126886
Title: Implantació de business intelligence a un grup hoteler
Author: Gómez López, Sergio
Director: Daradoumis Haralabus, Atanasi
Tutor: Andrés Sanz, Humberto
Keywords: ETL
analytical model
dashboard
Issue Date: 7-Jan-2021
Publisher: Universitat Oberta de Catalunya (UOC)
Abstract: The year 2020 will be remembered for the fight against COVID-19 and the effects of the global pandemic which has caused an unprecedented health, social and economic crisis. At an economic level, the uncertainty generated by the pandemic caused a major crisis in the hotel sector. The consequence of the crisis has meant that hotel managers have to pay much more attention to ensure business viability. Good decision making is always based on experience, intuition and data. While experience and intuition are within our control, the numbers and information of businesses are often hidden within the company's databases. This is where Business Intelligence is increasingly important for large or medium-sized hotel groups. This work aims to implement a hotel management BI solution to offer an adequate response to the information needs of hotels. The Sales and Reservation information to provide management with a tool that helps them make decisions. This solution, developed with Microsoft technology, encompasses the following phases. The integration phase, where the ETL processes necessary to create a DWH will be defined. The data modelling phase, where a DataMart will be implemented that will help us to exploit the information in the reports. And finally, the data visualization phase, where the creation of the necessary reports by the hotel group will be discussed.
Language: Catalan
URI: http://hdl.handle.net/10609/126886
Appears in Collections:Bachelor thesis, research projects, etc.

Files in This Item:
File Description SizeFormat 
Gomez_Lopez_Sergio_Presentacio¿_TFG_BI.pdfPresentació5,69 MBAdobe PDFThumbnail
View/Open
sergiogmzTFG0121memòria.pdfMemòria del TFG3,97 MBAdobe PDFThumbnail
View/Open