Difference between revisions of "ANLY482 AY2016-17 T2 Group10 Project Overview: Data"

From Analytics Practicum
Jump to navigation Jump to search
(Created page with "<center> 300px </center> <!------- Main Navigation Bar----> <center> {| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"| | s...")
 
 
(13 intermediate revisions by 2 users not shown)
Line 6: Line 6:
 
<center>
 
<center>
 
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
 
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
−
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="190px" |  
+
| style="font-family:Century Gothic, Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #edf8b1" width="190px" |  
 
[[ANLY482_AY2016-17_T2_Group10|<font color="#3c3c3c"><strong>HOME</strong></font>]]
 
[[ANLY482_AY2016-17_T2_Group10|<font color="#3c3c3c"><strong>HOME</strong></font>]]
  
−
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="210px" |   
+
| style="font-family:Century Gothic, Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #c7e9b4" width="210px" |   
 
[[ANLY482_AY2016-17_T2_Group10_About_Us|<font color="#3c3c3c"><strong>ABOUT US</strong></font>]]
 
[[ANLY482_AY2016-17_T2_Group10_About_Us|<font color="#3c3c3c"><strong>ABOUT US</strong></font>]]
  
−
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #1b96fe" width="210px" |   
+
| style="font-family:Century Gothic, Open Sans, Arial, sans-serif; font-size:15px; text-align: center; background-color: #7fcdbb;border-top-right-radius:7px;border-top-left-radius:7px; border-top:solid #ffffff; border-bottom:solid #7fcdbb" width="210px" |   
−
[[ANLY482_AY2016-17_T2_Group10_Project_Overview|<font color="#3c3c3c"><strong>PROJECT OVERVIEW</strong></font>]]
+
[[ANLY482_AY2016-17_T2_Group10_Project_Overview|<font color="#fff"><strong>PROJECT OVERVIEW</strong></font>]]
  
−
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="230px" |   
+
| style="font-family:Century Gothic, Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #41b6c4" width="230px" |   
 
[[ANLY482_AY2016-17_T2_Group10_Analysis_&_Findings|<font color="#3c3c3c"><strong>ANALYSIS & FINDINGS</strong></font>]]
 
[[ANLY482_AY2016-17_T2_Group10_Analysis_&_Findings|<font color="#3c3c3c"><strong>ANALYSIS & FINDINGS</strong></font>]]
  
−
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="230px" |   
+
| style="font-family:Century Gothic, Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #2c7fb8" width="230px" |   
 
[[ANLY482_AY2016-17_T2_Group10_Project_Management|<font color="#3c3c3c"><strong>PROJECT MANAGEMENT</strong></font>]]
 
[[ANLY482_AY2016-17_T2_Group10_Project_Management|<font color="#3c3c3c"><strong>PROJECT MANAGEMENT</strong></font>]]
  
−
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="190px" |   
+
| style="font-family:Century Gothic, Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #253494" width="190px" |   
 
[[ANLY482_AY2016-17_T2_Group10_Documentation|<font color="#3c3c3c"><strong>DOCUMENTATION</strong></font>]]
 
[[ANLY482_AY2016-17_T2_Group10_Documentation|<font color="#3c3c3c"><strong>DOCUMENTATION</strong></font>]]
  
Line 32: Line 32:
 
<center>
 
<center>
 
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px;" width="80%"|
 
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px;" width="80%"|
−
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; border-radius: 7px; background-color: #fff" width="200px" |  
+
| style="font-family:Century Gothic, Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; border-radius: 7px; background-color: #fff;" width="200px" |  
 
[[ANLY482_AY2016-17_T2_Group10_Project_Overview|<font color="#3c3c3c"><strong>Overview</strong></font>]]
 
[[ANLY482_AY2016-17_T2_Group10_Project_Overview|<font color="#3c3c3c"><strong>Overview</strong></font>]]
−
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; border-radius: 7px; background-color: #f5f5f5" width="200px" |   
+
| style="font-family:Century Gothic, Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 2px #7fcdbb; border-radius: 7px; background-color: #fff" width="200px" |   
 
[[ANLY482_AY2016-17_T2_Group10_Project_Overview:_Data|<font color="#3c3c3c"><strong>Data</strong></font>]]
 
[[ANLY482_AY2016-17_T2_Group10_Project_Overview:_Data|<font color="#3c3c3c"><strong>Data</strong></font>]]
−
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; border-radius: 7px; background-color: #fff" width="200px" |   
+
| style="font-family:Century Gothic, Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; border-radius: 7px; background-color: #fff" width="200px" |   
 
[[ANLY482_AY2016-17_T2_Group10_Project_Overview:_Methodology|<font color="#3c3c3c"><strong>Methodology</strong></font>]]
 
[[ANLY482_AY2016-17_T2_Group10_Project_Overview:_Methodology|<font color="#3c3c3c"><strong>Methodology</strong></font>]]
 
|}
 
|}
 
</center>
 
</center>
 +
<div style="font-size: 13px; font-family:Century Gothic; background-color: #fff;  display: inline-block; padding: 5px; border-radius: 7px">
 +
[[ANLY482_AY2016-17_Term_2|<font color="#636363"><< ANLY482 AY2016-17 T2 Projects</font>]]
 +
</div>
 
<!------- End of Secondary Navigation Bar---->
 
<!------- End of Secondary Navigation Bar---->
  
 
<!-- Body -->
 
<!-- Body -->
−
==<div style="background: #ffffff; padding: 17px; line-height: 0.1em;  text-indent: 10px; font-size:17px; font-family: Helvetica;  border-left:8px solid #1b96fe"><font color= #000000><strong>Data</strong></font></div>==
+
==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em;  text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic';  border-left:8px solid #1b96fe; margin-bottom:5px"><font color= #000000><strong>Data Summary</strong></font></div>==
−
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
+
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px">
 +
With the understanding of our sponsor’s motivations, our team sets in motion the data wrangling process – one that encompasses data cleaning, transformation and integration to obtain a consolidated JMP data table used for further analysis. For this research study, we have obtained a year’s worth of data from 2016. It consists of information on invoices, call details, employees and customers – each of which described in the summary table below
 +
 +
<br />
 +
<center>
 +
<table style="margin:auto;; border:1px solid #000; width: 80%">
 +
  <tr style="background-color:#000">
 +
    <td style="border-right:1px solid #000;text-align:center;font-weight:bold;width:20%"><font color="#f2f4f4">File Name</font></td>
 +
    <td style="border-right:1px solid #000;text-align:center;font-weight:bold;width:60%"><font color="#f2f4f4">Description</font></td>
 +
    <td style="border-right:1px solid #000;text-align:center;font-weight:bold;width:20%"><font color="#f2f4f4">No. of Rows</font></td>
 +
  </tr>
 +
  <tr>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">Call Details</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:60%">Information on actual interaction between Sales Reps, Sale Targets for a Product Brand </td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">42915</td>
 +
  </tr>
 +
  <tr>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">Invoice Details</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:60%">Transactions of product purchases by Sales Targets</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">110372</td>
 +
  </tr>
 +
  <tr>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">Employee</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:60%">Information on employees and their teams - “Therapy Area” </td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">237</td>
 +
  </tr>
 +
  <tr>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">HCP</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:60%">Information on individual doctors</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">5871</td>
 +
  </tr>
 +
  <tr>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">HCO</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:60%">Information on clinics, organizations</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">4425</td>
 +
  </tr>
 +
</table>
 +
</center>
 +
</div>
 +
<!-- End Body --->
 +
 
 +
 
 +
<!-- Body -->
 +
==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em;  text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic';  border-left:8px solid #1b96fe; margin-bottom:5px"><font color= #000000><strong>Data Dictionary</strong></font></div>==
 +
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px">
 +
The data dictionary is available [https://docs.google.com/a/smu.edu.sg/document/d/17TYnpCpPC6bNzLZRglWHc83AfyzkjPMKdaQ-BkVIQMg/edit?usp=sharing here]
 
</div>
 
</div>
 
<!-- End Body --->
 
<!-- End Body --->

Latest revision as of 10:29, 21 April 2017

Kesmyjxlogo.png

HOME

ABOUT US

PROJECT OVERVIEW

ANALYSIS & FINDINGS

PROJECT MANAGEMENT

DOCUMENTATION

Overview

Data

Methodology

<< ANLY482 AY2016-17 T2 Projects

Data Summary

With the understanding of our sponsor’s motivations, our team sets in motion the data wrangling process – one that encompasses data cleaning, transformation and integration to obtain a consolidated JMP data table used for further analysis. For this research study, we have obtained a year’s worth of data from 2016. It consists of information on invoices, call details, employees and customers – each of which described in the summary table below


File Name Description No. of Rows
Call Details Information on actual interaction between Sales Reps, Sale Targets for a Product Brand 42915
Invoice Details Transactions of product purchases by Sales Targets 110372
Employee Information on employees and their teams - “Therapy Area” 237
HCP Information on individual doctors 5871
HCO Information on clinics, organizations 4425


Data Dictionary

The data dictionary is available here

Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY2016-17_T2_Group10_Project_Overview:_Data&oldid=15125’