Difference between revisions of "ANLY482 AY2017-18T2 Group07"

From Analytics Practicum
Jump to navigation Jump to search
Line 55: Line 55:
 
<font color="#212121" face= "Franklin Gothic Book" size=4px>
 
<font color="#212121" face= "Franklin Gothic Book" size=4px>
  
Our sponsor company is one of the worlds largest logistics companies providing international courier, parcel and express mail services. They have a  vast global network which spans over 220 countries and territories, and establishing and maintaining relationships with its clientele is key.  
+
Our sponsor company is one of the worlds largest logistics companies providing international courier, parcel and express mail services.  
  
Our sponsor, the Group Innovation Strategy(GSI) department functions as the consulting arm of this logistics company. It aims to improve operational efficiency across multiple business accounts to ensure that the Group Account Managers (GAM) are successfully able to increase value across their stakeholders.  
+
Our sponsor is the consulting arm of this logistics company. It aims to improve operational efficiency across multiple business accounts to ensure that the Group Account Managers (GAM) are successfully able to increase value across their stakeholders.  
 
</font>
 
</font>
 
</p>
 
</p>
Line 76: Line 76:
 
<p>
 
<p>
 
<font color="#212121" face= "Franklin Gothic Book" size=4px>
 
<font color="#212121" face= "Franklin Gothic Book" size=4px>
Our team wants to help the sponsor make better sense of their data. During this preliminary stage, we intend to achieve the following:
+
Our team aims to help the GAMs make better sense of their data. During this preliminary stage, we achieved the following:<ol>
<ol>
+
<li>Flagged Inconsistent Entries -
<li>Data cleanup:
 
 
  <ul>
 
  <ul>
   <li>Inconsistencies in the data, for example- a text input in a numeric column</li>
+
   <li>Identified inconsistencies in the data, for example- a text input in a numeric column</li>
   <li>Missing values in the data</li>
+
   <li>Identified missing values in the data</li>
 
  </ul>
 
  </ul>
 
</li>
 
</li>
<li>Exploratory Data Analysis:
+
<li>Explored the data -
 
  <ul>
 
  <ul>
 
   <li>Basic exploratory analysis to check skews in the data and identify general trends</li>
 
   <li>Basic exploratory analysis to check skews in the data and identify general trends</li>
Line 92: Line 91:
 
</li>
 
</li>
 
</ol>
 
</ol>
After the initial round of EDA, our team concluded that to help our sponsor in a sustainable manner, it’ll be essential to develop a visualization tool that encapsulates all key datasets.
 
 
</font>
 
</font>
 
</p>
 
</p>

Revision as of 00:05, 26 February 2018

DHL Banner.png


HOME

 

PROJECT OVERVIEW

 

ANALYSIS & FINDINGS

 

PROJECT MANAGEMENT

 

ABOUT US

 

PRACTICUM HOMEPAGE


DHL Tracker 25thFeb.jpg


Note: due to the confidential nature of this project, we shall refer to our Project Sponsor as the "Sponsor" throughout this wiki. We will not be able to publish major findings and any visualization or graphics made in line with this measure.



Team Data Heavy Legends(DHL) wants to help its sponsor provide its service in the most efficient manner possible by making sense of the data they currently have. Through our efforts we hope to satisfy all stakeholders involved equally.


Project Sponsor

Our sponsor company is one of the worlds largest logistics companies providing international courier, parcel and express mail services. Our sponsor is the consulting arm of this logistics company. It aims to improve operational efficiency across multiple business accounts to ensure that the Group Account Managers (GAM) are successfully able to increase value across their stakeholders.

Objectives

Our team aims to help the GAMs make better sense of their data. During this preliminary stage, we achieved the following:

  1. Flagged Inconsistent Entries -
    • Identified inconsistencies in the data, for example- a text input in a numeric column
    • Identified missing values in the data
  2. Explored the data -
    • Basic exploratory analysis to check skews in the data and identify general trends
    • Identify the bottlenecks in the shipment journey affecting the operational performance
    • Analyze the shipment patterns and trends for lane-wise pairs in the existing dataset