Mohammed Rashad
← 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

The summary page for managers.
Overtime tracking.
HR compliance and the punch audit.
The data model underneath.

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.