prikaz prve stranice dokumenta Skladište podataka za međunarodne nogometne utakmice
No public access
master's thesis
Skladište podataka za međunarodne nogometne utakmice
Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing, 2023. urn:nbn:hr:168:933857
Milički, Magda
University of Zagreb
Faculty of Electrical Engineering and Computing

Institutional repository: FER Repository

Cite this document

Milički, M. (2023). Skladište podataka za međunarodne nogometne utakmice (Master's thesis). Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing. Retrieved from https://urn.nsk.hr/urn:nbn:hr:168:933857

Milički, Magda. "Skladište podataka za međunarodne nogometne utakmice." Master's thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, 2023. https://urn.nsk.hr/urn:nbn:hr:168:933857

Milički, Magda. "Skladište podataka za međunarodne nogometne utakmice." Master's thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, 2023. https://urn.nsk.hr/urn:nbn:hr:168:933857

Milički, M. (2023). 'Skladište podataka za međunarodne nogometne utakmice', Master's thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, accessed 19 June 2024, https://urn.nsk.hr/urn:nbn:hr:168:933857

Milički M. Skladište podataka za međunarodne nogometne utakmice [Master's thesis]. Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing; 2023 [cited 2024 June 19] Available at: https://urn.nsk.hr/urn:nbn:hr:168:933857

M. Milički, "Skladište podataka za međunarodne nogometne utakmice", Master's thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, Zagreb, 2023. Available at: https://urn.nsk.hr/urn:nbn:hr:168:933857

Metadata
TitleSkladište podataka za međunarodne nogometne utakmice
Title (english)Data warehouse for international football matches
AuthorMagda Milički
MentorBoris Vrdoljak (mentor)
Committee memberBoris Vrdoljak (predsjednik povjerenstva)
Committee memberVedran Mornar (član povjerenstva)
Committee memberMarko Horvat (član povjerenstva)
GranterUniversity of Zagreb
Faculty of Electrical Engineering and Computing
Zagreb
Defense date and country2023-07-03, Croatia
Abstract
Tema ovog diplomskog rada bila je izrada skladišta podataka i analiza podataka za međunarodne nogometne utakmice. Ovim diplomskim radom koncipirano je skladište podataka te su kreirani izvještaji u više alata za izvještavanje. ETL proces podijeljen je u tri faze. U prvoj je fazi obavljeno kopiranje podataka iz izvornog skupa podataka, a podaci su nepromijenjeni. Druga je faza XTR mapiranje koja služi za transformaciju i čišćenje podataka. Zadnja faza služi za punjenje činjenične i dimenzijskih tablica koje kasnije služe kao izvor podataka u izvještajima. Skladište podataka implementirano je korištenjem PostgreSQL-a, ETL proces implementiran je alatom Talend Studio dok su izvještaji izrađeni u alatima Power BI, Qlik Sense i Tableau.
Abstract (english)
The main topic of this paper was the creation of a data warehouse and data analysis for international football matches. With this thesis, a data warehouse was designed and reports were created in several reporting tools. The ETL process is divided into three phases. In the first stage, the data was copied from the original data set, and the data was unchanged. The second stage is XTR mapping, which serves to transform and clean the data. The last stage serves to fill the fact and dimension tables, which later serve as a source of data in the reports. The data warehouse was implemented using PostgreSQL, the ETL process was implemented using the Talend Studio tool, and the reports were created in Power BI, Qlik Sense and Tableau tools. The thesis describes the data warehouse, the description of the ETL process and the created reports.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:168:933857
Study programmeTitle: Computing
Study programme type: university
Study level: graduate
Academic / professional title: magistar/magistra inženjer/inženjerka računarstva (magistar/magistra inženjer/inženjerka računarstva)
Type of resourceText
File originBorn digital
Access conditionsClosed access
Terms of useLicence In copyright icon
Public note
Created on2023-10-11 09:51:07