Hub
Pricing About
WorkflowWorkflow

Employee Turnover KPI Monthly

KPIKNIME for FinanceEmployee Turnover
knime profile image
Versionv2.0Latest, created on 
Jan 22, 2025 3:31 PM
Drag & drop
Like
Download workflow
Workflow preview
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.
- Visualized employee turnover KPI over months and N° of terminations by office location

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.

Read more on the topic Employee Turnover on the KNIME Blog: https://www.knime.com/blog/how-to-calculate-employee-turnover-kpi

External resources

  • KNIME Blog: Employee Turnover KPI
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.4.0
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.3.0, 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Excel SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    knime profile image
    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME SVG SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    knime profile image
    knime
  • Go to item
    KNIME ViewsTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.3.0, 5.4.0

    knime profile image
    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits