University of Twente Student Theses


Design and development of a sports data warehouse for FC Twente

Vianen, S. van (2023) Design and development of a sports data warehouse for FC Twente.

Full text not available from this repository.

Full Text Status:Access to this publication is restricted
Abstract:Data and the usage of data is a big focus point in professional sport. The rise of Data science techniques, for example machine learning, to provide not only descriptive but also predictive insights support this development. This increase in data usage makes adequate infrastructure necessary. This project designs a data warehouse for FC Twente, tackling this very problem and providing FC Twente with infrastructure to improve their current data analysis processes and supporting and enabling future projects. Following an in depth problem description and architecture analysis, related projects are described and their impact on this project explained, before elaborating on data warehousing concepts and describing the methodology to design the data warehouse. To validate the design a proof-of-concept is developed using Microsoft SQLServer Integration Services for the extract transform-load processes and Microsoft SQLServer as database management software. Finally a example dashboard was build using Microsoft PowerBI. The proof-of-concept indicated, that the design could fulfl the following identifed objectives: 1. Own data is stored internally and dependencies are reduced 2. Daily manual processes are reduced 3. Data from different sources is in an consistent manner combined and can be analyzed together 4. The solution is scalable with an increase in data volume and velocity 5. The data preparation and cleaning for new data science projects is minimized 6. FC Twente can maintain this solution Furthermore, the methodology proposed by Vaisman and Zilmani, which consists of requirement specifcation, conceptual design, logical design and physical design, was deemed to be a suiting design process to design a data warehouse in a professional sporting environment. Lastly, a centralized data warehouse architecture lacking a staging area, with a storage and OLAP layer, but with the ability for the user layer to directly access the relational database was chosen.
Item Type:Essay (Master)
FC Twente, Enschede, Netherlands
Faculty:EEMCS: Electrical Engineering, Mathematics and Computer Science
Subject:54 computer science, 85 business administration, organizational science
Programme:Business Information Technology MSc (60025)
Link to this item:
Export this item as:BibTeX
HTML Citation
Reference Manager


Repository Staff Only: item control page