The Challenge
Executive leadership needed a consolidated view of store in-stock rates and outstanding purchase orders. Weekly email reports were outdated by the time they reached inboxes, and drilling into specific stores or categories required manual data requests.
Key Business Questions
- What is our week-over-week in-stock trend by store and category?
- Which stores are underperforming vs. corporate benchmarks?
- What is the total pending PO value by month and warehouse?
- How are consumables vs. hardlines performing?
The Solution
I designed a two-dashboard executive suite that provides both macro and micro visibility:
🏪 In-Stock Executive Overview
Week-by-week in-stock percentages by banner (PVO-Corp, PVO-Fran) broken down by category (Consumables, Hardlines, Specialty) across 8-week rolling window.
📋 Outstanding PO Dashboard
Multi-million dollar pending purchase order tracking by month, warehouse, and portfolio with pie chart distribution analysis.
📊 ABCD SKU Velocity
Sales velocity analysis categorizing SKUs by movement rates to optimize assortment decisions.
🔄 DC Summary
Distribution center performance metrics with store/DC correlation views.
Dashboard Views
