ANLY482 AY2017-18 T1 Group2 Project EZLin Midterm

From Analytics Practicum
Revision as of 08:35, 6 October 2017 by Shuang.gao.2014 (talk | contribs)
Jump to navigation Jump to search


HOME

 

ABOUT US

 

PROJECT OVERVIEW

 

PROJECT MANAGEMENT

 

DOCUMENTATION

 

 


ER Diagram


ER EZLin.png


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.

EZLin Picture1.png


Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY2017-18_T1_Group2_Project_EZLin_Midterm&oldid=16536’