← The Vault
Workforce dashboard for a JW Marriott
Spring 2026 · Hult, MSBA
A JW Marriott property with about 205 hourly workers kept its schedule in one system and its clock ins in another. The two never talked, so problems only showed up after payroll had run.
What we made
What I built
A Power BI dashboard that brings both systems together across 8.5 months of shifts and punches, with a summary page written for managers.
What it catches
Overtime past 40 hours a week. People clocking in six or seven minutes off to game the rounding rule. Missed punches. Student workers getting close to their 19 hour weekly cap, or to the 1,000 hours where benefits kick in.
What it found
Across 21,569 clock ins: 1,875 overtime hours, 228 breaches of the weekly cap, 121 missed punches, and 1,951 punches inside the rounding window.