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) |
||
| Line 52: | Line 52: | ||
<br /> | <br /> | ||
<center> | <center> | ||
| − | <table style="margin:auto;; border:1px solid # | + | <table style="margin:auto;; border:1px solid #000; width: 80%"> |
| − | <tr style="background-color:# | + | <tr style="background-color:#000"> |
| − | <td style="border-right:1px solid # | + | <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 # | + | <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 # | + | <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> | ||
<tr> | <tr> | ||
| − | <td style="border-right:1px solid # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">Call Details</td> |
| − | <td style="border-right:1px solid # | + | <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 # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">42915</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td style="border-right:1px solid # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">Invoice Details</td> |
| − | <td style="border-right:1px solid # | + | <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 # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">110372</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td style="border-right:1px solid # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">Employee</td> |
| − | <td style="border-right:1px solid # | + | <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 # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">237</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td style="border-right:1px solid # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">HCP</td> |
| − | <td style="border-right:1px solid # | + | <td style="border-right:1px solid #000;text-align:center;width:60%">Information on individual doctors</td> |
| − | <td style="border-right:1px solid # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">5871</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td style="border-right:1px solid # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">HCO</td> |
| − | <td style="border-right:1px solid # | + | <td style="border-right:1px solid #000;text-align:center;width:60%">Information on clinics, organizations</td> |
| − | <td style="border-right:1px solid # | + | <td style="border-right:1px solid #000;text-align:center;width:20%">4425</td> |
</tr> | </tr> | ||
</table> | </table> | ||
Revision as of 12:36, 15 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
