Bicycle.LLCSchedule a call

← Dashboard collection

Choose dashboard — Retention and Composition

people analytics dashboard

Retention and Composition

Retention, tenure, turnover cost, representation, and screening views.

8 pages · Power BI

These dashboards use synthetic workforce data. Values illustrate the report design.

Choose page — 1 Retention summary

Selected page

1 Retention summary

Metrics used on this page

  • Active Headcount

    RetEmployee · Headcount & Flow · #,0

    Employees active at the as-of date.

  • Attrition Rate

    RetEmployee · Headcount & Flow · 0.0%

    Exits (TTM) ÷ Average Headcount.

  • Average Headcount

    RetEmployee · Headcount & Flow · #,0.0

    (Start Headcount + Active Headcount) ÷ 2 — the single governed denominator for attrition.

  • Exits (TTM)

    RetEmployee · Headcount & Flow · #,0

    Terminations in the trailing 12 months.

  • Expected Loss (USD)

    RetEmployee · Retention Risk · $#,0

    ILLUSTRATIVE (assumed replacement multiples). Sum over active employees of predicted exit probability × replacement cost.

  • High-Risk, High-Impact

    RetEmployee · Retention Risk · #,0

    High risk and high impact of loss (pivotal role or rated 4–5): the retention conversation list.

  • Regretted Attrition Rate

    RetEmployee · Headcount & Flow · 0.0%

    Regretted Exits ÷ Average Headcount.

  • Regretted Exits

    RetEmployee · Headcount & Flow · #,0

    Voluntary exits of high-impact people (pivotal role or rated 4–5). The rule is an ASSUMPTION; regretted = voluntary and high impact.

  • Replacement Cost (Exits)

    RetEmployee · Turnover Cost · $#,0

    Sum over exits of base salary × replacement multiple (0.5 / 0.75 / 1.5 by level group; assumption parameters).

  • Retention Status Text

    RetEmployee · Report Views · General

    One sentence: attrition arithmetic, regretted exits, replacement cost and the high-risk high-impact list.

  • Start Headcount

    RetEmployee · Headcount & Flow · #,0

    Employees on the books one year before the as-of date (hired by then and not already gone).

  • Survival Text

    Parameters · Report Views · General

    Share of people still employed at 12, 24 and 60 months of tenure (all employees, Kaplan-Meier with delayed entry; offline).

  • Voluntary Attrition Rate

    RetEmployee · Headcount & Flow · 0.0%

    Voluntary Exits ÷ Average Headcount.

  • Voluntary Exits

    RetEmployee · Headcount & Flow · #,0

    Voluntary terminations in the trailing 12 months.