20.500.12556/DKUM-58199 UPORABA OLAP PRIPOMOČKOV PRI ODLOČANJU NA PRIMERU VEČJE BANKE USAGE OF OLAP TOOLS FOR DECISION MAKING ON THE CASE OF A LARGER BANK Odločanje je temelj poslovnega vsakdana in v veliki meri vpliva na uspešnost poslovnih sistemov. V diplomskem delu pojasnjujemo vedno bolj pomembno vlogo informacijske tehnologije in poslovnega obveščanja v procesu odločanja. V organizacijah s slabše razvitimi informacijskimi sistemi je analiziranje podatkov oteženo in časovno zamudno. Analize prihajajo v roke končnega prejemnika običajno prepozno in zaradi tega služijo le preverjanju poslovnih odločitev, ne pa pomoči pri samem odločanju. Učinkovit sistem poslovnega obveščanja si lahko zagotovimo z izgradnjo podatkovnih skladišč, vpeljanimi ETL procesi za čiščenje in integracijo podatkov ter z uporabo OLAP tehnologije. To so osnovni gradniki poslovnega obveščanja. Takšen sistem nam omogoča predstavitev podatkov na jasen in pregleden način, kar nas posledično pripelje do koristnih informacij, ki so podlaga za odločanje. OLAP rešitev je primerna za analize in raziskovanje velike količine podatkov, njihovih medsebojnih povezav in pregled le-teh z različnih vidikov. V zadnjem delu diplomske naloge uporabnost OLAP pripomočkov prikažemo na primeru bančnega kontrolinga. Decision-making is a cornerstone of everyday business, and successful performance by a company is based considerably on smart and prudent decisions. This diploma thesis explains the increasingly important role of information technology and business intelligence in the decision-making process. In enterprises with poorly developed information systems, data analysis is difficult and time-consuming. Analysis and reports are usually delivered to their final recipient too late and therefore serve only for checking business decisions, rather than supporting the decision-making itself. Effective business intelligence can be provided with the implementation of data warehouses, ETL processes for data transformation and integration, and by using OLAP technology. These are the basic building blocks of business intelligence. Such a system allows the presentation of data in a clear and transparent manner, which consequently leads us to useful information for decision-making. The OLAP solution is suitable for analysis and exploration of large amounts of data, their interaction, and reviews from various aspects. In the last part of the thesis, the applicability of OLAP tools is shown in the case of a larger bank in a controlling department. poslovno obveščanje ETL podatkovno skladišče OLAP business intelligence ETL data warehouse OLAP true true false [B. Žibert] Slovenski jezik Angleški jezik Diplomsko delo 2016-04-09 14:36:05 2016-06-28 12:51:22 2022-06-16 03:07:15 2019-07-11 10:31:34 2016 0 Maribor 0 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 004.8 12363292 URN:SI:UM:DK:CSOKLH3F VS_Zibert_Binela_2016.pdf VS_Zibert_Binela_2016.pdf 1 CA645AF6602301E0A26F43F71A60AA5A fc8faef8c33b42091c21619b0f2fa6fe92446ebc6ed73349581f1125528359c3 22d3f1e5-7c0c-11eb-bb7a-00155d0001ca https://dk.um.si/Dokument.php?lang=slv&id=90512 Ekonomsko-poslovna fakulteta 0 0 0