Difference between revisions of "ANLY482 AY2017-18T2 Group32: Project Insights"

From Analytics Practicum
Jump to navigation Jump to search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
<div align="right">
 +
[[ANLY482_AY2017-18_Term_2|<font color="#dd672e" font-family:helvetica><b>Return to ANLY482 AY2017-18 Home Page</b></font>]]
 +
 +
 
<center>
 
<center>
[[File:Shopee logo.jpg|400px|center]]
+
[[File:Pharma G Logo.png|300px]]
 
</center>
 
</center>
 +
 
<!--Main Navigation-->
 
<!--Main Navigation-->
 
<center>
 
<center>
Line 34: Line 39:
  
 
<div align="left">
 
<div align="left">
<div style="background: #f6a228; padding: 12px; font-family: Avenir Next; font-size: 18px; font-weight: bold; line-height: 1em;"><font color="#00313c">Findings</font>
+
<div style="background: #f6a228; padding: 12px; font-family: Avenir Next; font-size: 18px; font-weight: bold; line-height: 1em;"><font color="#ffffff">Findings</font>
 
</div>
 
</div>
  
 
<div style="background: #FFFFFF;border-style:solid; border-top:0px; border-width: 2px; border-color: #000000; padding: 1em; text-align: justify;">
 
<div style="background: #FFFFFF;border-style:solid; border-top:0px; border-width: 2px; border-color: #000000; padding: 1em; text-align: justify;">
  
Stay tuned in this space as we update our progress!
+
We have completed our analysis for the first KPI. The following calculation was used to obtain the renewal rate for TCE products:
 +
 
 +
[[File:Insights_1.png | 600px | center]]
 +
 
 +
Based on our calculations, current renewal rate for GSK is at 47%, which is quite far away from their target of 95%. In order to boost the renewal rate, we would recommend the sales team at GSk to focus on these three areas:
 +
 
 +
=====i.Big Public Hospitals =====
 +
Our EDA has revealed that GSK’s top three customers are Changi General Hospital, NUS Hospital and Tan Tock Seng Hospital. It is imperative that the sales team strive to focus sales on customer like the latter two who have made lesser purchase from GSK in 2017 as compared to 2016 in order to prevent them from approaching GSK’s competitors in 2018.
 +
 
 +
=====ii.Best-selling drugs =====
 +
The sales team should focus on pushing for the top three selling products namely: Keppra, Zeffix and Hepsera as they bring in significantly more revenue. This is especially true for Keppra which is able to bring in more than 3x sales revenue than the second most popular item.
 +
 
 +
=====iii.Fast growing clinics =====
 +
Other than big public hospitals, the sales team should keep an eye for fast growing clinics and private medical facilities. Our top three recommendations are : Joy Clinic & Surgery, Parkway & Shenton Pte Ltd ( Woodlands MRT) and Ban Kok Clinic due to their high growth in purchasing in 2017 as compared to 2016.
 +
 
 +
[[File:Insights_2.png | 600px | center]]
 +
 
 +
 
 +
 
 +
 
 +
 
  
 
</div>
 
</div>
 
<br>
 
<br>

Latest revision as of 23:44, 25 February 2018

Return to ANLY482 AY2017-18 Home Page


Pharma G Logo.png

Home

About Us

Project Overview

Project Insights

Project Management

Documentation


Findings

We have completed our analysis for the first KPI. The following calculation was used to obtain the renewal rate for TCE products:

Insights 1.png

Based on our calculations, current renewal rate for GSK is at 47%, which is quite far away from their target of 95%. In order to boost the renewal rate, we would recommend the sales team at GSk to focus on these three areas:

i.Big Public Hospitals

Our EDA has revealed that GSK’s top three customers are Changi General Hospital, NUS Hospital and Tan Tock Seng Hospital. It is imperative that the sales team strive to focus sales on customer like the latter two who have made lesser purchase from GSK in 2017 as compared to 2016 in order to prevent them from approaching GSK’s competitors in 2018.

ii.Best-selling drugs

The sales team should focus on pushing for the top three selling products namely: Keppra, Zeffix and Hepsera as they bring in significantly more revenue. This is especially true for Keppra which is able to bring in more than 3x sales revenue than the second most popular item.

iii.Fast growing clinics

Other than big public hospitals, the sales team should keep an eye for fast growing clinics and private medical facilities. Our top three recommendations are : Joy Clinic & Surgery, Parkway & Shenton Pte Ltd ( Woodlands MRT) and Ban Kok Clinic due to their high growth in purchasing in 2017 as compared to 2016.

Insights 2.png