Preview. This page currently shows the analysis skeleton. The full worked walkthrough — sample dataset, connected steps, runnable code, interpretation — is being built.

HR / People Analytics · how-to

Predict Employee Churn from Organizational Network — in SQL

A network-driver analysis. Every step below is the same analysis rendered for SQL — grounded in the source, honest where SQL can't do a step cleanly.

Same analysis, your tool

DERIVE

convert the network into quantitative signals per person

expr AS derived

JOIN · mechanical

link network position to who stayed or left

LEFT JOIN other ON a.key = b.key

CORRELATE

identify which network signals predict staying

corr(driver_j, outcome)

FIT-CLASSIFIER

model resignation odds from connectedness and context

SQL can’t do this cleanly

FIT-CLASSIFIER has no clean sql form —

PREDICT

flag well-connected people worth retaining

SQL can’t do this cleanly

PREDICT has no clean sql form —

Honest note: SQL can’t do 2 of these steps cleanly — the switcher shows which tools can.

Grounded in

Predictive HR Analytics with Excel — §17.8/17.9 ONA graph metrics & churn

Doing HR / People Analytics work?

The full HR / People Analytics guide covers this and the whole workflow around it — reconciled from the field’s best books.

Want to run it, not read it?

Run this analysis live on your data, in SQL or any tool — powered by the Stepcode engine.