Difference between revisions of "ANLY482 AY2017-18 T1 Group2"
| (One intermediate revision by one other user not shown) | |||
| Line 24: | Line 24: | ||
|} | |} | ||
| + | |||
| + | <!--Sub Header--> | ||
| + | | ||
| + | {| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
| + | |||
| + | | style="vertical-align:top;width:20%;" | <div style="padding: 3px; text-align:center; line-height: wrap_content; font-size:15px; border-bottom:1px solid #b21301; font-family:tahoma"> [[ANLY482_AY2017-18_T1_Group2| <b>Current</b>]] | ||
| + | |||
| + | | style="vertical-align:top;width:20%;" | <div style="padding: 3px; text-align:center; line-height: wrap_content; font-size:15px; border-bottom:1px solid #b21301; font-family:tahoma"> [[ANLY482_AY2017-18_T1_Group2 Project EZLin_Midterm| <b>Midterm</b>]] | ||
| + | |||
| + | | style="vertical-align:top;width:20%;" | <div style="padding: 3px; text-align:center; line-height: wrap_content; font-size:15px; border-bottom:1px solid #b21301; font-family:tahoma"> [[ANLY482_AY2017-18_T1_Group2 Project EZLin_Final| <b>Final</b>]] | ||
| + | |} | ||
| + | <!--/Sub Header--> | ||
<br/> | <br/> | ||
| Line 35: | Line 47: | ||
<br/> | <br/> | ||
<div style="font-size: 16px;"> | <div style="font-size: 16px;"> | ||
| − | + | The use of programming to automate and cleanse the dataset has numerous benefits that improves the efficiency and productivity of doing things. Python, an object-oriented programming language, is often well-regarded for its ease-of-usage and large variety of standard libraries such as Pandas and Tensorflow. | |
| − | + | ||
| − | + | In order to truly understand the data-automation and transformation process, a collaboration with Johnson & Johnson (JnJ) was made to work on a real-life project focusing on JnJ supply chain network. The objective of this project was to not only help the company understand its end-to-end supply chain network but to also offer insights from data through visualisations done on Tableau. This requires the raw data to be rigorously cleansed and transformed in order for any visualisation to be done, which was in line with our aim of understanding the data-automation and transformation process. Through Tableau, the different types of cost and plants were clearly visualised and represented, providing much insights and setting a foundation for an end-to-end supply chain flow for the company. | |
| − | + | ||
| + | The tangible result from this project was the quick data cleaning and transformation process, that helped integrate the different Excel file and allowing JnJ to identify areas in which attention must be paid to improve its supply chain information accuracy. | ||
| + | <br/> | ||
</div> | </div> | ||
<br/> | <br/> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<br/> | <br/> | ||
<center> | <center> | ||
Latest revision as of 19:44, 3 December 2017
The use of programming to automate and cleanse the dataset has numerous benefits that improves the efficiency and productivity of doing things. Python, an object-oriented programming language, is often well-regarded for its ease-of-usage and large variety of standard libraries such as Pandas and Tensorflow.
In order to truly understand the data-automation and transformation process, a collaboration with Johnson & Johnson (JnJ) was made to work on a real-life project focusing on JnJ supply chain network. The objective of this project was to not only help the company understand its end-to-end supply chain network but to also offer insights from data through visualisations done on Tableau. This requires the raw data to be rigorously cleansed and transformed in order for any visualisation to be done, which was in line with our aim of understanding the data-automation and transformation process. Through Tableau, the different types of cost and plants were clearly visualised and represented, providing much insights and setting a foundation for an end-to-end supply chain flow for the company.
The tangible result from this project was the quick data cleaning and transformation process, that helped integrate the different Excel file and allowing JnJ to identify areas in which attention must be paid to improve its supply chain information accuracy.
