Analiza SQL skript v power BI

DEDIĆ, LUKA (author), Rupnik, Rok (mentor)

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.

• Language: Slovenian
• Keywords: Power BI, SQL skripta, Microsoft Dynamics, AX, NAV, Podatkovno skladišče
• Work type: Bachelor thesis/paper
• Typology: 2.11 - Undergraduate Thesis
• Organization: FRI - Faculty of Computer and Information Science
• Year: 2023
• PID: 20.500.12556/RUL-145202
• COBISS.SI-ID: 149905923
• Publication date in RUL: 13.04.2023

Secondary language

• Language: English
• Title: SQL script analysis in Power BI

Abstract

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.

• Keywords: Power BI, SQL Script, Microsoft Dynamics, AX, NAV, Data Warehouse