Empty-Package Shrink Dashboard

Context

Empty‑package theft had ballooned: recovered retail value jumped 5× from Q1 2021 to Q2 2023, and leaders needed a single view to see where losses were concentrated.

Role

• Built the Excel BI workflow (data cleanup, drill-down views, and reporting).

Approach

• Consolidated 5,900+ loss-prevention records (2021-2023).
• Cleaned and anonymized employee IDs, DPCI codes, dates, and dollar values.
• Built an interactive Excel dashboard with drill-downs by associate, department, and recovery location.
• Compiled results in a report for management.

Impact

• Two recovery locations (anonymized) emerged as the primary hot spots.
• Shrink doubled in under 12 months at one hot spot, with the second doubling in a single quarter.
• Three departments (anonymized) drove most recoveries; the top department jumped ~4× in two quarters.
• Three associates (anonymized) accounted for ~47% of recovered value.

Links

PDF Excel

Notes

Employee and location identifiers are anonymized in the write-up.