Difference between revisions of "ANLY482 AY2017-18T2 Group32: Project Overview"
(18 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: | + | [[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- | + | [[ANLY482_AY2017-18T2_Group_32| <font face ="Avenir Next" color="#ffffff" >Home</font>]] |
| style="background:none;" width="1%" | | | style="background:none;" width="1%" | | ||
Line 34: | Line 38: | ||
{| width="100%" cellspacing="0" cellpadding="0" valign="top" | | {| width="100%" cellspacing="0" cellpadding="0" valign="top" | | ||
− | | 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: | + | | 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: | + | | 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="# | + | <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;"> | ||
− | + | 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="# | + | <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;"> | ||
− | + | 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? | ||
</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="# | + | <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 | + | 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> | ||
− | + | ||
− | |||
− | |||
− | |||
− | |||
</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="# | + | <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;"> | ||
− | |||
− | + | Future Analysis: | |
− | + | <br> | |
− | + | 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
Description | Data | Methodology |
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 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?
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.