ANLY482 AY2017-18 T1 Group2 Project EZLin Final

From Analytics Practicum
Revision as of 21:28, 3 December 2017 by Ziteng.wang.2014 (talk | contribs)
Jump to navigation Jump to search


HOME

 

ABOUT US

 

PROJECT OVERVIEW

 

PROJECT MANAGEMENT

 

DOCUMENTATION

 

 

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