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 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"><font color= #000000><strong>Data</strong></font></div>== | + | ==<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"><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"> | <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 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: | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! 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 | ||
+ | |} | ||
</div> | </div> | ||
<!-- End Body ---> | <!-- End Body ---> |
Revision as of 17:10, 21 February 2017
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 |