Business Intelligence HRIS Monitoring Dashboard to Increase User Interaction Using Power BI

Abstract

PT Samudra Dyan Praga is a company operating in the exhibition contracting industry with national and international reach, which has several branches throughout Indonesia. The implementation of exhibition events which often take place simultaneously, as well as the dynamic movement of the workforce, creates its own challenges in terms of reporting employee data. The process of updating data to reporting still relies heavily on separate spreadsheets, thus hampering data recapitulation, analysis and management decision-making processes related to human resources. The main goal of this research is to improve dashboard visualization to support decision making, Business Intelligence (BI) analysis, as well as ensure wider accessibility for users. We identify the latest trends and implement visualization dashboard practices in the BI domain. With a user-focused design approach, we provide improvements and solutions. Specifically, we addressed several challenges, such as creating dashboard controls that are easily accessible to novice users in visualization, improving annotation capabilities to support BI analysts in the analysis process, and adding storytelling functionality to dashboards to facilitate communication between analysts and decision makers. We specifically focused on new aspects of annotation, such as multi-target annotation, annotation transparency across charts, and the ability to share annotations between multiple data sources and BI applications. Through interviews with BI analytics experts and gathering requirements related to BI visual storytelling, we designed and implemented a storytelling tool prototype integrated in the dashboard analytics tool. This allows for a seamless transition from analysis to story creation and sharing.Our system was previously identified by experts as having great potential for training other analysts. Furthermore, it helps BI analysts compile and convey their findings more quickly to decision makers, as well as enabling them to reach a wider audience because the results of data analysis are presented in an easy-to-understand format without the need for special training.