Cover image for Inventory Health & Stock Risk

Inventory Health & Stock Risk Analysis: A Power BI dashboard built to give ecommerce and logistics businesses real-time visibility into stock health surfacing risk before it becomes a costly problem. Business Problem: Most small inventory operations run blind. They reorder too late, hold dead stock for months without realizing it, and have no systematic way to flag which products are quietly draining margin. This dashboard was built to solve exactly that turning raw inventory data into a clear action priority list. Key Findings: •37 out of 275 products (9.25%) are at active stockout risk meaning current stock sits at or below reorder point. •28 products classified as slow movers, indicating potential overstock or weak demand signals. •Storage is the highest-risk category for stockouts, requiring priority attention in replenishment planning. •Southlake Texas warehouse outperforms all other locations in profit contribution. •Overall average profit margin sits at 9.48% with category-level breakdowns revealing where margin is being lost.

Hiba Gannouni

Data analyst turning messy spreadsheets into dashboards.