ANLY482 AY2017-18 T1 Group2 Project EZLin Final
Revision as of 21:28, 3 December 2017 by Ziteng.wang.2014 (talk | contribs)
Data Transformation
The overall process:
1.Combined all excel files containing detailed cost component information.
2.Add SerialCode column and Bom_Id colum.
3.Merged the combined excel file (containing all the cost components) with material master.xlsx file to get the Special Procurement Type (SPT) for each material.
4.Join the table with Special procurement type description.xlsx to get the Long Text which contains the original plant no.
5.Joined with the putup.xlsx and variant.xlsx.
6.Transform all cost values to USD and Litre(KG) unit.
7.Transpose the table.
8.Merge the consolidated data file with the Packaging Data.xlsx and ChemicalWithPlantCode.xlsx
ps.Details of this part are under the methodology tab.
Visualization and Report Generation