Difference between revisions of "G7 Exploratory Analysis"

From Analytics Practicum
Jump to navigation Jump to search
Line 48: Line 48:
 
Note: Due to the confidential nature of our project, we will not be able to reveal all the missing values/fields on this wiki.
 
Note: Due to the confidential nature of our project, we will not be able to reveal all the missing values/fields on this wiki.
  
[[Image:DHL_Work in Progress.png|center|1300x132px]]
+
<font color = "#ED515C" face= "Century Gothic" size=16px>
 +
Business Unit Exploration
 +
</font>
 +
<br>
 +
[[Image:DHL_BUs.png|center|1300x320px]]
 +
<font color="#212121" face= "Franklin Gothic Book" size=4px>
 +
We wanted to identify the major Business Units in our dataset. BU 4 was the top business unit in terms of number of shipments for the years 2015 & 2016 and ranked second in 2017 accounting for 43.02% of the total shipments in the data. BU 2 ranked second for the years 2015 & 2016 and ranked first for the year 2017 accounting for 28.33% of the total shipments in the data.
 +
</font>
 +
<br>
 +
<font color = "#ED515C" face= "Century Gothic" size=16px>
 +
Current Operational Performance
 +
</font>
 +
[[Image:DHL_Status.png|center]]
 +
<font color="#212121" face= "Franklin Gothic Book" size=4px>
 +
Next, we wanted to get a glimpse of the current operational performance across the 3 years. The following table shows that 40% of the shipments were delayed in our dataset and the performance does not vary much across the 3 years.
 +
</font>
 +
<br>
 +
<font color = "#ED515C" face= "Century Gothic" size=16px>
 +
Operational Performance/BUs
 +
</font>
 +
[[Image:DHL_BUStatus.png|center|1300x320px]]
 +
<font color="#212121" face= "Franklin Gothic Book" size=4px>
 +
Next, we wanted to check the difference in the operational performance across different business units. The above chart does show a very different performance for different Business units but we will have to conduct statistical tests to confirm our hypothesis which is further covered under the Confirmatory Analysis section.
 +
</font>
 +
<br>
 +
<font color = "#ED515C" face= "Century Gothic" size= 16px>
 +
Operational Performance/Flight Types
 +
</font>
 +
[[Image:DHL_TypeStatus.png|center|1300x320px]]

Revision as of 14:52, 15 April 2018

DHL Common Banner.png

HOME

 

PROJECT OVERVIEW

 

ANALYSIS & FINDINGS

 

PROJECT MANAGEMENT

 

ABOUT US

 

PRACTICUM HOMEPAGE

 

Note: Due to the confidential nature of our project, we will not be able to reveal all the missing values/fields on this wiki.

Business Unit Exploration

DHL BUs.png

We wanted to identify the major Business Units in our dataset. BU 4 was the top business unit in terms of number of shipments for the years 2015 & 2016 and ranked second in 2017 accounting for 43.02% of the total shipments in the data. BU 2 ranked second for the years 2015 & 2016 and ranked first for the year 2017 accounting for 28.33% of the total shipments in the data.
Current Operational Performance

DHL Status.png

Next, we wanted to get a glimpse of the current operational performance across the 3 years. The following table shows that 40% of the shipments were delayed in our dataset and the performance does not vary much across the 3 years.
Operational Performance/BUs

DHL BUStatus.png

Next, we wanted to check the difference in the operational performance across different business units. The above chart does show a very different performance for different Business units but we will have to conduct statistical tests to confirm our hypothesis which is further covered under the Confirmatory Analysis section.
Operational Performance/Flight Types

DHL TypeStatus.png