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

From Analytics Practicum
Jump to navigation Jump to search
 
(16 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>
  
Line 8: Line 12:
  
 
| style="padding:0.2em; font-size:130%; background-color:#000000; text-align:center; " width="5%" |
 
| style="padding:0.2em; font-size:130%; background-color:#000000; text-align:center; " width="5%" |
−
[[ANLY482_AY2017-18_T2_Group32 | <font face ="Avenir Next" color="#ffffff" >Home</font>]]
+
[[ANLY482_AY2017-18T2_Group_32| <font face ="Avenir Next" color="#ffffff" >Home</font>]]
  
 
| style="background:none;" width="1%" |
 
| style="background:none;" width="1%" |
Line 36: Line 40:
 
| style="padding: 0.25em; font-size: 90%; border-top: 1px solid #000000; border-left: 1px solid #000000; border-bottom: 1px solid #000000; text-align:center; background-color: #404040; width:33.3%" | [[ANLY482_AY2017-18T2_Group32: Project Overview| <font color="#ffffff ">Description</font>]]
 
| style="padding: 0.25em; font-size: 90%; border-top: 1px solid #000000; border-left: 1px solid #000000; border-bottom: 1px solid #000000; text-align:center; background-color: #404040; width:33.3%" | [[ANLY482_AY2017-18T2_Group32: Project Overview| <font color="#ffffff ">Description</font>]]
  
−
| style="padding: 0.25em; font-size: 90%; border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; text-align:center; background-color: none; width:33.3%" | [[ANLY482_AY2017-18T2_Group32: Project Overview/ Data | <font color="#f6a228">Data</font>]]
+
| style="padding: 0.25em; font-size: 90%; border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; text-align:center; background-color: none; width:33.3%" | [[ANLY482_AY2017-18T2_Group32: Project Overview/Data | <font color="#f6a228">Data</font>]]
  
−
| style="padding: 0.25em; font-size: 90%; border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; text-align:center; background-color: none; width:33.3%" | [[ANLY482_AY2017-18T2_Group32: Project Overview/ Methodology | <font color="#f6a228">Methodology</font>]]
+
| style="padding: 0.25em; font-size: 90%; border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; text-align:center; background-color: none; width:33.3%" | [[ANLY482_AY2017-18T2_Group32: Project Overview/Methodology | <font color="#f6a228">Methodology</font>]]
 
|}
 
|}
 
<br>
 
<br>
  
 
<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">Business Problem</font>
+
<div style="background: #f6a228; padding: 12px; font-family: Avenir Next; font-size: 18px; font-weight: bold; line-height: 1em;"><font color="#ffffff">Project Motivation</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;">
  
−
Despite the influx of cash, Shopee's profitability remains questionable due to the high marketing costs incurred in expanding consumer base. Hence there is a need to for Shopee to strengthen its market position against many other e-commerce competitors and examine ways for the company to cut costs and maximize their resource for business longevity.
+
With close to 100 brands of different medications under their belt and clients from the various medical sectors, it is an enormous challenge for anyone to monitor the performance of the sales of these products.  
  
 +
Our sponsor wishes to be able to view and analyze the performance of her sales teams in the form of a dashboard on Qliksense. It will be split into 2 different sections. One section of the visualisation will be for sales representatives to see their account or brands and the invoices in 2015 to 2018. The other section will be for the business units directors and the sales managers in order to provide a succinct business report to upper management.
 
</div>
 
</div>
 
<br>
 
<br>
  
 
<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">Project Motivation</font>
+
<div style="background: #f6a228; padding: 12px; font-family: Avenir Next; font-size: 18px; font-weight: bold; line-height: 1em;"><font color="#ffffff">Business Problem</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;">
  
−
It is noted that Shopee generates less than 15% of the revenue of Sea Ltd, yet takes up 78% of the company’s total marketing and sales expense. This could be attributed to price being the main determining factor when customers engage in online purchase. Thus, e-commerce companies like Shopee have to resort to discounts to lure new customers and maintain current ones, further reducing the already low profit margin.
+
Business question that we were working on, monthly business review of the following:
 +
 
 +
1) How does the business perform?
  
−
In addition, an article from Harvard Business Review reported that it is 5 to 25 times more expensive to keep an existing customer than to acquire a new one. In order to become profitable in the long run, it is imperative for Shopee to distinguish themselves not just through price competitiveness, but also through improving customer satisfaction to entice them to continue using the service.
+
* Did we meet our renewal target rate of 95%?
 +
* New account acquisition target rate of 5%?
 +
* Recover lost account target rate of 30% target?
  
 
</div>
 
</div>
Line 67: Line 76:
  
 
<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">Project Objective</font>
+
<div style="background: #f6a228; padding: 12px; font-family: Avenir Next; font-size: 18px; font-weight: bold; line-height: 1em;"><font color="#ffffff">Project Objective</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;">
  
−
This project aims to provide clarity of what factors are more (or less) important in optimizing Shopee’s improvement efforts. Identifying these factors will play a key role in our prescriptive analytics to provide Shopee with key business insights on 1) how to enhance customer satisfaction and 2) improve their ability to retain existing customers. The project deliverables include:
+
Hence, this project aims to help the business better understand how the business has performed using an interactive data visualization dashboard.
 +
 
 +
This project aims to answer the the "Who" and "What" - who shall be our main target audience for our sales efforts and what kind of drugs should we offer them?
 +
 
 +
The 3 different scenarios, namely:
 +
* I. Renewal rate [% of customers who have remained from 2017]
 +
* II. Acquisition rate [Amount$ sales value of newly acquired customers in the year 2018 who has never bought from Pharma G, as a % to total Amount$ sales value by all customers]
 +
* III. Winning back lost accounts [Amount$ sales value of customers in the year 2018, who once bought in 2016 but not 2017]
 +
 
 +
We can see a relationship between each scenario and the brands of drugs sold that helps Pharmaceutical Company G achieves their respective targets. In each scenario, the brands of drugs and target audience will be different.  
 
<br>
 
<br>
−
i. Industry best practices for driving customer satisfaction and loyalty
+
 
−
<br>
 
−
ii. Quantified key drivers of customer satisfaction (specific to Shopee)
 
−
<br>
 
−
iii. Recommendations on how to improve customer satisfaction
 
  
 
</div>
 
</div>
Line 84: Line 98:
  
 
<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">Scope of Work</font>
+
<div style="background: #f6a228; padding: 12px; font-family: Avenir Next; font-size: 18px; font-weight: bold; line-height: 1em;"><font color="#ffffff">Scope of Work</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;">
  
−
We have identified the need to go beyond pricing strategies to maximize profit. There is a need for Shopee to focus on ensuring consumers’ satisfaction to encourage returning patronage. It will focus on analyzing Shopee’s past interactions with consumers to improve overall customers’ experience. We will adopt a cradle-to-grave approach by analyzing customers’ interaction with Shopee throughout their time on the site.
 
  
−
We will:  
+
Future Analysis:
−
# identify factors that will severely influence a customer’s experience when shopping on Shopee, and
+
<br>
−
# suggest recommendations on how Shopee can improve their standard operating procedures to ensure customers’ satisfaction to retain their customers.
+
Before proceeding to the next KPI, it is vital that we verify with our client regarding the validity of our final dataset. Once we obtain the permission to continue, we will able to commence on the next steps of our project as depicted in the chart below.
 +
 
 +
[[File:ScopeOfWork 1.png | 600px | center]]
  
 
</div>
 
</div>
 
<br>
 
<br>

Latest revision as of 00:01, 16 April 2018

Return to ANLY482 AY2017-18 Home Page


Pharma G Logo.png

Home

About Us

Project Overview

Project Insights

Project Management

Documentation

Description Data Methodology


Project Motivation

With close to 100 brands of different medications under their belt and clients from the various medical sectors, it is an enormous challenge for anyone to monitor the performance of the sales of these products.

Our sponsor wishes to be able to view and analyze the performance of her sales teams in the form of a dashboard on Qliksense. It will be split into 2 different sections. One section of the visualisation will be for sales representatives to see their account or brands and the invoices in 2015 to 2018. The other section will be for the business units directors and the sales managers in order to provide a succinct business report to upper management.


Business Problem

Business question that we were working on, monthly business review of the following:

1) How does the business perform?

  • Did we meet our renewal target rate of 95%?
  • New account acquisition target rate of 5%?
  • Recover lost account target rate of 30% target?


Project Objective

Hence, this project aims to help the business better understand how the business has performed using an interactive data visualization dashboard.

This project aims to answer the the "Who" and "What" - who shall be our main target audience for our sales efforts and what kind of drugs should we offer them?

The 3 different scenarios, namely:

  • I. Renewal rate [% of customers who have remained from 2017]
  • II. Acquisition rate [Amount$ sales value of newly acquired customers in the year 2018 who has never bought from Pharma G, as a % to total Amount$ sales value by all customers]
  • III. Winning back lost accounts [Amount$ sales value of customers in the year 2018, who once bought in 2016 but not 2017]

We can see a relationship between each scenario and the brands of drugs sold that helps Pharmaceutical Company G achieves their respective targets. In each scenario, the brands of drugs and target audience will be different.



Scope of Work


Future Analysis:
Before proceeding to the next KPI, it is vital that we verify with our client regarding the validity of our final dataset. Once we obtain the permission to continue, we will able to commence on the next steps of our project as depicted in the chart below.

ScopeOfWork 1.png


Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY2017-18T2_Group32:_Project_Overview&oldid=24496’