TITLE
A BALANCED SYSTEM OF PERFORMANCE INDICATORS AND DATABASE ANALYSIS
AUTHOR(S)
Gancho Lyubomirov Tanev1, Stanimir Mihaylov Sadinov1, Panagiotis Kogias2
ABSTRACT
This article presents the research and development of a system for managing the effectiveness of organizational processes through the application of the concept of a Balanced Scorecard (BSC). The main goal is to create an integrated software system that combines the principles of BSC with the functionalities of modern ERP and Business Intelligence (BI) solutions. The project offers a three-layer architecture based on data from Microsoft Dynamics NAV/LS Central, analyzed and visualized using the BI tool Tableau. The central place is occupied by the database, which provides storage, unification and processing of key performance indicators (KPI). An ana-lytical model is applied to it, which allows multidimensional analysis by various criteria - departments, periods,
employees and goals. By using structured database analysis, traceability of changes is ensured, the ability to predict and detect dependencies between different indicators. This allows management to make informed and justified decisions in real time. The developed concept is based on a systematic and analytical approach, includ-ing database modeling, defining relationships between key tables (Employees, Indicators, Results, Targets) and integration with ERP sources. The system provides a toolkit for automatic data extraction, processing and visu-
alization through a BI platform. The expected contribution of the project is related to improving management accountability, increasing the transparency of organizational processes and creating a methodology for data analysis applicable in various business environments. The developed system can be used as a basis for a disser-tation aimed at implementing an intelligent platform for performance management through database analysis and integration with ERP systems.
DOI
How to cite this article:
Gancho Lyubomirov Tanev1, Stanimir Mihaylov Sadinov1, Panagiotis Kogias2, A BALANCED SYSTEM OF PERFORMANCE INDICATORS AND DATABASE ANALYSIS, UNITECH – SELECTED PAPERS - 2025