Explore shrink trends and hotspots with filters and breakdown tabs.
- Wait for the dashboard to finish warming up and load data.
- Switch between “Retail Value” and “Incident Count” depending on what you want to compare.
- Apply filters (location, condition, department, associate, date range) to narrow the view.
- Use “Reset filters” to quickly return to the full dataset.
Links
STAR Summary
- Situation
- Empty-package theft was rising, and leaders needed one view of trends and hotspots across locations and departments.
- Task
- Built the Excel dashboard workflow (cleanup, drill-downs, and reporting).
- Action
-
- Consolidated thousands of loss-prevention records (2021-2023).
- Cleaned the data and anonymized employee IDs, DPCI codes, dates, locations, and retail values.
- Built an interactive Excel dashboard with drill-downs by associate, department, and recovery location.
- Result
-
- Two recovery locations (anonymized) stood out as hotspots.
- A small number of departments and associates drove a disproportionate share of recoveries (anonymized).
- Quarterly trend views made it easy to spot rapid growth periods worth investigating.
Notes
Employee and location identifiers are anonymized in the write-up.
