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

From Analytics Practicum
Jump to navigation Jump to search
 
(One intermediate revision 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 81: Line 81:
  
  
</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