ANLY482 AY2017-18 Group9: Project Findings
Delivery Analysis
As shown in Figure 1, we can identify that the percentage of total delivery in 2016 stood at 46.65% and 53.35% in 2017. In comparison to the percentage of total quantity ordered, 2016 stood at 44.83% and 2017 stood at 55.17% increment. Upon further investigation in our EDA, we realized that it is mainly due to the new outlets open in 2016 and 2017 (Figure 2), which made 2016 data collectively lesser than 2017 dataset.
As shown in Figure 3, new outlets contributed to 551 (7.84%) increment of delivery counts and 18,439 (7.47%) of quantity counts. While the remaining contribution can be broken down into contributions by various existing outlets as shown in Figure 4 below.
As shown in Figure 4, we can identify that there are several outlets that had shown total delivery decrement from 2016 to 2017 (i.e. 2017 do less deliveries than 2016). Examples of outlets decrease from 2017 as compared to 2016 are Ang Mo Kio, Bishan and ION Orchard. However, in comparison to the chart on the right regarding contribution of new outlets by quantity, it displayed otherwise. Henceforth we can conclude that although the number of delivery decrease from 2017 as compared to 2016, it does not justify that the order decrease. With that we have decided to focus on the chart on the right which shows contribution of new outlets by quantity.
Figure 5 below illustrate the trend analysis on the quantity ordered for Boon Lay MRT outlet and City Square Mall outlet. From the chart, we could identify that the time series trend for the two outlets which shown significant quantity decrement. Henceforth, we have noted and will highlight to our sponsors regarding the outlets business performance for their consideration.
Outlets Analysis
Figure 6 highlight the top 15 outlets on delivery ordered and quantity ordered. From the chart, we have identified “City Square Mall” as the abnormally with low number of deliveries recorded (rank 13) but high quantity ordered (rank 1). We have drilled down to understand the underlying reason behind it (figure 7)
Figure 6 highlight the top 15 outlets on delivery ordered and quantity ordered. From the chart, we have identified “City Square Mall” as the abnormally with low number of deliveries recorded (rank 13) but high quantity ordered (rank 1). We have drilled down to understand the underlying reason behind it (figure 7)