2nd Indian International Conference on Industrial Engineering and Operations Management

Corporate E-Training Tracking Mechanism Using a Combined Application of Power Query and Power Automate

Vinayak Karkale, P Pantawane & Ankita Mishra
Publisher: IEOM Society International
0 Paper Citations
1 Views
1 Downloads
Track: Operations Management
Abstract

Abstract

Corporate training is essential for employee upskilling and reskilling. Companies invest huge amounts in the development of training pathways. It has a direct impact on employee productivity and efficiency. Many organizations have a set of mandatory compliance-related training for new employees to avoid compliance issues. Tracking this training status is a tedious task. The Human Resource Learning & Development team makes available many courses for employee upskilling and reskilling but whether the employees are using these training for their upskilling is a challenging task to track. Organizations also like to know many insights like - How much progress the employee has made on assigned training? What portion of total employees have completed the particular section of assigned training? Etc. In this situation, soft automation using modern Microsoft tools, mainly Power Query and Power Automate are useful tools that simplify the problem. In this paper, it is demonstrated that the use of automation techniques using these tools can help to track corporate training and improve the training completion rate of the employees thereby creating good opportunities for their growth. This automaton will also save an enormous amount of time as compared to manual tracking. This research paper is applicable to all sectors since training is part of all corporate learning programs. Corporate companies can leverage this automated training tracking mechanism to upskill their employees.

Published in: 2nd Indian International Conference on Industrial Engineering and Operations Management, Warangal, India

Publisher: IEOM Society International
Date of Conference: August 16-18, 2022

ISBN: 978-1-7923-9160-6
ISSN/E-ISSN: 2169-8767