Izdelava nadzorne plošče za spremljanje kazalnikov trajnostne poslovne strategije podjetja

KACIN VODIČAR, DOMEN (author), Mušič, Gašper (mentor)

V tej diplomski nalogi sta predstavljena razvoj in implementacija nadzorne plošče za spremljanje kazalnikov trajnostne poslovne strategije podjetja, narejene na realnem primeru podjetja s približno sto zaposlenimi in deloma interno razvito tehnološko infrastrukturo. Nadzorna plošča je bila izdelana za reprezentativno skupino kazalnikov s fokusom na vertikalnem razvoju povezovanja podatkovnih baz, oblikovanja podatkov, izdelave grafičnega vmesnika in dodajanja funkcionalnosti. Grafični vmesnik je bil izdelan na platformi Microsoft Power BI, za poizvedbe in obdelavo podatkov pa sta bila uporabljena programska jezika PowerQuery M in DAX. Dokumentirana je tehnična izvedba projekta, po njej pa so podana moja priporočila za nadaljnji razvoj projekta in bolj splošna priporočila za večje posege v uporabo podatkov za interno podporo poslovnim odločitvam. Ugotavljam, da bolj kot uporabljena orodja na izvedljivost takšnega projekta vplivata kvaliteta in oblika vhodnih podatkov, ki mora biti zasnovana z mislijo na njihovo končno uporabo.

• Language: Slovenian
• Keywords: trajnostna poslovna strategija, spremljanje kazalnikov, nadzorna plošča, Power BI, mySQL, PowerQuery M, DAX
• Work type: Bachelor thesis/paper
• Typology: 2.11 - Undergraduate Thesis
• Organization: FE - Faculty of Electrical Engineering
• Year: 2024
• PID: 20.500.12556/RUL-155318
• COBISS.SI-ID: 190930947
• Publication date in RUL: 26.03.2024

KACIN  VODIČAR, DOMEN, 2024, Izdelava nadzorne plošče za spremljanje kazalnikov trajnostne poslovne strategije podjetja [online]. Bachelor’s thesis. [Accessed 11 April 2025]. Retrieved from: https://repozitorij.uni-lj.si/IzpisGradiva.php?lang=eng&id=155318

Secondary language

• Language: English
• Title: Dashboard development for monitoring sustainable business strategy indicators in a company

Abstract

This work presents the development and implementation of a control panel for the tracking of indicators of a company’s sustainable business strategy, built in the real environment with a company of about one hundred employees and partly internally developed technological infrastructure. The control panel was created for a representative group of indicators with a focus on vertical development of database connections, data processing, graphical interface construction and implementation of additional functionalities. The graphical interface was built using Microsoft Power BI, where the PowerQuery M and DAX were used for querying and data processing. The technical implementation of the project is documented, after which I give my recommendations for further development and generally making large changes to the use of existing data for the internal support of business decisions. I find that the impact of tools themselves on the viability of such a project is lesser than the quality and shape of input data, which should be designed with their intended end use in mind.

• Keywords: sustainable business strategy, indicator tracking, control panel, Power BI, mySQL, PowerQuery M, DAX