The Workforce Board — Hope, Health, and Healing starts with the people who deliver it.

1Workforce at a glance

Period-end values; deltas compare with the same-length prior period. Turnover is annualized.

2Headcount and annualized turnover by month

Bars: period-end headcount. Line: trailing-12-month separations ÷ average headcount.

HeadcountAnnualized turnoverTurnover target 30%

4Where the workforce is — North Carolina footprint

Circles are sized by headcount in the selected scope; colour is annualized turnover. Dots mark community-based staff outside the three offices.

Turnover under 30%30–40%Over 40%Legacy campus (Barium Springs 1891 · Grandfather Home 1914)

5Turnover by program and office

Annualized, ranked highest to lowest. Bars in clay exceed the 30% target.

6The Hope Tree — tenure and retention

Each ring is a tenure band; the canopy shows how much of today's team has stayed past each milestone.

7Open positions and time-to-fill

Requisitions open at period end; median days from posting to accepted offer for hires in the period.

8Overtime hours per FTE

Monthly OT hours per full-time equivalent, by program.

9Training and compliance completion

Share of staff current on each required course at period end.

10Ask the data

Natural-language questions over the same model, answered with the numbers on this board.

11Sensitive fields excluded at the source

The Paylocity → Azure SQL load pulls only the columns the board needs. Struck-through fields never leave payroll.

Social Security number

Date of birth / age

Race, ethnicity, gender

Home address, bank, dependents

Medical, leave reason, disability

Individual pay rate (aggregated only)

Employee ID (hashed), program, cost center

Hire / term dates, status, FTE, hours, training

12How the numbers get here — nightly, with no manual export

The architecture Kourtney and Kevin sketched in early 2025, built as a low-code, least-maintenance pipeline.

Source

Paylocity API

Employees, positions, time & labor, learning. Column allow-list enforced here.

Load

Power Automate

Scheduled flow, 02:00 ET. Incremental by modified date; retries and failure alerts to HR.

Store

Azure SQL

Star schema: employee, position, program, location, calendar. 36 months of history.

Serve

Power BI

This board, row-level security by office, board-ready export each quarter.