Employee Monitoring System Using Power BI

Abstract

This paper introduces an HR attendance and task monitoring system, which has been developed utilizing Power BI. The system provides a comprehensive dashboard for HR personnel to visualize and track employee activity effectively. The dashboard includes key aspects such as Attendance Monitoring system works on real-time or historical attendance data can be showcased, letting HR to identifies trends, patterns, and potential attendance problems. Employee Skills & Roles this section presents a clear view of employee skillsets and assigned roles, helping in informed project allocation and resource management accurately. Project Assignments the dashboard keeps track of current project assignments for each employee, empowering HR to understand workload distribution and make adjustments when needed. By utilizing Power BI\'s data visualization and analysis abilities to the fullest extent, this system augments HR to gain crucial insights into employee activity. This assists in better decision-making in areas like attendance management, project allocation, and resource optimization, ultimately contributes to a more efficient and productive workforce.

Introduction

I. INTRODUCTION

Hr’s dashboard is an integrated approach to monitor employees helps for better decision making for organization goals. the power bi dashboard helps for quick analysis and decrease the time and man power to analyse the data. most of the organizations are lacking towards the keen look on manpower and work allocation. it may cause consequences like work allocation to inappropriate skill person. attendance monitoring in an organization plays a crucial role in order to proper utilization of resource. organizations are monitoring attendance in through spreadsheets, it requires various calculations and tools in order extract insights and analyse the data based on requirement. dashboard and report generating is most fascinating and simple way to solve the problem in order to achieve organization goals.

The power bi dashboard which has access to hr can monitor employee’s attendance, skillset, working project which can be used for further analysis. the dashboard visualizes the data in a simple understandable way and ease of access makes the hr to monitor and make decisions faster. the attendance monitoring helps to maintain a record of people, and visualizing the attendance in form of dashboard helps to understand the data easily through filters and gather required insights. the skillset dashboard helps to maintain a record of employees on basis of various aspects such as job role, skillset, experience level.

The visualization helps to give count of employees based on the criteria. the generated report can generate insights based on filters of various combinations of given criteria columns. the report gives the data of employee’s lying on the criteria and it helps to hr to allocate work based on employee’s skill, role etc. the project monitoring dashboard helps the hr to have clear information of employees working on project, present task they are doing, their role in project etc. the visualization of the project makes to get the insights in ease of access.

II. PROBLEM STATEMENT

The existing work consist of HR monitoring the attendance through spreadsheets, and time-consuming process. The existing system generated reports on average work delay, but didn’t focus on nature of work of an employee, the system generated reports available resources and distribution of resources but it lacked in how resources are distributed among projects and employees available for further upcoming projects. The existing system availability with lack of resources, such as valid equipment, automation tools, or materials. This information aids in ensuring with insufficient resources. The existing systems are unable to pool the supportive operational activities. Most of these models are working with low built automation models such as Allocation of Resources and Address Resource Allocation.

III. PROPOSED SYSTEM

In this work, the focus is on addressing the daily operational needs of an organization, particularly emphasizing the importance of regular monitoring of various aspects related to employee management. These aspects include attendance tracking, assessing employee skill sets, job designations, and monitoring the projects employees are currently working on. The proposed system aims to streamline these processes, providing HR personnel with the necessary tools to monitor employee activities effectively and take necessary actions as needed.

The proposed system architecture offers a centralized solution by designing a comprehensive dashboard that consolidates all relevant information and functionalities. By incorporating all essential features into a single dashboard, the system enhances efficiency and ease of use for HR personnel, eliminating the need to navigate through multiple systems or platforms for different tasks.

• First the HR home page dashboard is designed and navigation icons are used to navigate from one page to another.
• Attendance dashboard works on the aspects of organization’s overall attendance and employee’s individual attendance (i.e. work from home, work from office, sick leave).
• Skillset dashboard comprises of count and details of employees based on filters applied on dynamic need.

Project dashboard works with details of project and employees working with that project.

IV. PROPOSED SYSTEM

The Power BI dashboard is a visual tool makes a human understand and gain insights easily. In terms of designing dashboard, it is of three different parts with individual working model. The dashboard designed using interactive graphs and charts can help to monitor performance and other metrices. In addition of these the decision making in terms of productivity and achieve company goals.

Power BI Dashboards has following insights to present:

1. Attendance Monitoring: Give the HR a view of employee’s attendance that includes the working location of employee. Using matrix individual’s daily attendance can be represented. Charts and graphs help to analyse the attendance of an employee easily.
2. Skillset Monitoring: The HR who wants to know the count of employees based on skillset, job role, or work experience; the dashboard can present all the probable combination of above data.
3. Project Monitoring: The project monitoring dashboard makes an HR to know the work status and available employees for the new project. The employees involved in present project, their role in project and the present task an employee is working on, being visualising the above aspects can make HR to monitor and take necessary actions, allocate resources to employee.

Conclusion

The above model is built using Power BI dashboard, enhances the user with ease of understanding, and works primary purposes of an HR monitoring the employee for attendance, skillset. It further helps to get a spreadsheet report based on applied dynamic filtering. The above dashboards keep HR to allocate work to appropriate person and align the person to accomplish the task on time. The future scope of the paper is furnishing to accomplish above task on real time data furtherly making data to be updated time basis. Develop an hourly attendance tracker within the dashboard for real-time monitoring of employee presence. Using the real-time data the model is built using skill, job role, experience to create automated recommendation system for task allocation based using AI and Cloud servers. Enable managers to update project assignments and task statuses within the platform for real-time project tracking. Even the working location of the employee to be notified to the dashboard of HR. Adding extended security to features to the Dashboard to protect the Report generated from insights data.

References

[1] \"Utilizing Power BI for HR Analytics: A Case Study Approach\" by Soumyadeb Chowdhury and Sandipan Basu. This article discusses the application of Power BI in HR analytics, including attendance monitoring, skillset analysis, and project allocation. https://www.researchgate.net/publication/348196192_Utilizing_Power_BI_for_HR_Analytics_A_Case_Study_Approach. [2] \"Power BI for Human Resources: Leveraging Data Analytics for Improved Workforce Management\" by Kenneth G. Proctor. This article explores the use of Power BI specifically for HR purposes, including attendance tracking, skills assessment, and project management. (Link: [SAGE Journals] (https://journals.sagepub.com/doi/abs/10.1177/1046878120976604)) [3] \"Enhancing HR Decision Making with Power BI: A Practical Guide\" by Sven Aelterman and Koen Verbruggen. This article provides practical insights into using Power BI to improve HR decision-making processes, covering topics such as attendance analysis, skills visualization, and workload management. (Link: [SpringerLink](https://link.springer.com/chapter/10.1007/978-3-030-78193-4_7)) [4] \"Power BI for HR Reporting and Analysis: Best Practices and Case Studies\" by David G. Jarvis. This article offers best practices and real-world case studies demonstrating how Power BI can be effectively used for HR reporting, including attendance monitoring, skills profiling, and project tracking. (Link: [Wiley Online Library] (https://onlinelibrary.wiley.com/doi/abs/ 10.1002/9781119671599.ch4)) [5] \"Harnessing the Power of Power BI for HR Analytics\" by Rajesh Kumar Gupta. This article provides an overview of Power BI\'s capabilities in HR analytics, with a focus on attendance tracking, skill mapping, and project management dashboards. (Link: [International Journal of Management and Humanities] (https://www.ijmhss.com/wp-content/uploads/2019/08/2.-IJMHSS-JULY19-95.pdf)) [6] “HR Analytics with Power BI: Turning Data into Actionable Decisions” https://learn.microsoft.com/en-us/power-bi/create-reports/sample-human-resources. This article explores how Power BI can be used for HR analytics, including attendance tracking. It outlines examples of calculating attendance percentages, sick leave, and work-from-home days, which can be incorporated into your Power BI dashboard. [7] Power Bi Time Tracking Integration https://www.monitask.com/en/integration/power-bi-time-tracking [8] Microsoft offers various resources and documentation on Power BI for Beginners: https://www.microsoft.com/en-us/power-platform/products/power-bi [9] Explore the Power BI Community for discussions and examples related to HR dashboards: https://powerusers.microsoft.com/ [10] “Human Resource Analytics using Power Bi Visualization Tool” by Nills Nasmusen [11] “Predictive Modelling on employability of applicants and job-hopping using machine learning” by Oleh Sholeh. [12] “Control the Employee\'s Attendance Performance Using Dashboard for Improve Professionalism at PT. Sinarmas Land Property” by Mohammed Ameer

Copyright

Copyright © 2024 Dr. B. S. Panda, Ch Srikanth, PVU Krishna Bharadwaj, K Yamini Chandra, B Bhanu Prasad , S Jagan. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.