Back to Gallery
ExcelCapstone Project
Corporate HR Attrition & Salary Benchmarking Tracker
SQ
BUILT BYSadia Qureshi
BEFOREHR Coordinator
→
OUTCOMEHR Operations Analyst at Systems Ltd
Status: Live DeployedInteractive Live Demo (Sandbox)→
Project Overview
A fully interactive, VBA-free Excel dashboard displaying staff turnover ratios, department tenure, and salary gaps.
Data Scrubbing & Cleaning Pipeline
The student imported raw messy CSV database backups, scrubbed redundant column entries, normalized data structures, handled duplicate records, and configured relationship models using SQL schemas and Power BI.
Analytical Insights Generated
Configured cohort retention models, isolated regional operational leakages, tracked active customer churn risk, and mapped average revenue metrics across locations.
Project Specs
CORE TOOLExcel
DATA ROWS PROCESSED500,000+ Records
TIME TO BUILD3 Weeks
COMPLEXITY LEVELHiring Grade