Difference between revisions of "Uncovering Market-Insights for Charles & Keith: EDA 2"
Jump to navigation
Jump to search
Line 52: | Line 52: | ||
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. | 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%'' | + | "Conversion Rate = [(Order Quantity - Sales Quantity)/Order Quantity] X 100%'' |
Insights for which seasons have the higher or lower conversion has been pointed out so for 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. | Insights for which seasons have the higher or lower conversion has been pointed out so for 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. | ||
</div> | </div> |
Revision as of 19:08, 17 April 2016
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.
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%
Insights for which seasons have the higher or lower conversion has been pointed out so for 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.