ANLY482 AY2017-18T2 Group07
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:
- Flagged Inconsistent Entries -
- Identified inconsistencies in the data, for example- a text input in a numeric column
- Identified missing values in the data
- 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