Difference between revisions of "ANLY482 AY2017-18 T1 Group03/ProjectSteadfast Project Data"

From Analytics Practicum
Jump to navigation Jump to search
(Created page with "<center> 171px </center> <div style="border-bottom: #ffffff solid 6px; padding: 0px 0px 0px 0px;"> <!--Navigation--> {| style="background-color:#ffffff; c...")
 
 
(6 intermediate revisions by the same user not shown)
Line 14: Line 14:
 
| style="font-size:120%; text-align:center; background-color:#ff6600" width="0.5%" |
 
| style="font-size:120%; text-align:center; background-color:#ff6600" width="0.5%" |
 
| style="font-size:120%;  text-align:center;background-color:#ffffff; width=12%" | [[ANLY482_AY2017-18_T1_Group03/About Us|<font face = "Century Gothic" color="#000000">About Us</font>]]
 
| style="font-size:120%;  text-align:center;background-color:#ffffff; width=12%" | [[ANLY482_AY2017-18_T1_Group03/About Us|<font face = "Century Gothic" color="#000000">About Us</font>]]
−
 
−
| style="font-size:120%; text-align:center; background-color:#ff6600" width="1%" |
 
−
| style="font-size:120%;  text-align:center;background-color:#ffcc99; width=12%" | [[ANLY482_AY2017-18_T1_Group03/Project_Overview|<font face = "Century Gothic" color="#000000">Project Overview</font>]]
 
  
 
| style="font-size:120%; text-align:center; background-color:#ff6600" width="0.5%" |
 
| style="font-size:120%; text-align:center; background-color:#ff6600" width="0.5%" |
Line 23: Line 20:
 
| style="font-size:120%; text-align:center; background-color:#ff6600" width="0.5%" |
 
| style="font-size:120%; text-align:center; background-color:#ff6600" width="0.5%" |
 
| style="font-size:120%;  text-align:center;background-color:#ffffff; width=12%" | [[ANLY482_AY2017-18_T1_Group03/Final_Progress|<font face = "Century Gothic" color="#000000">Final Progress</font>]]
 
| style="font-size:120%;  text-align:center;background-color:#ffffff; width=12%" | [[ANLY482_AY2017-18_T1_Group03/Final_Progress|<font face = "Century Gothic" color="#000000">Final Progress</font>]]
 +
 +
| style="font-size:120%; text-align:center; background-color:#ff6600" width="1%" |
 +
| style="font-size:120%;  text-align:center;background-color:#ffcc99; width=12%" | [[ANLY482_AY2017-18_T1_Group03/Project_Overview|<font face = "Century Gothic" color="#000000">Project Overview</font>]]
  
 
| style="font-size:120%; text-align:center; background-color:#ff6600" width="0.5%" |
 
| style="font-size:120%; text-align:center; background-color:#ff6600" width="0.5%" |
Line 53: Line 53:
  
 
<div style="border-style: solid; border-width:0; background: #ff6600; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #ffffff>Data</font></div>
 
<div style="border-style: solid; border-width:0; background: #ff6600; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #ffffff>Data</font></div>
−
Our client will be supplying us with both current and prior year (2016) data. As Client X wants us to focus back on the same type of data from 2016, we will be provided with the same type of files and invoices but with the latest data. The type of files and invoices are summarised in the table below.
+
Our client will be supplying us with both current and prior year (2015-2017) data. The type of files and invoices are summarised in the table below.
−
[[Image:DataTable.png|800px|center]]
+
[[Image:FileMidterms1.PNG|800px|center]]
−
We are currently waiting for the client to compile the latest data from 2017 as we have just signed the nondisclosure act form.  
+
 
 +
<br>
 +
 
 +
<div style="border-style: solid; border-width:0; background: #ff6600; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #ffffff>Data Cleaning and Transformation</font></div>
 +
 
 +
We have done cleaning up and transformation of various files provided by the client with the help of both Excel software and JMP Pro software.
 +
 
 +
<b><u> HCP: </u></b>
 +
[[Image:HCP.PNG|800px|center]]
 +
 
 +
<b><u>HCO: </u></b>
 +
[[Image:HCO.PNG|800px|center]]
 +
 
 +
<b><u>Invoice Detail Report (QlikView) – 2015 and 2016 </u></b>
 +
[[Image:Invoice1.PNG|800px|center]]
 +
 
 +
<b><u> Customer 360 SG (F2F) </u></b>
 +
[[Image:F2F1.PNG|800px|center]]
 +
 
 +
<b><u>Customer 360 SG (Phone Web)</u></b>
 +
[[Image:PhoneWeb.PNG|800px|center]]
 +
 
 +
 
 +
 
 +
 
  
−
</font></div><br>
+
</div><br>

Latest revision as of 13:57, 16 October 2017

Logo3.PNG

Home About Us Midterm Progress Final Progress Project Overview Project Management Documentation

 


Data

Our client will be supplying us with both current and prior year (2015-2017) data. The type of files and invoices are summarised in the table below.

FileMidterms1.PNG


Data Cleaning and Transformation

We have done cleaning up and transformation of various files provided by the client with the help of both Excel software and JMP Pro software.

HCP:

HCP.PNG

HCO:

HCO.PNG

Invoice Detail Report (QlikView) – 2015 and 2016

Invoice1.PNG

Customer 360 SG (F2F)

F2F1.PNG

Customer 360 SG (Phone Web)

PhoneWeb.PNG




Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY2017-18_T1_Group03/ProjectSteadfast_Project_Data&oldid=16635’