Project library
Empty-Package Shrink Dashboard
Locate retail shrink hotspots and compare trends over time.
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.
Empty-package Recoveries
Explore anonymized recovery records by location, department, and time.
Open full demo
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.
