Describe a time you used SQL or Excel to solve a complex supply chain bottleneck for a Deloitte client engagement.
For the SQL portion, use the shipment and inventory event records in the schema to identify operational bottlenecks. Treat a warehouse as a bottleneck when its average shipment delay is at least 2 days and it has at least one stockout event.
warehouse_id, shipment_count, late_shipments, avg_delay_days, stockout_events, and bottleneck_status.NORMAL, and order bottlenecks first, then average delay descending and warehouse ID ascending.| Column | Type | Description |
|---|---|---|
| shipment_idPK | INT | Unique shipment identifier |
| warehouse_id | VARCHAR(10) | Warehouse handling the shipment |
| shipment_date | DATE | Shipment processing date |
| delay_days | INT | Number of days the shipment was delayed |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique inventory event identifier |
| warehouse_id | VARCHAR(10) | Warehouse where the event occurred |
| event_date | DATE | Inventory event date |
| event_type | VARCHAR(30) | Type of inventory event |
| notes | VARCHAR(100) | Optional event description |