🧩 Project: Retail Inventory Optimization Dashboard

🔥 Problem

The client’s inventory managers lacked visibility into which SKUs were overstocked or underperforming. Manual reporting caused a 2-week lag in replenishment decisions, and warehouse stockouts were increasing.

🔍 Discovery & Research

I interviewed warehouse supervisors and analyzed their spreadsheets. We found mismatches between sales velocity and restock frequency. From this, I identified the need for segmentation by item type and lead time.

🛠️ Solution

• Ranked item types by revenue and unit sales
• Tracked supplier lead time and warehouse transfer delays
• Segmented products by velocity using DAX logic

📊 Tools Used

• Power BI
• DAX
• Excel for data cleanup

✅ Outcome / Results

Reduced manual reporting by 70%, improved replenishment speed, and cut stockouts by 32% in Q1.

👤 My Role

Led the full build — scoping, visuals, DAX logic, and stakeholder training.