Difference between revisions of "G7 Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
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; border-bottom:1px solid #3D9DD7; font-family:helvetica"> [[DHL_Data | <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; border-bottom:1px solid #3D9DD7; font-family:helvetica"> [[DHL_Data | <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"> [[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; 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; font-family:Century Gothic; color:#212121"> [[DHL_Scope  | <b><font color="#212121">Work Scope</font></b>]]
 
 
 
|}
 
|}
 
<!--Sub Header End-->
 
<!--Sub Header End-->

Revision as of 17:18, 25 February 2018

DHL Common Banner.png

HOME

 

PROJECT OVERVIEW

 

ANALYSIS & FINDINGS

 

PROJECT MANAGEMENT

 

ABOUT US

 

PRACTICUM HOMEPAGE

 

Sponsor Data

Our sponsor will provide us test data for two clients based on their current records. The provided data will consist of some of the variables as mentioned below. For ease of explanation, variables are broadly categorized into different categories.

  1. Shipment Variables: Unique identification number (HAWB Number), Origin of Shipment (ORG), Final Destination of Shipment (FDST), Type of Service (SVC), Type of Commodity Shipped (CMDTYCD)
  2. Payor Variables: Payor Account (PAYOR_ACCT), Payor Name (PAYOR_NAME), Payor Corporate ID (PAYOR_CORP)
  3. Shipment Weight Variables: Pieces (PCS), Chargeable Weight (WGT), Actual Weight (AWGT), Dim Factor (DIM_FTR), Volume of Shipment (VOL)
  4. Payment Variables: Freight Charge (WTCHG), Handling Charge (HNDLG), Pickup charge (PU), Miscellaneous Charge (MISC), Total Charges (TTG), Advanced Charges (ADV)
  5. Timestamp Variables: Freight Received Date (FRTRDATE), Final Recovery Date (FNLRCVYDT), Time Broker Notified Date (TBH_DATE), Entered Customs Date (CUS_DATE), Cleared Customs Date (CLC_DATE), Out for Delivery Date (OFDDATE), Arrival Date (ARRIVEDATE), Due Date (DUEDATE), POD Date (PODATE)
  6. Gateway Variables: Gateway Origin (GTWY_ORG), Gateway Airline (GTWYAIRL), Gateway Master Airway Bill (GTWYMAWB), Gateway Destination (GTWY_DST), Gateway Flight Number (GWWY_FLT), Gateway Flight Date (GTWYFLTDT), Gateway Recovery Date (GTWYRCVYDT), Origin (ORG1), Airline (AIRL1), Master Airway Bill Number (MAWB01), Destination (DST1), Flight Number (ALFLT1), MB Flight Date (MBFLTDT1), MB Recovery Date (MBRCVYDT1)
  7. Warehouse Timestamp Variables: Freight Physically Recovered Date (FRTPHYDRATE), Actual Pick Up Date & Time (APT_DATE), Consol Closed (CLS_DATE), Departed Origin Airport (CFM_DATE), Delivery Matrix Criteria (DM_CRITERIA), Delivery Matrix Level (DM_LVL), Delivery Matrix Transit Time (DM_AGREED_TRANSIT_TIME)

Overall, Project STP+ will map the road towards efficient collaboration, and drive towards greater business growth.