<aside> 💡
A full people analytics project built from scratch | Jan 2023 – Mar 2025 1,000 applicants · 10 departments · 6 source channels · 30 hiring managers · 37 columns Tools: Google Sheets · Gemini · Airtable · Looker Studio · Observable · Notion · Obsidian · GitHub · Medium · LinkedIn Status: ✅ Complete
</aside>
Tracks every task across all five phases of the project. Filter by Phase to see what was built at each stage. Filter by Status to see what is complete, in progress, or blocked. Switch to Board view to see tasks as a Kanban pipeline.
Tracks the key metrics this project surfaces against industry benchmarks. Red status means the metric is significantly off target and needs attention. Amber means within range but worth monitoring. Green means on track or exceeding target. All current values are drawn from the 1,000 applicant mock dataset.
All tools are live, connected, and publicly accessible. Everything below is interactive — not static screenshots.
Seven pages covering funnel conversion, channel ROI, time to hire, SLA compliance by stage, hiring manager accountability, and time to fill analysis. Use department and source channel filters to drill into any team.
https://datastudio.google.com/embed/reporting/7e1570b5-a045-428e-9aa9-a97edfcbcef5/page/rtqzF
Eleven custom charts built in JavaScript. Sankey candidate flow diagram, hiring manager SLA heatmap, source ROI bubble chart, rejection treemap, SLA compliance bar chart, offer decline analysis, and TTF vs TTH comparison. Hover any element for exact values.
Recruitment pipeline in kanban view. Each column is a funnel stage. Each card is a candidate. Linked tables connect applicants to hiring managers and departments. Switch between Grid, Kanban, and Interface views using the tabs at the top of the embed.