Building data marts to analyze university faculty activities using power BI

Abstract

Evaluating the performance of university faculty is a hard task because of the diversity of the work performed. The authors assume that the founder of the university evaluates the effectiveness of the university according to performing the teaching staff. The aim of the study is to improve the monitoring of key performance indicators of the university teaching staff based on data management. The authors present an information system to support decision-making related to the teaching staff at Kemerovo State University. The authors of the paper describe creating such a system using Business Intelligence technologies step by step. The authors identified data sources, designed the structure of the data mart and built ETL-processes for its filling, implemented various analytical dashboards. Implementing the information system in the daily activities of the university allows responding promptly to changes in the key indicators, forecasting their further change, deciding on activation of efforts in the chosen direction or types of work.