Difference between revisions of "ANLY482 AY2016-17 T2 Group21 : EDA"

From Analytics Practicum
Jump to navigation Jump to search
(Added EDA)
 
Line 47: Line 47:
  
 
==<div style="background: #404041;font-weight: light; padding:0.3em; text-transform:uppercase;letter-spacing:0.1em;font-size:18px; font-family: 'Century Gothic'"><font color=#ffffff><center>Exploratory Data Analysis</center></font></div>==
 
==<div style="background: #404041;font-weight: light; padding:0.3em; text-transform:uppercase;letter-spacing:0.1em;font-size:18px; font-family: 'Century Gothic'"><font color=#ffffff><center>Exploratory Data Analysis</center></font></div>==
 +
[[File:dataa.png|800px]]
 +
 +
<hr>
 +
[[File:Toolss.png|800px]]
 +
<hr>
 +
 +
[[File:dataprep.png|800px]]
 +
 +
 +
[[File:orderss.png|800px]]
 +
 +
 +
[[File:productinfo.png|800px]]
 +
 +
 +
[[File:orderinfo.png|800px]]
 +
 +
 +
[[File:userinfo.png|800px]]
 +
 +
 +
[[File:scriptt.png|800px]]
 +
<hr>
 +
 +
[[File:challengess.png|800px]]
 +
 +
==<div style="background: #404041;font-weight: light; padding:0.3em; text-transform:uppercase;letter-spacing:0.1em;font-size:18px; font-family: 'Century Gothic'"><font color=#ffffff><center>Exploratory Data Analysis</center></font></div>==
 +
<!--/Body Start-->
 +
 +
[[File:uuser.png|500px]]
 +
 +
Our team brokedown Dressabelle's user base in three categories:
 +
 +
* Guest Customers (those that purchase without an account)
 +
 +
* Registered Customers (those that purchase with a registered account)
 +
 +
* Registered Users (those that have an account but has never purchased anything)
 +
 +
[[File:Userbreakdown.png|400px]]
 +
 +
<b>Findings:</b> ⅓ of total users do not make purchases
 +
 +
Our team weighted customers according to their contribution towards Dressabelle's revenue.
 +
 +
[[File:Customervalue.png|350px]]
 +
 +
 +
<b>Findings:</b>
 +
 +
1. Top 25% of most valuable customers gives 72.52% of revenue
 +
 +
2. Top customers on average orders 12 times more than bottom tier customer
 +
</div>
 +
 +
<hr>
 +
[[File:ugrowth.png|500px]]
 +
 +
[[File:userreg.png|500px]]
 +
<div>
 +
 +
<b>Findings:</b>
 +
 +
1. Huge growth in 2013-14
 +
 +
2. Large growth of non-buyers in 2016, possibility due to offline referral
 +
</div>
 +
 +
[[File:regbyweek.png|500px]]
 +
 +
<div><b>Findings:</b>
 +
 +
Huge spikes of customers on Sunday and Thursday, which corresponds to weekly collection launches
 +
</div>
 +
 +
 +
[[File:regbyhour.png|600px]]
 +
<div>
 +
 +
<b>Findings:</b>
 +
1. Customers influx during lunch hours and after dinner
 +
 +
2. Influx of customers during lunch is prominent during collection launch days
 +
</div>
 +
 +
<hr>
 +
[[File:urevenue.png|500px]]
 +
 +
[[File:revenue.png|700px]]
 +
 +
<div><b>Findings:</b>
 +
 +
1. Sales tends to peak in May
 +
 +
2. Sales pattern in 2016 did not follow the usual sales trend
 +
</div>
 +
 +
<hr>
 +
[[File:uorders.png|500px]]
 +
 +
[[File:orders.png|470px]]
 +
<div><b>Findings:</b>
 +
 +
1. Decrease in the average pricing of a product results in the increase in order size and overall revenue earned
 +
</div>
 +
 +
 +
[[File:ordersource.png|600px]]
 +
<div><b>Findings:</b>
 +
 +
1. Organic and referrals comprise of at least 54% of new customers
 +
 +
2. Email remains effective in generating repeated sales
 +
</div>
 +
 +
<div><b>Limitations:</b>
 +
 +
1. Accuracy of tracking
 +
 +
2. Tracking starts mid 2013
 +
</div>
 +
<hr>
 +
 +
[[File:uproducts.png|500px]]
 +
 +
[[File:products.png|370px]]
 +
<div><b>Findings:</b>
 +
 +
1. Dressabelle’s main offering is in the dress category of 63%
 +
 +
2. Tops are a far second
 +
</div>
 +
 +
[[File:bycategory.png|600px]]
 +
<div><b>Findings:</b>
 +
 +
1. For tops and outerwear, free sizing is significantly more prominent than the other categories
 +
 +
2. In general, sizes S & M are generally more popular than L
 +
</div>
 +
 +
<div><b>Limitations:</b>
 +
 +
Categories are not accurately defined as of now
 +
</div>
 +
 +
[[File:color.png|500px]]
 +
<div><b>Findings:</b>
 +
 +
1. Basic colors (Blue, White, Navy, Blue & Grey) prove the most popular
 +
 +
2. Black is by far the most popular colour
 +
</div>

Latest revision as of 17:28, 2 March 2017

PROJECTS

HOME

 

ABOUT US

 

PROJECT OVERVIEW

 

PROJECT FINDINGS

 

PROJECT MANAGEMENT

 

DOCUMENTATION

Exploratory Mid-Term Finals

Exploratory Data Analysis

Dataa.png

Toolss.png

Dataprep.png


Orderss.png


Productinfo.png


Orderinfo.png


Userinfo.png


Scriptt.png

Challengess.png

Exploratory Data Analysis

Uuser.png

Our team brokedown Dressabelle's user base in three categories:

  • Guest Customers (those that purchase without an account)
  • Registered Customers (those that purchase with a registered account)
  • Registered Users (those that have an account but has never purchased anything)

Userbreakdown.png

Findings: ⅓ of total users do not make purchases

Our team weighted customers according to their contribution towards Dressabelle's revenue.

Customervalue.png


Findings:

1. Top 25% of most valuable customers gives 72.52% of revenue

2. Top customers on average orders 12 times more than bottom tier customer

Ugrowth.png

Userreg.png

Findings:

1. Huge growth in 2013-14

2. Large growth of non-buyers in 2016, possibility due to offline referral

Regbyweek.png

Findings:

Huge spikes of customers on Sunday and Thursday, which corresponds to weekly collection launches


Regbyhour.png

Findings: 1. Customers influx during lunch hours and after dinner

2. Influx of customers during lunch is prominent during collection launch days

Urevenue.png

Revenue.png

Findings:

1. Sales tends to peak in May

2. Sales pattern in 2016 did not follow the usual sales trend

Uorders.png

Orders.png

Findings:

1. Decrease in the average pricing of a product results in the increase in order size and overall revenue earned


Ordersource.png

Findings:

1. Organic and referrals comprise of at least 54% of new customers

2. Email remains effective in generating repeated sales

Limitations:

1. Accuracy of tracking

2. Tracking starts mid 2013

Uproducts.png

Products.png

Findings:

1. Dressabelle’s main offering is in the dress category of 63%

2. Tops are a far second

Bycategory.png

Findings:

1. For tops and outerwear, free sizing is significantly more prominent than the other categories

2. In general, sizes S & M are generally more popular than L

Limitations:

Categories are not accurately defined as of now

Color.png

Findings:

1. Basic colors (Blue, White, Navy, Blue & Grey) prove the most popular

2. Black is by far the most popular colour

Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY2016-17_T2_Group21_:_EDA&oldid=14632’