20.500.12556/DKUM-12134 OLAP ANALIZA V ŠOLSKEM INFORMACIJSKEM SISTEMU OLAP ANALYSIS IN THE SCHOOL INFORMATION SYSTEM Vsak dan se srečujemo z ogromno količino podatkov. Samo shranjevanje podatkov pa za uporabnike ne predstavlja nobene dodane vrednosti. Te podatke je potrebno analizirati in spraviti v smiselna poročila. Tematika diplomske naloge je uvajanje OLAP tehnologije v šolski informacijski sistem. Ravno ta tehnologija pa nam omogoča analizirati podatke in iz njih pridobiti dodatno vrednost. S tem bomo predstavili sam postopek modeliranja podatkovnega skladišča in postavitev tega na strežniku. Na primerih bomo predstavili ETL procese in težave, ki nastanejo pri teh transformacijah. Predstavili bomo tudi gradnjo OLAP kocke in njeno uporabo v MS Excelu. Cilj diplomske naloge je na resničnem projektu predstaviti proces uvajanja OLAP-a. We face a huge amount of data every day. Only storing that data does not create any added value for the users. It is necessary to analyze this data and convert it into meaningful reports. The theme of this diploma work is the introduction of OLAP technology in to a schools information system. This technology enables us to analyze the data and gain additional value from it. Using this procedure we will demonstrate the process of data warehouse modeling and the installation of said warehouse on a server. We will use examples to show ETL processes and problems that may arise with these transformations. We will also show the construction of a OLAP cube and its use with MS Excel. Our goal with this diploma work is to demonstrate the process of OLAP introduction on a real project. OLAP dimenzijsko modeliranje ETL podatkovno skladišče izkopavanje podatkov OLAP Dimensional modeling ETL data warehouse data mining true true false [Ž. Jelen] Slovenski jezik Angleški jezik Diplomsko delo 2009-10-07 22:15:08 2009-10-14 09:21:34 2022-04-12 07:14:43 2022-04-19 03:13:12 2009 0 Maribor 0 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 004.62/.65:37(043.2) 13713174 URN:SI:UM:DK:SXQU8UR2 VS_Jelen_Ziga_2009.pdf VS_Jelen_Ziga_2009.pdf 1 B34A6F9304547BEFBCBA6C07C12AA268 557577f54a524f7270a4ceb013517b79aaf6ba1ee96c14c083ed0e61da5f9050 52eadc72-7c03-11eb-bb7a-00155d0001ca 20.500.12556/dkum/c2f5f034-1e4a-477a-a678-37a2b55b3e71 https://dk.um.si/Dokument.php?lang=slv&id=11298 Fakulteta za elektrotehniko, računalništvo in informatiko 0 0 0