Difference between revisions of "ANLY482 AY2016-17 T2 Group10 Project Overview: Data"
Jump to navigation
Jump to search
Jxsim.2013 (talk | contribs) |
Jxsim.2013 (talk | contribs) |
||
(10 intermediate revisions by the same user not shown) | |||
Line 13: | Line 13: | ||
| 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" | | | 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="#fff"><strong> | + | [[ANLY482_AY2016-17_T2_Group10_Project_Overview|<font color="#fff"><strong>PROJECT OVERVIEW</strong></font>]] |
| 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" | | | 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" | | ||
Line 46: | Line 46: | ||
<!-- 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 Summary</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"> |
− | + | 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> | ||
<!-- End Body ---> | <!-- End Body ---> |
Latest revision as of 10:29, 21 April 2017
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