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 49: | Line 49: | ||
<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: | 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: | ||
| + | <br /> | ||
<center> | <center> | ||
| − | <table style="text-align:center; | + | <table style="margin:auto;; border:1px solid #7fcdbb; width: 80%"> |
| − | + | <tr style="background-color:#7fcdbb"> | |
| − | + | <td style="border-right:1px solid #7fcdbb;text-align:center;font-weight:bold;width:20%"><font color="#f2f4f4">File Name</font></td> | |
| − | + | <td style="border-right:1px solid #7fcdbb;text-align:center;font-weight:bold;width:60%"><font color="#f2f4f4">Description</font></td> | |
| − | + | <td style="border-right:1px solid #7fcdbb;text-align:center;font-weight:bold;width:20%"><font color="#f2f4f4">No. of Rows</font></td> | |
| − | + | </tr> | |
| − | + | <tr> | |
| − | + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">MCCP</td> | |
| − | + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:60%">Stands for Multi-Channel Cycle Plan. Represents interactions between Sales Rep and Target for a Product in quarterly basis</td> | |
| − | + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">42915</td> | |
| − | + | </tr> | |
| − | + | <tr> | |
| − | + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">Invoice Details</td> | |
| − | + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:60%">Transactions of product purchases by Sales Targets</td> | |
| − | + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">110372</td> | |
| + | </tr> | ||
| + | <tr> | ||
| + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">Product Segment</td> | ||
| + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:60%">An internal grading of Sales Target by past transactions</td> | ||
| + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">437412</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">HCP</td> | ||
| + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:60%">Data on Sales Target Professionals</td> | ||
| + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">5871</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">HCO</td> | ||
| + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:60%">Data on Sales Target Offices</td> | ||
| + | <td style="border-right:1px solid #7fcdbb;text-align:center;width:20%">4425</td> | ||
| + | </tr> | ||
</table> | </table> | ||
</center> | </center> | ||
</div> | </div> | ||
<!-- End Body ---> | <!-- End Body ---> | ||
Revision as of 17:37, 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 |
| 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 |
