Difference between revisions of "ANLY482 AY2016-17 T2 Group19 Methodology"

From Analytics Practicum
Jump to navigation Jump to search
Line 7: Line 7:
 
<!--Navigation-->
 
<!--Navigation-->
 
<center>  
 
<center>  
{| style="border-collapse: separate; border-spacing: 0; font-size:13px; font-family: Trajan Pro; border-width: 1px; border-radius: 7px; border-style: solid; border-color: #ffffff; padding: 0;  height: 30px;" width="100%"
+
{| style="border-collapse: separate; border-spacing: 0; font-size:13px; font-family: Trajan Pro; border-width: 0px; border-radius: 0px; border-style: solid; border-color: #ffffff; padding: 0;  height: 0px;" width="100%"
 
|-
 
|-
  
Line 14: Line 14:
 
[[ANLY482_AY2016-17_T2_Group19|<font color="#000000"><b>OVERVIEW</b></font>]]
 
[[ANLY482_AY2016-17_T2_Group19|<font color="#000000"><b>OVERVIEW</b></font>]]
  
! style="border-style: none; border-width: 0 1px 1px 0;  border-left:2px solid #a4a4a6; background-color:#ffffff"|  
+
! style="border-style: none; border-width: 0 1px 1px 0;  border-left:0px solid #a4a4a6; background-color:#ffffff"|  
 
[[File:Protege_data.svg|40px|link= ANLY482_AY2016-17_T2_Group19_Data ]] &nbsp;
 
[[File:Protege_data.svg|40px|link= ANLY482_AY2016-17_T2_Group19_Data ]] &nbsp;
 
[[ANLY482_AY2016-17_T2_Group19_Data| <font color="#000000"><b>DATA</b></font>]]
 
[[ANLY482_AY2016-17_T2_Group19_Data| <font color="#000000"><b>DATA</b></font>]]
  
! style="border-style: none; border-width: 0 1px 1px 0; border-left:2px solid #a4a4a6; background-color:#ffffff"|  
+
! style="border-style: none; border-width: 0 1px 1px 0; border-left:0px solid #a4a4a6; background-color:#ffffff"|  
 
[[File:Protege_Methods.svg|40px|link= ANLY482_AY2016-17_T2_Group19_Methodology ]] &nbsp;
 
[[File:Protege_Methods.svg|40px|link= ANLY482_AY2016-17_T2_Group19_Methodology ]] &nbsp;
[[ANLY482_AY2016-17_T2_Group19_Methodology|<font color="#a1212e"><b>METHODOLOGY</b></font>]]
+
[[ANLY482_AY2016-17_T2_Group19_Methodology|<font color="#a1212e"><b>METHODOLOGY & ANALYSIS</b></font>]]
  
! style="border-style: none; border-width: 0 1px 1px 0; border-left:2px solid #a4a4a6; background-color:#ffffff"|
+
! style="border-style: none; border-width: 0 1px 1px 0;  border-left:0px solid #a4a4a6; background-color:#ffffff"|  
[[File:Protege_Analysis.svg|40px|link= ANLY482_AY2016-17_T2_Group19_Analysis ]] &nbsp;
 
[[ANLY482_AY2016-17_T2_Group19_Analysis| <font color="#000000"><b>ANALYSIS</b></font>]]
 
 
 
! style="border-style: none; border-width: 0 1px 1px 0;  border-left:2px solid #a4a4a6; background-color:#ffffff"|  
 
 
[[File:Protegemaster-03.svg|40px|link= ANLY482_AY2016-17_T2_Group19_Findings ]] &nbsp;
 
[[File:Protegemaster-03.svg|40px|link= ANLY482_AY2016-17_T2_Group19_Findings ]] &nbsp;
 
[[ANLY482_AY2016-17_T2_Group19_Findings| <font color="#000000"><b>FINDINGS</b></font>]]
 
[[ANLY482_AY2016-17_T2_Group19_Findings| <font color="#000000"><b>FINDINGS</b></font>]]
  
! style="border-style: none; border-width: 0 1px 1px 0; border-left:2px solid #a4a4a6; background-color:#ffffff"|  
+
! style="border-style: none; border-width: 0 1px 1px 0; border-left:0px solid #a4a4a6; background-color:#ffffff"|  
 
[[File:Protege_poster.svg|40px|link= ANLY482_AY2016-17_T2_Group19_Poster ]] &nbsp;
 
[[File:Protege_poster.svg|40px|link= ANLY482_AY2016-17_T2_Group19_Poster ]] &nbsp;
[[ANLY482_AY2016-17_T2_Group19_Poster| <font color="#000000"><b>POSTER</b></font>]]
+
[[ANLY482_AY2016-17_T2_Group19_Documentation| <font color="#000000"><b>DOCUMENTATION</b></font>]]
  
 +
! style="border-style: none; border-width: 0 1px 1px 0; border-left:0px solid #a4a4a6; background-color:#ffffff"|
 +
&nbsp;
 +
[[ANLY482_AY2016-17_Term_2| <font color="#000000"><b>BACK TO COURSE</b></font>]]
 
|}
 
|}
 
</center>
 
</center>

Revision as of 15:13, 27 February 2017



Protegelogo-01.svg

Protege overview.svg   OVERVIEW

Protege data.svg   DATA

Protege Methods.svg   METHODOLOGY & ANALYSIS

Protegemaster-03.svg   FINDINGS

Protege poster.svg   DOCUMENTATION

  BACK TO COURSE


Methodology

Phase 1: Evaluation of past data, data cleaning, qualitative research in key pharmaceutical events over the past 3 years

Data would first be processed and current and past performances would be evaluated based on sales performances over the past 3 years from various perspectives. This would be carried out through a combination of time series analysis of purchase baskets of at the granular individual customer level as well at the more aggregate customer segment level with special focus on the less researched segments of non-chain pharmacies, general practices, and specialists. In this phase, an open-ended approach will be taken and hence, data exploration goals are not limited to the above mentioned.

Phase 2: Identification of key environmental variables, stress events, and trends

Through this evaluation, key environmental variables that influence sales as well as responses to stress events (shock events such as crises) would be identified. Sales could then be further be segmented into expected sales and unexpected sales and separately analysed. This is inspired by the application of capital adequacy concepts in the form of expected losses and unexpected losses and would translate into expected sales that deviates from the mean sales level, and unexpected sales. This would allow the company to make more informed decisions about sales projections.

In addition, this analysis also aims to identify areas of potential optimisation in the form of human resource management (setting sales targets and turnover mitigation strategies) to explore areas where there have been significant trends in market basket change so as to identify potential opportunities in product placement.

Phase 3: Dashboard development

Given the narrowed focus, the next phase of the project would be to develop a visual analytics dashboard using R. This is done with continuity in mind as this project will also serve as pilot efforts into analytics for company Z.


Overall Thought-Process

The following is a planned process flow of actions to be taken starting from the collection of the raw data:

ThoughtProcess.png