20.500.12556/DKUM-46106 PODATKOVNO SKLADIŠČE ZA PODPORO LOGISTIČNEMU PROCESU DATA WAREHOUSE SUPPORT FOR LOGISTIC PROCESSES Predstavili smo pojem logistike in oskrbovalne verige in nato smiselno razložili, kakšen vpliv imata na logistiko poslovna inteligenca in podatkovno skladiščenje. Podrobneje je opisan pojem kakovosti podatkov, arhitekture podatkovnih skladišč ter postopek modeliranja dimenzij in tabel dejstev. Na praktičnem primeru prikažemo postopek načrtovanja in izgradnje podatkovnega skladišča za podporo logističnemu procesu. Podrobno opišemo vse faze ETL procesa za vsako dimenzijo in kreiramo OLAP kocko, ki služi kot osnova za izvajanje analiz. Odgovorimo na pet postavljenih vprašanj, predstavimo ugotovitve ter podamo mnenje o dogajanju, spremembah in morebitnih ukrepih. We have introduced the concept of logistics and supply chain management and then logically explained what influence, business intelligence and data warehousing has, on the mentioned concepts. We have thoroughly described the concept of data quality, data warehouse architectures and process of dimensional modeling. We have planned and designed a practical case of data warehouse, upon which we have described the process of planning and building a data warehouse for support of logistics processes. We have thoroughly described all phases of the ETL process implementation, for each of the dimensions. We designed and built an OLAP cube that serves as a base for carrying out analysis. We answer on five questions, introduce our findings and give our opinion on the given events, changes and possible measures. poslovna inteligenca logistični proces podatkovno skladišče dimenzijsko modeliranje ETL OLAP SSIS business intelligence logistics process data warehouse dimensonal modeling ETL OLAP SSIS true true false [M. Berišaj] Slovenski jezik Angleški jezik Diplomsko delo/naloga 2014-09-12 11:15:46 2014-12-16 15:04:42 2022-05-17 03:10:21 2021-05-04 03:30:15 2014 0 Maribor 0 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 004.651:355.41(043.2) 18465046 URN:SI:UM:DK:CA5PUXHC VS_Berisaj_Mitja_2014.pdf VS_Berisaj_Mitja_2014.pdf 1 0E937AA976C2AB9538CB23C23A76441F 1652559755ba0fd82ebbd52fe531c8c9ff8d4abab18721f9e304a0d405731eb1 392570de-7c0b-11eb-bb7a-00155d0001ca https://dk.um.si/Dokument.php?lang=slv&id=67171 Fakulteta za elektrotehniko, računalništvo in informatiko 0 0 0