AI-based university KPI system: React.js, ASP.NET Core, and PostgreSQL architecture
##semicolon##
https://doi.org/10.56143/3030-3893-2026-1-134-136##semicolon##
system architecture, ETL, Isolation Forest, React, ASP.NET Core, PostgreSQL, explainable AIAbstrak
This article presents a layered architecture for a system designed to collect, analyze, and generate recommendations based on university employees’ Key Performance Indicators (KPIs). The technology stack includes React.js, ASP.NET Core 8, PostgreSQL 16, and a Python-based AI service. The ETL process operates on a star-schema data model under the condition Q_period ≥ 0.90. Anomaly detection is performed using Isolation Forest combined with forecasting residuals (AUC = 0.94), while recommendations are constrained by a weighted gap-based rule. The prototype achieved a p95 response time of 0.42 s and a System Usability Scale (SUS) score of 78, while reducing report preparation time from 36 hours to 9 hours. A human-in-the-loop approach is maintained: the AI system provides recommendations but does not issue commands.
##submission.citations##
[1]
Liu F.T., Ting K.M., Zhou Z.-H. Isolation Forest. ICDM, 2008. https://doi.org/10.1109/ICDM.2008.17
[2]
Hevner A. et al. MIS Quarterly, 2004.
[3]
Kimball R., Ross M. The Data Warehouse Toolkit. 2013.
[4]
PostgreSQL 16 docs. https://www.postgresql.org/docs/16/
[5]
https://learn.microsoft.com/aspnet/core
[6]
[7]
Brooke J. SUS. 1996. 8. Fielding R. REST. 2000. https://www.ics.uci.edu/~fielding/pubs/dissertation/top.htm
