Izrada skladišta podataka i praćenje povijesti unutar skladišta podataka

master's thesis

• Title (english): Creating a data warehouse and tracking history within the data warehouse
• Author: Tea Čutić
• Mentor: Boris Vrdoljak (mentor)
• Committee member: Boris Vrdoljak (predsjednik povjerenstva)
• Committee member: Marko Horvat (član povjerenstva)
• Committee member: Danijel Mlinarić (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2024-09-12, Croatia

Abstract

Tema ovog rada je modeliranje i implementacija skladišta podataka za podatke o
internetskoj prodaji. Za punjenje skladišta podataka korišten je ETL proces izrađen u
alatu Talend Open Studio. Podatci za obradu preuzeti su sa stranice Kaggle te dodatno
obrađeni s pomoću vlastitih Jupyter Notebook skripti. Prije modeliranja skladišta i
ETL procesa, dan je odgovarajući teorijski uvod koji služi kao vodilja pri izradi. Posebna
pozornost pri izradi pridaje se zahtjevu za praćenjem povijesti promjena podataka
u skladištu. Nakon uspješne implementacije skladišta i provedbe ETL procesa,
pohranjeni podatci su iskorišteni za izradu poslovnih izvješća. Za izlaganje skladišta
podataka poslovnim analitičarima, odabran je alat Power BI u kojem je ostvarena veza
na postavljeno skladište.

Abstract (english)

The subject of this thesis is modeling and implementation of a data warehouse for
online sales data. An ETL process created in the Talend Open Studio tool was used
to fill the data warehouse. Data for processing were downloaded from the Kaggle site
and additionally processed using custom Jupyter Notebook scripts. Before modeling
the warehouse and the ETL process, a suitable theoretical introduction is given that
serves as a guide for the development process. During the process of modeling, special
attention is given to the request for monitoring the history of data changes in the
warehouse. After the successful implementation of the warehouse and implementation
of the ETL process, the stored data was used to create business reports. In order to
expose the data warehouse to business analysts, the Power BI tool was chosen, and in
it established connection to the installed warehouse.

• Keywords: Skladište podataka; ETL proces; PostgreSQL; Talend Open Studio; Power BI
• Keywords (english): Data warehouse; ETL process; PostgreSQL; Talend Open Studio; Power BI
• Language: croatian
• URN:NBN: urn:nbn:hr:168:919208
• Study programme: Title: 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 resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2024-10-12 20:21:33