Difference between revisions of "ANLY482 AY1516 G1 Team Skulptors - Data Analysis"

From Analytics Practicum
Jump to navigation Jump to search
Line 2: Line 2:
 
<center>
 
<center>
 
[[Image:Skulptors-Logo.png|160px|link=ANLY482 AY1516 G1 Team Skulptors]]
 
[[Image:Skulptors-Logo.png|160px|link=ANLY482 AY1516 G1 Team Skulptors]]
−
{|style="background-color:#ffffff; color:#000000; width="100%" cellspacing="0" cellpadding="10" border="0" |
+
{|style="background-color:#ffffff; color:#000000; width="100%" cellspacing="0" cellpadding="9" border="0" |
  
 
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="10%" |[[Image:Skulptors-HomeIcon.png|25px|link=]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors |<font color="#F5F5F5" size=2><b>HOME</b></font>]]
 
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="10%" |[[Image:Skulptors-HomeIcon.png|25px|link=]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors |<font color="#F5F5F5" size=2><b>HOME</b></font>]]
Line 8: Line 8:
 
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="13%" |[[Image:Skulptors-AboutIcon.png|20px|link=ANLY482 AY1516 G1 Team Skulptors - About Us]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors - About Us|<font color="#F5F5F5" size=2><b>ABOUT US</b></font>]]
 
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="13%" |[[Image:Skulptors-AboutIcon.png|20px|link=ANLY482 AY1516 G1 Team Skulptors - About Us]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors - About Us|<font color="#F5F5F5" size=2><b>ABOUT US</b></font>]]
  
−
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#0064ff; " width="20%" |[[Image:Skulptors-OverviewIcon.png|25px|link=ANLY482 AY1516 G1 Team Skulptors - Project Overview]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors - Project Overview |<font color="#F5F5F5" size=2><b>PROJECT OVERVIEW</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="20%" |[[Image:Skulptors-OverviewIcon.png|25px|link=ANLY482 AY1516 G1 Team Skulptors - Project Overview]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors - Project Overview |<font color="#F5F5F5" size=2><b>PROJECT OVERVIEW</b></font>]]
  
−
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="18%" |[[Image:Skulptors-DataIcon.png|25px|link=ANLY482 AY1516 G1 Team Skulptors - Data Analysis]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors - Data Analysis |<font color="#F5F5F5" size=2><b>DATA ANALYSIS </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#0064ff; " width="18%" |[[Image:Skulptors-DataIcon.png|25px|link=ANLY482 AY1516 G1 Team Skulptors - Data Analysis]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors - Data Analysis |<font color="#F5F5F5" size=2><b>DATA ANALYSIS </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]]
  
 
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="22%" |[[Image:Skulptors-ProjMgmtIcon.png|23px|link=ANLY482 AY1516 G1 Team Skulptors - Project Management]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors - Project Management |<font color="#F5F5F5" size=2><b>PROJECT MANAGEMENT</b></font>]]
 
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="22%" |[[Image:Skulptors-ProjMgmtIcon.png|23px|link=ANLY482 AY1516 G1 Team Skulptors - Project Management]] &nbsp; [[ANLY482 AY1516 G1 Team Skulptors - Project Management |<font color="#F5F5F5" size=2><b>PROJECT MANAGEMENT</b></font>]]
Line 19: Line 19:
 
<!--Sub Navigation-->
 
<!--Sub Navigation-->
 
{|style="background-color:#ffffff; color:#000000; font-size:10pt" padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"|
 
{|style="background-color:#ffffff; color:#000000; font-size:10pt" padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"|
−
|style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Data Analysis |<font color="#000a1a"><b>Data Cleaning</b></font>]]
+
|style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Data Analysis |<font color="#000a1a"><b>Data Cleaning </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]]
−
|style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Inbound EDA |<font color="#005ae6"><b>Inbound EDA</b></font>]]
+
|style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Inbound EDA |<font color="#005ae6"><b>Inbound EDA </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]]
−
|style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Outbound EDA |<font color="#005ae6"><b>Outbound EDA</b></font>]]
+
|style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Outbound EDA |<font color="#005ae6"><b>Outbound EDA </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]]
 
|}
 
|}
 
<br/>
 
<br/>

Revision as of 21:47, 28 February 2016

Skulptors-Logo.png

Skulptors-HomeIcon.png   HOME Skulptors-AboutIcon.png   ABOUT US Skulptors-OverviewIcon.png   PROJECT OVERVIEW Skulptors-DataIcon.png   DATA ANALYSIS new! Skulptors-ProjMgmtIcon.png   PROJECT MANAGEMENT Skulptors-DocIcon.png   DOCUMENTATION
Data Cleaning new! Inbound EDA new! Outbound EDA new!


Before embarking on the Exploratory Data Analysis (EDA) stage, the team took time to understand the data they were handling and also remove irrelevant data that should not be included in the analysis. The data cleaning change log can be seen below:

Data Cleaning Log
S/NDateData Cleaning StepsRationale & Justification
0106 JanRemoved data with repetition.Data repetition is commonly due to accidental double scanning in the warehouse.
0206 JanRemoved rows with missing data.Rows with incomplete data are excluded as they have no value.
0306 JanRemoved data rows which exceeded time frame.As our project focuses on the inflow rate and outflow rate of the SKUs movement for a year (Jan 16 – Dec 16), data sets which exceeded this time frame were removed.
0423 JanRemoved data rows with transcode “IRT” for inbound dataset.Sponsors felt that rows with transcode “IRT” were not valuable to them as they represented failed inbound transactions.
0523 JanRemoved data rows with transcode “OCP,ORP,ORV,OSA, OSD” for outbound dataset.Sponsors felt that rows with transcode “OCP, ORP, ORV, OSA, OSD” were not valuable to them as they represented failed outbound transactions.
0623 JanAmendments to outbound dataset.Team found out that there were some discrepancy in the outbound data. There were two outbound excel data sets from (Jan - July) and (Aug - Dec). However, (Jan - July)’s excel has some datasets with transaction records of in the month of Aug, Sep and Oct. These dataset were unique from those in the (Aug - Dec)’s data. Hence, the team ported over the datasets which had transactions from Aug, Sep and Oct from the (Jan - July)’s excel to (Aug - Dec)’s excel upon clarification with sponsors.
0705 FebRe-added data rows with transcode “IRT” for inbound dataset.Upon advice from Prof. This will provide sponsors with the option to analyze failed inbound transactions if they wish to, in the future.
0805 FebRe-added data rows with transcode “OCP,ORP,ORV,OSA, OSD” for outbound dataset.Upon advice from Prof. This will provide sponsors with the option to analyze failed outbound transactions if they wish to, in the future.
0905 FebMerging of two separate excel files into a single csv file.Upon advice from Prof. To eliminate the need for working on two separate datasets. Improves efficiency of analyzing as there is only one single csv file to work on.
1018 FebAdded a column into existing dataset to represent each SKU “A, B, C” classification.Upon advice from Prof. This will allow team to further analyze and find out how the “A, B, C” classification of each SKU correlates with it outbound rate and put away location.


Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY1516_G1_Team_Skulptors_-_Data_Analysis&oldid=6174’