ANLY482 AY2016-17 T2 Group10 Project Overview: Data
Jump to navigation
Jump to search
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
