This workflow calculates the Employee Turnover KPI, according to the following steps:
- Read data from the HR system.
- Extract <Part of Date>, Year, Quarter, and Month
- Calculate and visualize the KPI within a Data App.
The Data App:
- Select the year of interest.
- Count all employees who joined and left in the selected year.
- Compute the monthly average number of employees.
- Compute the employee turnover KPI for every month.
- Prepare the visualization.
- Add two nodes one before (“Report Template Creator”) and one after (“Report PDF Writer”) the “Dashboard” component, which contains the "Line Plot", the "Pie Chart" and two nodes to enhance the visualization: "Text view" and "Image view".
Here HR system data come from an Excel file, but could be imported in another way. It is enough to change the Excel Reader node into the appropriate node for the data source.
The difference with the workflow "Employee KPI Monthly" consists of the addition of Reporting nodes.
Read more on the topic Employee Turnover on the KNIME Blog: https://www.knime.com/blog/how-to-calculate-employee-turnover-kpi
- Read data from the HR system.
- Extract <Part of Date>, Year, Quarter, and Month
- Calculate and visualize the KPI within a Data App.
The Data App:
- Select the year of interest.
- Count all employees who joined and left in the selected year.
- Compute the monthly average number of employees.
- Compute the employee turnover KPI for every month.
- Prepare the visualization.
- Add two nodes one before (“Report Template Creator”) and one after (“Report PDF Writer”) the “Dashboard” component, which contains the "Line Plot", the "Pie Chart" and two nodes to enhance the visualization: "Text view" and "Image view".
Here HR system data come from an Excel file, but could be imported in another way. It is enough to change the Excel Reader node into the appropriate node for the data source.
The difference with the workflow "Employee KPI Monthly" consists of the addition of Reporting nodes.
Read more on the topic Employee Turnover on the KNIME Blog: https://www.knime.com/blog/how-to-calculate-employee-turnover-kpi
