Uncovering Market-Insights for Charles & Keith: EDA 2

From Analytics Practicum
Jump to navigation Jump to search
ANALYSIS.jpg
HOME   OVERVIEW   DATA PREPARATION   ANALYSIS   PROJECT MANAGEMENT   DOCUMENTATION

Due to the confidentiality of the data provided by our sponsor, we would be only showing the methods of analysis without the results. For authorised stakeholders, please refer to our report for more in-depth analysis with charts and descriptions.


TOOLS USED

EDA PHASE 1

EDA PHASE 2

CLUSTERING

MBA

AYE Tools Used
Conversion Rate for Bags and Shoes

We have drawn a dot diagram using Tableau to show the conversion rate of bags/shoes denoted by circle and the sales quantity denoted by x in 2015.

"Conversion Rate = [(Order Quantity - Sales Quantity)/Order Quantity] X 100%''

Observation for which seasons have the higher or lower conversion has been pointed out. This allows C&K to look into the issue of over/under stocking. Also, other dimensions such as class, subclass and materials are brought into the analysis as well.