| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:Obdelava in priprava podatkovne kocke OLAP
Authors:ID Povhe, Gregor (Author)
ID Rajkovič, Uroš (Mentor) More about this mentor... New window
Files:.pdf VS_Povhe_Gregor_2016.pdf (1,10 MB)
MD5: 66F4A4BBE2F77F29772C5183F606BABC
 
Language:Slovenian
Work type:Bachelor thesis/paper
Organization:FOV - Faculty of Organizational Sciences in Kranj
Abstract:Diplomsko delo prikazuje obdelavo in pripravo podatkov, pridobljenih iz več različnih ERP sistemov, tako da so primerni za OLAP kocko. Problem takšnih podatkov iz več virov je v tem, da jih je potrebno obdelati in uvoziti v enotno podatkovno skladišče. Cilj diplomske naloge je bila izvedba OLAP kocke, ki je potrebna za analizo podatkov. Podatke iz različnih ERP sistemov smo predelali, očistili in nato uvozili v podatkovno skladišče. V različnih delih ETL procesa smo podatke obdelovali z različnimi metodami, dokler niso bili primerni za uvoz v podatkovno skladišče. Iz podatkovnega skladišča je bila nato narejena OLAP kocka. Podatki, pridobljeni iz OLAP kocke, so bili stestirani v vrtilni tabeli in primerjani z vhodnimi podatki pred obdelavo in pripravo za uvoz v podatkovno skladišče. Podatki iz OLAP kocke so bili nato primerni za nadaljne analize.
Keywords:OLAP kocka, ETL proces, podatkovno skladišče, priprava podatkov
Place of publishing:Maribor
Year of publishing:2016
PID:20.500.12556/DKUM-57997 New window
COBISS.SI-ID:7620883 New window
NUK URN:URN:SI:UM:DK:2CH2WWMD
Publication date in DKUM:28.06.2016
Views:3029
Downloads:400
Metadata:XML DC-XML DC-RDF
Categories:FOV
:
Copy citation
  
Average score:(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share



Hover the mouse pointer over a document title to show the abstract or click on the title to get all document metadata.

Secondary language

Language:English
Title:Processing and Preparation of OLAP data cube
Abstract:The thesis contains a display of processing and preparation of the data obtained from several different ERP systems so that they are suitable for the OLAP cube. The problem of such data from multiple sources is in that they must be processed and imported into a single data warehouse. The aim of the thesis was to create an OLAP cube that is suitable for BI data analysis. Data from various ERP systems was transformed, cleaned and then loaded into the data warehouse. In various parts of the ETL process data was transformed with different methods until they were eligible for import into the data warehouse. From this data warehouse an OLAP cube was made. Data obtained from OLAP cubes have been tested in the pivot table and compared with the input data prior to processing and preparation for import into the data warehouse. The data from the OLAP cube was then suitable for further analysis.
Keywords:OLAP Cube, ETL Process, Datawarehouse, Data Preparation


Comments

Leave comment

You must log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back
Logos of partners University of Maribor University of Ljubljana University of Primorska University of Nova Gorica