Difference between revisions of "G7 Methodology"

From Analytics Practicum
Jump to navigation Jump to search
 
(20 intermediate revisions by the same user not shown)
Line 9: Line 9:
 
| style="padding:0.3em; font-size:100%; background-color:#212121;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
 
| style="padding:0.3em; font-size:100%; background-color:#212121;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
  
[[DHL_Project Overview | <font color="#6FEBAO" size=2><font face= "Century Gothic"><b>PROJECT OVERVIEW</b></font>]]
+
[[G7 Project Overview | <font color="#6FEBAO" size=2><font face= "Century Gothic"><b>PROJECT OVERVIEW</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="padding:0.3em; font-size:100%; background-color:#212121;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="12%" |  
 
| style="padding:0.3em; font-size:100%; background-color:#212121;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="12%" |  
  
[[DHL_Project Findings |<font color="#00C6BB" size=2><font face= "Century Gothic"><b>PROJECT FINDINGS</b></font>]]
+
[[G7 Findings |<font color="#00C6BB" size=2><font face= "Century Gothic"><b>PROJECT FINDINGS</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="padding:0.3em; font-size:100%; background-color:#212121;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="12%" |  
 
| style="padding:0.3em; font-size:100%; background-color:#212121;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="12%" |  
  
[[DHL_Project Management|<font color="#00C6BB" size=2><font face= "Century Gothic"><b>PROJECT MANAGEMENT</b></font>]]
+
[[G7 Project Management|<font color="#00C6BB" size=2><font face= "Century Gothic"><b>PROJECT MANAGEMENT</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="padding:0.3em; font-size:100%; background-color:#212121;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
 
| style="padding:0.3em; font-size:100%; background-color:#212121;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
  
[[DHL_About Us |<font color="#00C6BB" size=2><font face= "Century Gothic"><b>ABOUT US</b></font>]]
+
[[G7 About Us |<font color="#00C6BB" size=2><font face= "Century Gothic"><b>ABOUT US</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
Line 37: Line 37:
 
{| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |
 
{| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |
  
| style="vertical-align:top;width:15%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; font-family:helvetica"> [[DHL_Project Overview  | <b><font color="#212121">The Process</font></b>]]
+
| style="vertical-align:top;width:15%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; font-family:helvetica"> [[G7_Project Overview  | <b><font color="#212121">The Process</font></b>]]
  
  
| style="vertical-align:top;width:15%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #3D9DD7; font-family:helvetica"> [[DHL_Methodology | <b><font color="#212121">Team Methodology</font></b>]]
+
| style="vertical-align:top;width:15%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #3D9DD7; font-family:helvetica"> [[G7_Methodology | <b><font color="#212121">Methodology</font></b>]]
  
 
|}
 
|}
Line 47: Line 47:
 
<!--Content Begins-->
 
<!--Content Begins-->
  
[[Image:DHL_WorkProgress.PNG|center|2050x332px]]
+
[[Image:DHL_Methodology.png|center|2000x200px]]
 +
 
 
<font color="#212121" face= "Franklin Gothic Book" size=4px>
 
<font color="#212121" face= "Franklin Gothic Book" size=4px>
 +
The figure above shows the Methodology applied by the team. The dataset contains shipment records of each BU of Company X’s largest client for the years of 2015, 2016, and 2017. The team began data preparation by creating an appended file and calculating columns representative of the four phases of the shipment process. Discrepancies found from this process were highlighted to Company X. Following this, an Exploratory Analysis was conducted – this helped the team detect anomalies and outliers in the data. To determine statistical significance between the parameters being tested, a further confirmatory analysis was performed using methods such as Phi and Cramer’s test, Kruskal-Wallis test, and Mann-Whitney test. Following this, a dashboard was created to draw insights using visualization tools such as Mosaic Plots, and Box Plots. The following methodology allowed the team to formulate recommendations for Company X’s GAMs.
 +
 
</font>
 
</font>

Latest revision as of 18:08, 15 April 2018

DHL Common Banner.png

HOME

 

PROJECT OVERVIEW

 

PROJECT FINDINGS

 

PROJECT MANAGEMENT

 

ABOUT US

 

PRACTICUM HOMEPAGE

 

DHL Methodology.png

The figure above shows the Methodology applied by the team. The dataset contains shipment records of each BU of Company X’s largest client for the years of 2015, 2016, and 2017. The team began data preparation by creating an appended file and calculating columns representative of the four phases of the shipment process. Discrepancies found from this process were highlighted to Company X. Following this, an Exploratory Analysis was conducted – this helped the team detect anomalies and outliers in the data. To determine statistical significance between the parameters being tested, a further confirmatory analysis was performed using methods such as Phi and Cramer’s test, Kruskal-Wallis test, and Mann-Whitney test. Following this, a dashboard was created to draw insights using visualization tools such as Mosaic Plots, and Box Plots. The following methodology allowed the team to formulate recommendations for Company X’s GAMs.