Difference between revisions of "ANLY482 AY2017-18T2 Group 11 EDA"

From Analytics Practicum
Jump to navigation Jump to search
Line 36: Line 36:
 
| style="background-color:#2B6C94; font-weight: bold; text-indent: 15px; border-left: 15px solid #4BB9FF" | <font color="#FFF" size=3 > Exploratory Data Analysis (EDA) – Overview</font>
 
| style="background-color:#2B6C94; font-weight: bold; text-indent: 15px; border-left: 15px solid #4BB9FF" | <font color="#FFF" size=3 > Exploratory Data Analysis (EDA) – Overview</font>
 
|}
 
|}
<br />
+
== Overview ==
 
<div style="padding-left:70px; text-align: justify; width:980px;">
 
<div style="padding-left:70px; text-align: justify; width:980px;">
 
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.

Revision as of 02:50, 28 February 2018

T.W.O Banner.png
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.

EDA Overview.png

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.

OverviewDriverType.png

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



Insights