Deep Analysis on Cancelled delivery

[Maxwell-ihiaso]

@Ernest-30 While there were more successful deliveries than canceled, It will also be important to understand how we can circumvent failed deliveries. Please can we get an insight/ dashboard on the canceled deliveries? Can we know what is/are the major factor(s)?

[Ernest-30]

@Maxwell-ihiaso Please see below Analysis of the Cancelled Orders. Click Here for the full SQL analysis

Overview of Cancelled Orders

Total Cancelled Orders - 947 Loss_sales (USD) - 10,999.19
Number_of_outlets with Cancelled Orders - 327 Number_of_products cancelled - 60
Number_of_SKUs cancelled - 162 Quantity_Cancelled - 1,782 Average_cancellation_hours - 47

Insights

1. Supermarkets recorded the highest number of cancelled orders with a total of 341 orders cancelled, which is made up of 128 SKUs, 650 items and loss revenue of 4,275.79 USD.

2. The time of day with the highest number of cancelled orders is 10 am with a total of 173 orders cancelled which has a total of 302 Items and loss revenue of 2,010.57 USD.

3. On the Average, more SKUs of the producer Danone Nigeria was cancelled by a customer with an Average of 5 SKUs returned per customer.

4. The producer with the highest number of cancelled orders is Unilever SA with a total of 711 cancelled Orders which has a total of 1,150 and loss revenue of 4,116.12 USD

5. The product with the highest number of cancelled orders is Sunlight Laundry Detergent with cancelled orders from 165 customers and loss revenue of 1,044.84 USD, while the product with the lowest number of cancelled orders is Vaseline Body Lotion with cancelled orders from 1 customer and loss revenue of 9.34 USD.

6. Mobile app sales channel has the highest number of cancelled orders with a total of 508 cancelled orders and 3,028.33 USD loss revenue while Telesales channel has the highest number of loss revenue of 5,339.2 USD.

7. Products that fall in the Home Care category group has more cancelled orders of 405, with 811 items cancelled and loss revenue of 2,962.63 USD.

8. The customer with the highest cancelled orders is Sibaya Supermarket with a total of 13 cancelled orders and this has a total 31 items and loss revenue of 102.04 USD.

9. The state with the highest cancelled orders is Gauteng in South Africa, with a total of 711 cancelled orders which contains 1,150 items and loss revenue of 4,116.12 USD.

10. The delivery agent with the most cancelled orders is Kagiso Katlego with a total of 247 cancelled orders and loss revenue of 1,407.12 USD.

Visualization

Click Here to view the full interactive dashboard.