ANLY482 AY2017-18 T1 Group2 Project EZLin Midterm
Revision as of 08:36, 6 October 2017 by Shuang.gao.2014 (talk | contribs)
ER Diagram
ER diagram is used to present the relationship between the excel sheets that we have received.
Data Transformation
The transformation in data that we have performed are listed below.
- Add Bom_Id, SerielCode column to all excel files about BOM.
- Add SubconOrNot column to all excel files about BOM
- Combine all excel files into one csv file
- Combine Purchase Information excel sheet with Purchase Information Linkage
- Combine material master excel sheet with Special procurement type description
- Transform all currencies into Singapore dollars.
- Transform excel format data about Bom to JSON format (For Visualization)
More details will be presented in 'Data' under 'Project Overview' part!
Visualization
We used JMP for visualization, in order to see the relationships between products of different levels and the manufacturing plant or distribution centers. One of the visualizations you can find below which shows the visualization of No. of Level 1 Products in each plant.