ANLY482 AY2016-17 T1 Group5 - Data Exploration
|
|
|
|
|
|
| Data Cleaning | Data Exploration | Dashboard |
Contents
Monthly Sales
From this visualization, the sales performance on December 2015 performs considerably much better as compared to the rest of the months. Also, in August 2016, there the number of orders seem to peaked but the sales amount did not increase as much as expected. As the team only received the data in early September, there are only a few data entries in that month, therefore explaining the height of the bar for September 2016.
Monthly Order Quantity
Similarly to the first visualization, we can see that December 2015 is the best performing month in the history of this outlet.
Sales by Day of Week
One would expect that the weekends will perform better in terms of sales, however interestingly, in 2016, the sales on Mondays is the second highest after Sunday.
Order Quantity by Day of Week
Similar to the previous visualization, the top 3 best performing days in 2016 are Sunday, Monday and Saturday in order.
Sales by Hour of the Day
From this graph, we see that the highest performing hour of the day is from 3pm to 4pm. This tells the user that the peak period is during those times of the day. This information can help the manager of the outlet to create special promotions at the hour in order to attract more customers.
