Difference between revisions of "G7 Methodology"
| Line 40: | Line 40: | ||
| − | | 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"> | + | | 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">Methodology</font></b>]] |
|} | |} | ||
| Line 48: | Line 48: | ||
[[Image:DHL_WorkProcess.jpg|center|2050x332px]] | [[Image:DHL_WorkProcess.jpg|center|2050x332px]] | ||
| + | |||
<font color="#212121" face= "Franklin Gothic Book" size=4px> | <font color="#212121" face= "Franklin Gothic Book" size=4px> | ||
| + | Figure 2 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> | ||
Revision as of 12:59, 15 April 2018
Figure 2 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.
