Please use this identifier to cite or link to this item:
http://hdl.handle.net/10609/45901
Title: | Magatzem de dades : Mobilitat d'estudiants Erasmus |
Author: | Cabello Martín, Carlos |
Tutor: | Antich Luque, Bartomeu |
Others: | Universitat Oberta de Catalunya |
Abstract: | This project is related to the data warehouse area which is widely used in the business world nowadays, both in private and public companies. We are talking about a historical database with information specifically designed to process queries efficiently in order to make important decisions on time. To be precise we need a BI open source solution in this project which permits an accurate analysis about Erasmus student's mobility, focusing on the student's movements between countries belonging to the program, Universities who send the highest number of students and Universities at which the students spend their Erasmus period, etc. To achieve this solution, we have created a data warehouse in order to cover all the existing concepts contained in the source files. We have transformed the data using ETL processes. Also, we have created a multidimensional model in order to use the data in depth by means of a web-based platform. The selected software for doing these tasks has been BI Pentaho. |
Keywords: | data warehouse Pentaho business intelligence star schema OLAP ETL |
Document type: | info:eu-repo/semantics/bachelorThesis |
Issue Date: | 11-Jan-2016 |
Publication license: | http://creativecommons.org/licenses/by-nc-nd/3.0/es/ |
Appears in Collections: | Bachelor thesis, research projects, etc. |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
ccabellomTFC0116presentació.pptx | Presentació en PowerPoint TFC magatzem de dades | 1,1 MB | Microsoft Powerpoint XML | View/Open |
ccabellomTFC0116video.mp4 | Video presentació TFC magatzem de dades | 32,14 MB | MP4 | View/Open |
ccabellomTFC0116memòria.pdf | Memòria del TFC sobre magatzem de dades | 2,54 MB | Adobe PDF | View/Open |
ccabellomTFC0116presentació.pdf | Presentació del TFC en pdf | 779,69 kB | Adobe PDF | View/Open |
Share:
This item is licensed under a Creative Commons License