20.500.12556/RUL-145202 Analiza SQL skript v power BI SQL script analysis in Power BI Rezultat diplomske naloge bo uporabljen za pregled in optimizacijo sql skript, ki delajo z velikimi podatki, posebaj bo namenjena podjetjem, ki se ukvarjajo s poslovno inteligenco bolj natančno razširitvijo fukncionalnosti Microsoftovih programov Microsoft Dynamics AX in NAV. V okviru procesa pride do obdelave podatkov in procesiranja le teh na na treh glavnih področjih Stage, Datawarehouse in pa analitika. Za procesiranje se uporabljajo sql skripte. Moja naloga bo beležiti čas izvajanja in število vnosov na določen čas za vsako od teh skript. Te podatke bom pripeljal v Power BI, kjer jih bom prikazal po kategorijah. Potrebno bo dobro razumevanje platforme Dynamics in pa potreb podjetja za optimalno poročilo kar se tiče uporabljenih tabel in pa optimalne vizualizacije po kategorijah. Naloga bo znatno pripomogla pri hitrem pregledu zgodovine izvajanja teh skript, saj se bo s tem lažje ugotovilo ali kakšna skripta ne deluje pravilno oziroma ali potrebuje kakšno optimizacijo, prav tako pa se bo dalo videti kje je procesiranje padlo oziroma katere tabele se niso sprocesirale. The result of the thesis will be used to review and optimize SQL scripts that work with big data, especially for companies that deal with business intelligence, more precisely expanding the functionality of Microsoft’s Microsoft Dynamics AX and NAV programs. As part of the process, data is processed and processed only in three main areas: Stage, Datawarehouse and analytics. SQL scripts are used for processing. My job will be to record the execution time and number of entries per time for each of these scripts. I will bring this data into Power BI, where I will display it by category. It will be necessary to have a good understanding of the Dynamics platform and the company’s needs for an optimal report in terms of the tables used and optimal visualization by category. The task will significantly help with a quick review of the execution history of these scripts, as this will make it easier to determine whether a script is not working correctly or whether it needs some optimization, and it will also be possible to see where the processing failed or which tables were not processed. Power BI SQL skripta Microsoft Dynamics AX NAV Podatkovno skladišče Power BI SQL Script Microsoft Dynamics AX NAV Data Warehouse true false false Slovenski jezik Angleški jezik Diplomsko delo/naloga 2023-04-13 11:25:00 2023-04-13 11:25:04 2023-04-21 05:22:35 0000-00-00 00:00:00 2023 0 0 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 35020 149905923 Dedic_Luka_-_Analiza_SQL_skript_v_power_BI.pdf Dedic_Luka_-_Analiza_SQL_skript_v_power_BI.pdf 1 547923DE9E16DE01994833F2A4D96A36 048bed9f113541cd8244a683de090934822dd3cc4bf6575fe5130d658ca38226 ed45ccdf-d9dc-11ed-a314-00155dcfd717 https://repozitorij.uni-lj.si/Dokument.php?lang=slv&id=167917 Fakulteta za računalništvo in informatiko 0 0 0