Difference between revisions of "G7 Methodology"

From Analytics Practicum
Jump to navigation Jump to search
 
(24 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">Sponsor Data</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>]]
−
 
 
−
| 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:Century Gothic; color:#212121"> [[DHL_Scope  | <b><font color="#212121">Work Scope</font></b>]]
 
  
 
|}
 
|}
Line 48: Line 46:
 
<!--Sub Header End-->
 
<!--Sub Header End-->
 
<!--Content Begins-->
 
<!--Content Begins-->
−
<font color = "#ED515C" face= "Century Gothic" size=16px>
+
 
−
Methodology
+
[[Image:DHL_Methodology.png|center|2000x200px]]
−
</font>
+
 
 
<font color="#212121" face= "Franklin Gothic Book" size=4px>
 
<font color="#212121" face= "Franklin Gothic Book" size=4px>
−
<p>
+
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.
−
For this project, we will use a 3 Phase approach involving data cleaning and preparation, creating actual modules and sensitivity analysis.
+
 
−
<br>
 
−
Our team is required by the sponsor to use Power BI as the visualization tool to maintain consistency across the company. Since we have not signed the NDA yet, so the sponsor has only provided us with the field names along with a data dictionary rather than the actual data, so we can only share our initial thought process on the methodology which will be involved to create each module.
 
−
<ol>
 
−
<li><strong>Lane Seasonality: </strong> By analysing measures like number of shipments, volumetric weight and cost of shipments, we shall try to spot seasonal trends for each lane per account. This will also include analysing the main carriers (airlines) used per lane. A dynamic dashboard will show these trends with options to filter by region, lane and account.</li>
 
−
<li><strong>Density Trend Analysis: </strong> The airlines use a pricing structure in which the price of shipping is determined by both the actual weight and the volume of the shipment. Our sponsor has provided us with the methodology to calculate this chargeable volumetric weight as accepted in the industry. We will use this methodology to categorize the shipments and spot density trends, so we can minimize the shipping costs by having a mix of dense and non-dense shipments.</li>
 
−
<li><strong>OTP Latency: </strong> The shipment data contains the timestamps for each stage in the airfreight operational flow from origin to destination. Based on these we can determine the latency in delivering the shipments for different service categories like ‘Airport to Airport’ (ATA), ‘Door to Airport’(DTA), etc.  We further hypothesis that this latency could be due to numerous factors like air carrier, density of shipment, number of shipments per lane, etc. So, we can use statistical techniques like multiple regression analysis to determine these factors.</li>
 
−
<li><strong>Capacity Planner: </strong>Based on the seasonality and trends found in the earlier modules, we will try to forecast the capacity required each month. We will use several forecasting methods like Moving Average, Multiple Linear regression, etc and choose the forecast with the lowest Standard Error. We will make the model dynamic so that it improves with time as more data is added to it.</li>
 
−
</ol>
 
−
Overall, Project STP+ will map the road towards efficient collaboration, and drive towards greater business growth.
 
 
</font>
 
</font>
−
</p>
 

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.

Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=G7_Methodology&oldid=24282’