Workforce Analytics Dashboard: Harri

A custom ETL layer turned raw Harri exports into daily KPI dashboards for labor cost and turnover.

✓

Primary Impact Metric

18%

Overtime Spend Reduced

01 // SITUATION & CHALLENGE

The Operational Bottleneck

Hospitality managers using the Harri platform had raw shift and labor data but no way to spot trends: overtime abuse, high-turnover roles, and scheduling inefficiencies were invisible.

02 // ACTION & ARCHITECTURE

Engineering Strategy & Solution

Built a custom analytics layer on top of Harri's data exports: automated ETL pipeline, KPI dashboards for labor cost, turnover rate, and shift fill time, updated daily.

03 // VERIFIED RESULT

Delivered Operational Impact

3 enterprise accounts reduced overtime spend by 18% within 8 weeks of using the dashboards. Turnover hotspots identified and actioned for the first time.

Supporting System Visuals

Technologies & Protocols Used

PythonSQLPower BIDatadogExcel Automation

← Previous Case StudyAI Client Onboarding System Next Case Study →YAZ-DAILY: Personal Finance Tracker