Difference between revisions of "ANLY482 AY2017-18 T1 Group2 Project EZLin Final"
Jump to navigation
Jump to search
Line 36: | Line 36: | ||
|} | |} | ||
<!--/Sub Header--> | <!--/Sub Header--> | ||
+ | |||
+ | ==Data Transformation== | ||
+ | <div style="font-size:16px"> | ||
+ | The overall process:<br> | ||
+ | 1.Combined all excel files containing detailed cost component information.<br> | ||
+ | 2.Add SerialCode column and Bom_Id colum.<br> | ||
+ | 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.<br> | ||
+ | 4.Join the table with Special procurement type description.xlsx to get the Long Text which contains the original plant no.<br> | ||
+ | 5.Joined with the putup.xlsx and variant.xlsx.<br> | ||
+ | 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<br> | ||
+ | <br> | ||
+ | ps.Details of this part are under the methodology tab. | ||
+ | </div> | ||
+ | ==Visualization and Report Generation== | ||
− | |||
− | |||
− | |||
<br/> | <br/> |
Revision as of 21:28, 3 December 2017
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