Difference between revisions of "ANLY482 AY2016-17 T2 Group10 Project Overview: Data"

From Analytics Practicum
Jump to navigation Jump to search
 
(6 intermediate revisions by the same user not shown)
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 Summary</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; margin-bottom:5px"><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:
+
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
 +
 +
<br />
 
<center>
 
<center>
−
<table style="text-align:center; color: green;">
+
<table style="margin:auto;; border:1px solid #000; width: 80%">
−
{| class="wikitable" style="text-align:center;"  
+
  <tr style="background-color:#000">
−
|-
+
    <td style="border-right:1px solid #000;text-align:center;font-weight:bold;width:20%"><font color="#f2f4f4">File Name</font></td>
−
! File Name !! Description !! No. of Rows (Raw)
+
    <td style="border-right:1px solid #000;text-align:center;font-weight:bold;width:60%"><font color="#f2f4f4">Description</font></td>
−
|-
+
    <td style="border-right:1px solid #000;text-align:center;font-weight:bold;width:20%"><font color="#f2f4f4">No. of Rows</font></td>
−
| MCCP|| Stands for Multi-Channel Cycle Plan. Represents interactions between Sales Rep and Target for a Product in quarterly basis || 42915
+
  </tr>
−
|-
+
  <tr>
−
| Invoice Details|| Transactions of product purchases by Sales Targets|| 110372
+
    <td style="border-right:1px solid #000;text-align:center;width:20%">Call Details</td>
−
|-
+
    <td style="border-right:1px solid #000;text-align:center;width:60%">Information on actual interaction between Sales Reps, Sale Targets for a Product Brand </td>
−
| Product Segment|| An internal grading of Sales Target by past transactions|| 437412
+
    <td style="border-right:1px solid #000;text-align:center;width:20%">42915</td>
−
|-
+
  </tr>
−
| HCP|| Data on Sales Target Professionals|| 5871
+
  <tr>
−
|-
+
    <td style="border-right:1px solid #000;text-align:center;width:20%">Invoice Details</td>
−
| HCO|| Data on Sales Target Offices|| 4425
+
    <td style="border-right:1px solid #000;text-align:center;width:60%">Transactions of product purchases by Sales Targets</td>
−
|}
+
    <td style="border-right:1px solid #000;text-align:center;width:20%">110372</td>
 +
  </tr>
 +
  <tr>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">Employee</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:60%">Information on employees and their teams - “Therapy Area” </td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">237</td>
 +
  </tr>
 +
  <tr>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">HCP</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:60%">Information on individual doctors</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">5871</td>
 +
  </tr>
 +
  <tr>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">HCO</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:60%">Information on clinics, organizations</td>
 +
    <td style="border-right:1px solid #000;text-align:center;width:20%">4425</td>
 +
  </tr>
 
</table>
 
</table>
 
</center>
 
</center>
 +
</div>
 +
<!-- End 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; margin-bottom:5px"><font color= #000000><strong>Data Dictionary</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">
 +
The data dictionary is available [https://docs.google.com/a/smu.edu.sg/document/d/17TYnpCpPC6bNzLZRglWHc83AfyzkjPMKdaQ-BkVIQMg/edit?usp=sharing here]
 
</div>
 
</div>
 
<!-- End Body --->
 
<!-- End Body --->

Latest revision as of 10:29, 21 April 2017

Kesmyjxlogo.png

HOME

ABOUT US

PROJECT OVERVIEW

ANALYSIS & FINDINGS

PROJECT MANAGEMENT

DOCUMENTATION

Overview

Data

Methodology

<< ANLY482 AY2016-17 T2 Projects

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

Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY2016-17_T2_Group10_Project_Overview:_Data&oldid=15125’