Hiryuu Methodology
|
|
|
|
|
|
|
| Background | Data | Methodology |
|---|
Contents
Introduction
The main aim of this practicum is to give our sponsor an insight into the delivery patterns in the different countries managed, focusing on Australia and Japan as these 2 countries have posed the most problems. To do so we will first analyse the trends from 3 months worth of data using 3 main techniques, Exploratory, Time Series, and Geospatial.
With these analysis done, we hope to give our sponsors a clearer picture as to the reasons of failed deliveries so that it will aid the company in avoiding similar pitfalls in the future.
Objectives
There are 5 main objectives we aim to achieve:
- Understanding the patterns and trends across shipment routes in different countries
- Identify patterns such as the locations and timing for shipments with frequent issues
- Conducting time series analysis to determine the presence of seasonality in shipments
- Build a dashboard for single view of all data statistics for a particular country that can measure KPI easily. The sponsors we’re working with are focused on the marketing simplicity and efficiency only. The functions we hope to show includes the following:
Design Specification
- Showing data records of parcels picked up but not replied
- Show visual summary of shipments and current status
- View failed deliveries at a single glance and detailed breakdown at a single click, including track by reference number for both inbound and outbound
- Peak of the failure points when time series analysis
- Simple to understand bar charts and histograms that represents KPI
Multiple iterations of the dashboard will be conducted to increase the usability for our sponsor. We will conduct frequent feedbacks with our supervisor and sponsor to ensure that the dashboard is equipped with the data statistics and KPI most readily useful for the decision making.
Analysis
1. Exploratory Analysis
An exploratory analysis will be conducted first to analyse the shipping behaviour of different customers in different countries.
- Determine the average turnaround time from the first to the last stage.
- Determine the average turnaround time for the statuses closure
- Identify patterns between destinations and shipment issues.
- Identify types of shipments with frequent shipment issues.
2. Geospatial Analysis
To align with the sponsor's requirements, we will do a choropleth mapping for both inbound and outbound shipments in both countries, Australia and Japan. The choropleth mapping will reflect the percentage of passes in each city. Each city on the map will also display further information such as:
- The TOTAL number of shipments to that city
- Number of shipments that PASSED
- Number of shipments that FAILED
- City and State information
3. Time Series Analysis
As the data could be organised by the date, a time series analysis could be conducted. The time series analysis would be broken down into time periods of weeks and month to analyse and identify patterns and trends in the shipment and customer data.
We will also attempt to determine if there are seasonality trends in shipment patterns across different countries for different shipments.
