Project library
Empty-Package Shrink Dashboard
Locate retail shrink hotspots and compare trends over time.
Empty-package Recoveries
Explore anonymized recovery records by location, department, and time.
Start with recorded retail value, incidents, average record value, and quarter change, then explore the trend and breakdowns.
- Explore the anonymized records with filters that run in your browser.
- Switch between “Retail Value” and “Incident Count” depending on what you want to compare.
- Apply location and date filters, or expand More filters for condition, department, and associate.
- Expand Record details and concentration for individual records. Use Reset filters to return to the full dataset.
STAR Summary
- Situation
- Empty-package shrink was growing, and leaders needed a single view of trends, hotspots, and forecasted risk across locations and departments.
- Task
- Create a reusable Excel dashboard for locating empty-package shrink hotspots and comparing trends and forecasted risk.
- Action
-
- Cleaned and anonymized 2021-2023 loss-prevention records into a dashboard-ready dataset.
- Built Excel drill-downs for location, department, associate, recovery location, date range, incident count, and retail value.
- Added trend and forecasting views so stakeholders could spot acceleration, not just historical totals.
- Result
-
- Identified a small set of locations, departments, and recovery paths driving disproportionate shrink.
- Made growth periods and hotspots visible enough for targeted review instead of broad manual scanning.
- Created a reusable BI workflow that can be refreshed and extended with anomaly alerts.
