Difference between revisions of "ANLY482 AY2017-18 T1 Group2"

From Analytics Practicum
Jump to navigation Jump to search
 
(3 intermediate revisions by 2 users not shown)
Line 24: Line 24:
  
 
|}
 
|}
 +
 +
<!--Sub Header-->
 +
&nbsp;
 +
{| 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;">
In our project, we will focus on helping XXX to do analysis about the price of the materials in their product BOM (bill of materials), which allows them to make better decisions when purchasing raw materials. This can create higher profit to their business through saving cost, and provide better service to customers. <br/>
+
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.
The data we can get from XXX includes: a list of materials with their prices, the company vendor information and the relationship between each plant and distribution center. XXX APAC has many plants and distribution centres all over the Asia. Therefore from the data, we can see the shipment flow of materials through mapping the plants and the distribution centers. <br/>
+
 
To help XXX better understand their data, first thing we will do is to use some data visualization tools to visualize the shipment relationship between each plants and distribution centres. Then we will compare the shipment in different areas in details. Ideally, we would like to identify some of the factors contributing to the variance of the material’s price and the shipment price. <br/>
+
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/>
  
<!--Sub Header-->
+
<br/>
&nbsp;
 
{| 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-->
 
 
 
 
<center>
 
<center>
[[File:EZLin Comingsoon.png|800px]]
+
[[File:EZLin Progress.PNG|1000px]]
 
</center>
 
</center>
 
<br/>
 
<br/>

Latest revision as of 19:44, 3 December 2017


HOME

 

ABOUT US

 

PROJECT OVERVIEW

 

PROJECT MANAGEMENT

 

DOCUMENTATION

 

 


EZLin Logo.jpg


Project Introduction


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.



EZLin Progress.PNG