top of page
Employee Rotation Dashboard
The Client 🤵
One of India's leading financial institutions, with a vast network of branches nationwide. Each branch had to adhere to statutory requirements from the Reserve Bank of India to periodically rotate employees across locations and roles.
The Problem ⛔
-
The client faced major difficulties in planning employee movements across the organizational hierarchy as per the RBI guidelines.
-
The process of mapping employee data with RBI guidelines data was tedious and time-consuming, often leading to errors and inconsistencies. This resulted in unintended personnel transfers or delays in employee rotations.
-
All analyses were ad-hoc. The client lacked a centralized dashboard to track employee tenures, identify those due for rotation, and plan for future employee rotations.
Our Solution ✔️
We built a model to gather, clean and automate employee information coming in from the internal employee database and the RBI Guidelines data.
We developed an interactive Power BI dashboard with the following key metrics:
Key KPIs
-
Employees eligible for rotation, employees rotated, and due as-on-date.
-
Employees who would be due for rotation in the near future.
-
Employee analysis that visualized the distribution of employees across various roles, locations, and segments.
-
Previous location history and stint of each employee.
Our Impact 🚀
-
Adhering to the RBI statutory requirements became a breeze and the client could now perform on-demand planning and analysis of employee movements.
-
Our solution combined different employee movement data into one dashboard, reducing 50 man hours a month to an on-demand one-click refresh.
-
Now, with effective KPIs like tenure, role changes, and due dates in place, the client could adequately pre-plan employee movements.
Timeline ⏳
Project Discussion
Project
Scope
Automation
&Testing
KPI
Calculation
Visualization
Handover &
Manual Training
Day 2
Day 1
Day 7
Day 12
Day 14
Day 16
bottom of page