Data management and dashboard visualization for talent management at KVC Industrial Supplies Sdn Bhd

This technical report details an analytical and data management study conducted at the Talent Management Department of KVC Industrial Supplies Sdn Bhd. The study aims to improve the efficiency of human resource processes by streamlining data handling for staff leave reports, employee system updates, and overtime claim calculations. To achieve this, raw organizational data underwent extensive cleaning processes, which included filtering, removing redundant columns, and standardizing variables. Interactive dashboards were subsequently developed using Microsoft Excel and Microsoft Power BI to visualize staff leave performance and medical leave trends. Furthermore, Excel-based logical formulas, specifically the MATCH function, were utilized to cross-reference and update large datasets of active employee names across multiple corporate systems (HealthMetrics and Ramco). The analysis demonstrates that applying proper data cleaning techniques and automated formula matching significantly reduces manual workload and minimizes human error in claim calculations. Overall, the integration of data visualization tools empowers the management to execute data-driven decisions, such as introducing attendance-based reward systems, thereby optimizing talent management operations.