Difference between revisions of "ANLY482 AY2016-17 T2 Group3: HOME/Interim"

From Analytics Practicum
Jump to navigation Jump to search
Line 42: Line 42:
 
<div style="height: 1em"></div>
 
<div style="height: 1em"></div>
 
<div><font face="Open Sans">
 
<div><font face="Open Sans">
Add text here!
+
 
 +
=== Overview ===
 +
==== Project Background & Motivation ====
 +
Vanitee was officially launched in May 2015, in an attempt to bridge the gap between customers and independent beauty professionals. Typically, beauty professionals that are listed on the platform are emerging and independent beauty artists. To put it simply, they are professionals who want to grow their brand and customer base. By providing such a platform, Vanitee is able to help them showcase what they do best.
 +
 +
However, this does not mean that there are no competitors. Competitors include brick and mortar shops in local neighbourhoods and even bigger beauty brands with chain stores such as Jean Yip Group. Even though these are physical stores, they still pose as a threat as customers can still choose to go to these stores instead of using Vanitee to engage a beauty professional. Hence, Vanitee does not want to stop at just providing a platform for these beauty professionals and for customers to engage them. Furthermore, with an increasing number of professionals and customers coming on board, evaluating their performance so far becomes much more imperative.
 +
 
 +
Firstly, to further the success of their application, Vanitee has to place emphasis on attracting new customers as well as retaining their existing customers. Many customers might have become dormant after just one booking. Hence, analysis can be done to find out why they have turned dormant and identify possible solutions to attract them to make the next booking.
 +
 +
Secondly, in response to these dormant customers, Vanitee currently has an extensive loyalty program (as shown in Figure 1) in place that offers customers credits, gems as well as campaign codes with every booking made. However, one issue they face is the lack of understanding of how consumers utilize these in-app resources. Also, they wish to understand the effectiveness of such a loyalty program in encouraging customers to make repeated bookings in the future.
 +
 
 +
<br/>
 +
[[File:V_Loyalty_Program.png|400px|center]]
 +
<div align="center"> Figure 1 - Vanitee’s current loyalty program </div>
 +
<br/>
 +
 
 +
==== Project Objectives ====
 +
Hence, by utilizing the data from their current application’s database, we would wish to discover meaningful and informative insights which will allow Vanitee to better retain their customers and beauty professionals and understand the effectiveness of their current loyalty program. To achieve the above mentioned, we have set the following objectives:
 +
 
 +
<u> Customers </u> <br/>
 +
* To determine the customer segmentation (different groups of customers) from the current booking patterns. Which customers are stagnant? Which customers are actively using the app?
 +
* To understand customers’ behaviour. When was the last time a customer used the app? How frequent does a customer use the app? How much does a customer spend on average?
 +
* To evaluate the effectiveness of using campaign codes to ensure customers repeat their bookings
 +
* To understand how customers are using credits and gems (refer to Figure 2), whether they are accumulating before use or using them in their next booking
 +
 
 +
<u> Beauty Professionals </u> <br/>
 +
=== Data Integration and Filtering ===
 +
==== Data Collection ====
 +
==== Extracted Tables ====
 +
<u>Bookings</u> <br/>
 +
<u>Campaigns</u> <br/>
 +
<u>Categories</u> <br/>
 +
<u>Users</u> <br/>
 +
<u>Customers</u> <br/>
 +
<u>Professionals</u> <br/>
 +
<u>Services</u> <br/>
 +
==== Challenges ====
 +
=== Data Cleaning and Exploration ===
 +
==== Issues ====
 +
==== Duplicate Values ====
 +
==== Missing Values ====
 +
==== Changes in Business Model ====
 +
==== Findings ====
 +
<u>Users, Customers & Professionals </u> <br/>
 +
<u>Bookings</u> <br/>
 +
<u>Services</u> <br/>
 +
<u>Campaigns</u> <br/>
 +
=== Revised Methodology ===
 +
==== Cluster Analysis ====
 +
==== Survival Analysis ====
 +
=== Revised Scope of Work ===
 +
=== Project Timeline ===
 +
=== Revised Work Plan ===
 +
 
 +
 
 +
 
 
</font></div>
 
</font></div>
  

Revision as of 18:51, 22 February 2017

V Logo.png


HOME   ABOUT US   PROJECT OVERVIEW   PROJECT FINDINGS   PROJECT MANAGEMENT   DOCUMENTATION   ALL PROJECTS



INTERIM PROGRESS

Overview

Project Background & Motivation

Vanitee was officially launched in May 2015, in an attempt to bridge the gap between customers and independent beauty professionals. Typically, beauty professionals that are listed on the platform are emerging and independent beauty artists. To put it simply, they are professionals who want to grow their brand and customer base. By providing such a platform, Vanitee is able to help them showcase what they do best.

However, this does not mean that there are no competitors. Competitors include brick and mortar shops in local neighbourhoods and even bigger beauty brands with chain stores such as Jean Yip Group. Even though these are physical stores, they still pose as a threat as customers can still choose to go to these stores instead of using Vanitee to engage a beauty professional. Hence, Vanitee does not want to stop at just providing a platform for these beauty professionals and for customers to engage them. Furthermore, with an increasing number of professionals and customers coming on board, evaluating their performance so far becomes much more imperative.

Firstly, to further the success of their application, Vanitee has to place emphasis on attracting new customers as well as retaining their existing customers. Many customers might have become dormant after just one booking. Hence, analysis can be done to find out why they have turned dormant and identify possible solutions to attract them to make the next booking.

Secondly, in response to these dormant customers, Vanitee currently has an extensive loyalty program (as shown in Figure 1) in place that offers customers credits, gems as well as campaign codes with every booking made. However, one issue they face is the lack of understanding of how consumers utilize these in-app resources. Also, they wish to understand the effectiveness of such a loyalty program in encouraging customers to make repeated bookings in the future.


V Loyalty Program.png
Figure 1 - Vanitee’s current loyalty program


Project Objectives

Hence, by utilizing the data from their current application’s database, we would wish to discover meaningful and informative insights which will allow Vanitee to better retain their customers and beauty professionals and understand the effectiveness of their current loyalty program. To achieve the above mentioned, we have set the following objectives:

Customers

  • To determine the customer segmentation (different groups of customers) from the current booking patterns. Which customers are stagnant? Which customers are actively using the app?
  • To understand customers’ behaviour. When was the last time a customer used the app? How frequent does a customer use the app? How much does a customer spend on average?
  • To evaluate the effectiveness of using campaign codes to ensure customers repeat their bookings
  • To understand how customers are using credits and gems (refer to Figure 2), whether they are accumulating before use or using them in their next booking

Beauty Professionals

Data Integration and Filtering

Data Collection

Extracted Tables

Bookings
Campaigns
Categories
Users
Customers
Professionals
Services

Challenges

Data Cleaning and Exploration

Issues

Duplicate Values

Missing Values

Changes in Business Model

Findings

Users, Customers & Professionals
Bookings
Services
Campaigns

Revised Methodology

Cluster Analysis

Survival Analysis

Revised Scope of Work

Project Timeline

Revised Work Plan