ANLY482 AY2016-17 T2 Group10 Project Overview: Data
Revision as of 17:10, 21 February 2017 by Jxsim.2013 (talk | contribs)
Data Summary
The datasets given are in the 12 Excel files, consisting of data from employee, sales target, invoices, calls and interactions between sales rep and target. All datasets are from Year 2016, which potentially may restrict pattern analysis across time. A summary of datasets that we will be using is as follows:
File Name | Description | No. of Rows (Raw) |
---|---|---|
MCCP | Stands for Multi-Channel Cycle Plan. Represents interactions between Sales Rep and Target for a Product in quarterly basis | 42915 |
Invoice Details | Transactions of product purchases by Sales Targets | 110372 |
Product Segment | An internal grading of Sales Target by past transactions | 437412 |
HCP | Data on Sales Target Professionals | 5871 |
HCO | Data on Sales Target Offices | 4425 |