ANLY482 AY1516 G1 Team Skulptors - Methodology
 HOME
|
 ABOUT US
|
 PROJECT OVERVIEW
|
 DATA ANALYSIS
|
 PROJECT MANAGEMENT
|
 DOCUMENTATION
|
| Summary | Description | Methodology | Technology | Limitations & ROI |
Before – Control chart of warehouse on landing page
The landing page of the dashboard was initially designed with a control chart instead of a tree map as sponsors were unfamiliar with tree maps and its usage. The control chart in a warehouse context is a graph used to study both warehouse inbound and outbound of SKUs over time. Data are plotted in a time order with a central line for the average, an upper line for the control limit (80% percentile), and a lower line for the lower control limit (20% percentile). These lines are determined by the data obtained from the sponsors.
After – Tree maps of warehouse on landing page
Upon advice from Prof, the team managed to convince the sponsors on the adoption of a tree map on the application’s landing page. A tree map is a method for displaying hierarchical data by using nested rectangles illustrated by different sizes and colors of squares. The control chart on the other hand, will be incorporated as a subset of the treemap. This meant that each click on a specific square on the treemap will brings the sponsor to a page depicting the outbound control chart for that specific put location.
The rationales of placing the tree map at the landing page is as follows:
- Realistic and practical
- Putting a tree map at the landing page would be appropriate for a warehouse context as it can be used and designed in the form of the warehouse’s floorplan.
- High level view of warehouse utilization
- The different squares of a tree map can be used to depict the put away locations in the warehouse whereas the size of each squares can be used to show the total quantity of SKUs held within it. In addition, the colors of each square can also be used to signify over utilized or underutilization of a warehouse put away location. The control chart on the other hand, only shows micro view of the total outbound from the warehouse.
- Ease of problem identification
- With different color and size dimension correlated in some way with the tree structure, it allows users to spot patterns that would otherwise be difficult. For instance, numerous red squares can easily signify that there the warehouse is not optimally utilized.
- Efficient use of space
- In a warehouse context where there are hundreds of SKUs and put away locations, tree map suits the criteria of legibly displaying hundreds of items on the screen simultaneously compared to other charts (Pie, bar charts).
- In a warehouse context where there are hundreds of SKUs and put away locations, tree map suits the criteria of legibly displaying hundreds of items on the screen simultaneously compared to other charts (Pie, bar charts).
For the list of methodology & technology proposed during the proposal stage, please refer to: Team Skulptors - Methodology & Technology
