Warehouse inventory analysis in SQL

The brief

A warehouse is full, yet popular items keep running out. Load orders and product data into a database and use SQL to classify items by movement (ABC/XYZ), find slow movers and items with frequent stock-outs, and estimate the stock tied up in slow movers. Good looks like: reconciled queries, an ABC/XYZ table, and three recommendations.

What you will build

1. Load orders and products into a database
2. Calculate demand and variability per item
3. Classify items with ABC/XYZ analysis
4. Find slow movers and stock-out patterns
5. Recommend actions for each class

Free, open data to build it with

• DataCo smart supply chain ↗ Kaggle

Check each dataset's licence before you publish your work. Your mentor gives your team its own version of the brief (data, scope or region), so every team's project is its own.