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 87: | Line 87: | ||
</div> | </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