Bicycle.LLCSchedule a call

← Dashboard collection

Choose dashboard — Compensation Cycle

people analytics dashboard

Compensation Cycle

Review-cycle planning, market position, distribution, spend, and equity measures.

10 pages · Power BI

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

Choose page — 2 Plan

Selected page

2 Plan

A rendered screenshot preview for this page is still pending. Showing Metrics meanwhile. Also available: Segmentation, DAX, Data model.

Metrics used on this page

  • Adj Spend

    CompPlanning · Additional Adjustment · $#,0

    USD additional-adjustment dollars; 0 when the Addl Adjustments toggle is Exclude.

  • Change vs Prior Year

    PlanBudget · Plan · $#,0;($#,0)

    Total Spend (All Types) − Prior Year Spend (Total).

  • Change vs Prior Year %

    PlanBudget · Plan · +0.0%;-0.0%

    Change vs Prior Year ÷ Prior Year Spend (Total).

  • Gross Over Plan

    PlanBudget · Review Gate · $#,0

    Sum of positive department plan variances (what departments overspent), before netting.

  • Gross Text

    PlanBudget · Report Views · General

    Offsetting-departments sentence with gross over/under and the assumed threshold.

  • Gross Under Plan

    PlanBudget · Review Gate · $#,0;($#,0)

    Sum of negative department plan variances (what departments underspent), before netting. Negative number.

  • Headcount

    CompPlanning · Headcount & Rating · #,0

    Employees in the filtered group (everyone in the cycle, whether or not they received an increase).

  • Merit Spend

    CompPlanning · Merit · $#,0

    Sum of USD merit increase amounts.

  • Plan Budget (Merit)

    PlanBudget · Plan · $#,0

    Finance merit budget for the department × population cells present in the filtered group.

  • Plan Budget (Other)

    PlanBudget · Plan · $#,0

    Finance additional-adjustment budget; 0 when adjustments are excluded.

  • Plan Budget (Promo)

    PlanBudget · Plan · $#,0

    Finance promotion budget for the cells present in the filtered group.

  • Plan Budget (Total)

    PlanBudget · Plan · $#,0

    Merit + Promo + Other budget (Other only when adjustments are included).

  • Plan Variance %

    PlanBudget · Plan · 0.0%;(0.0%)

    Plan Variance (Total) ÷ Plan Budget (Total).

  • Plan Variance (Total)

    PlanBudget · Plan · $#,0;($#,0)

    Total Spend (All Types) − Plan Budget (Total). Positive = over plan.

  • Prior Year Spend (Total)

    PlanBudget · Plan · $#,0

    Prior-year actual merit + promotion (+ other when adjustments are included) for the department × population cells in the filtered group.

  • Promo Spend

    CompPlanning · Promotion · $#,0

    Sum of USD promotion increase amounts.

  • Total Spend (All Types)

    CompPlanning · Total · $#,0

    Merit + Promotion + Adjustment spend (adjustment is 0 when excluded).

  • Variance Flag Color

    PlanBudget · Report Views · General

    Bar colour for plan variance: amber when the department is outside the review threshold, slate when inside (status = state, not magnitude).

  • Variance Tolerance

    PlanBudget · Review Gate · 0.0%

    Review threshold for department spend vs plan (parameter; ASSUMED ±3%, policy unconfirmed).