ANLY482 AY2017-18T2 Group 11 EDA

HOME

PROJECT OVERVIEW

ANALYSIS & INSIGHTS

PROJECT MANAGEMENT

DOCUMENTATION

ANLY482 MAIN

EDA		Analysis & Insights

Exploratory Data Analysis (EDA) – Overview

Overview

Being relatively new in the last mile delivery sector, it is important for Company ABC to maintain an ideal level of efficiency while keeping cost low to ensure profitability. Thus, in order to keep cost low, Company ABC decided to approach the 2 types of service deliveries differently. The Standard Service delivery would be outsourced to Contracted drivers while the Express Service deliveries would primarily fall on the In-House delivery couriers. Thus, in order to derive an accurate depiction of these 2 driver types, the later parts of the EDA section will analyse these 2 driver types separately. This analysis will be done on both temporal and spatial scale. However, prior to that, the upcoming section will first aim to provide an overview of the deliveries conducted by ABC.

Being relatively new in the last mile delivery sector, it is important for Company ABC to maintain an ideal level of efficiency while keeping cost low to ensure profitability. Thus, in order to keep cost low, Company ABC decided to approach the 2 types of service deliveries differently. The Standard Service delivery would be outsourced to Contracted drivers while the Express Service deliveries would primarily fall on the In-House delivery couriers. Thus, in order to derive an accurate depiction of these 2 driver types, the later parts of the EDA section will analyse these 2 driver types separately. This analysis will be done on both temporal and spatial scale. However, prior to that, the upcoming section will first aim to provide an overview of the deliveries conducted by ABC.

Figure 5 shows the summary statistics for both Contractor drivers and In-House drivers based on the quantity for each type of driver, service type and size of parcel. From the data-table, the team identified that majority of the parcels are small in size and are served by contractor drivers under service type “Z”.

However, this concentration of parcel size within the “Small” category is not an unexpected phenomenon as Figure 6 indicated that 85.74% of the total parcels delivered are “Small” in size. This could be the reason why contracted drivers are primarily delivering “Small”-sized parcels.

In addition, as shown in Figure 7, 99.54% of all deliveries are conducted by Contracted drivers. In comparison, only 0.46% of all deliveries are conducted by In-House drivers. As such, this indicates that the services conducted for Contracted drivers are highly sought after, which justifies the large number of deliveries shown in Figure 4.

EDA - Spatial Distribution

Spital Distribution

Location - Contractor Drivers

The deliveries conducted by the Contracted drivers were analysed on a spatial scale. The hierarchy starting from parcel distribution by Zone Code (comprising of West and Central) was then further sub-divided and analysed in terms of District Code, Postal Zone and lastly, Postal Code. Based on the tree-maps generated above, Figure 8 to 10 indicates that the highest volume for the Contracted drivers falls on Western Region, District Code 22 and Postal Zone 64. On the other hand, Postal Zone 62 have the lowest volume within District Code 22.

In addition, as District Code 22 had the highest number of deliveries, the team expected one of the Postal Code within this district to be the one experiencing the highest number of delivery. However, Figure 11 indicated that the individual Postal Code that faced the highest number of delivery falls on Postal Code 228241 and this is a Postal Code within District Code 9; Which is a far cry from the team’s expected zone. As such, the team will analyse this Postal Code and its Zone in greater depth.

Insights