Difference between revisions of "Uncovering Market-Insights for Charles & Keith: Analysis"

From Analytics Practicum
Jump to navigation Jump to search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<center>
+
<div style=background:#B1B4C3 border:#B1B4C3>
[[File:CKBANNER4.png]]
+
[[Image:ANALYSIS.jpg|800px|center]]
</center>
+
</div>
  
 
<!--Banner-->
 
<!--Banner-->
Line 24: Line 24:
 
|}
 
|}
  
Due to the confidentiality of the data provided by our sponsor, we would be only showing the methods of analysis without the results. Our report will comprise more in-depth analysis with charts and descriptions. Please refer to our report for more details.
+
''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.''
  
<div style="border-style: solid solid none; border-color: #35383c; border-width: 1px 1px; padding: 5px; font-size: 120%; font-weight: bold; background-color: #{{LibreOfficeColor2}}; color: #{{LibreOfficeColor3}}; border-radius: 3px 3px 0 0;">Summary Statistics for C&K in China </div>
 
<div style="border: 1px solid #35383c; padding: 15px 15px 20px; border-radius: 0 0 3px 3px;">
 
  
Summary statistics have been generated to show the growth in numbers throughout the 3 years, indicating its general performance. The indicators used are
+
<center>
are the net price, number of transactions, total sum of transactions and the number of C&K stores opened in various regions from 2013 to 2015. 
+
{| style="background-color:#ffffff ; margin: 3px 11px 3px 11px;" width="80%"|
 +
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-top:solid #f5f5f5; background-color: #fff" width="200px" |
 +
[[Uncovering Market-Insights for Charles & Keith: Analysis|<font color="#3c3c3c"><strong>TOOLS USED</strong></font>]]
  
Also, we have created a line graph of C&K's total monthly net revenue throughout these 3 years so to indicate which are the peaks and lulls (which are the most profitable month). We also analysis its possible justifications and also calculated its monthly growth rate, maximum and minimum and average to show its current performance.
+
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" | 
</div>
+
[[Uncovering Market-Insights for Charles & Keith: EDA 1|<font color="#3c3c3c"><strong>EDA PHASE 1 </strong></font>]]
  
 +
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" | 
 +
[[Uncovering Market-Insights for Charles & Keith: EDA 2|<font color="#3c3c3c"><strong>EDA PHASE 2</strong></font>]]
  
<div style="border-style: solid solid none; border-color: #35383c; border-width: 1px 1px; padding: 5px; font-size: 120%; font-weight: bold; background-color: #{{LibreOfficeColor2}}; color: #{{LibreOfficeColor3}}; border-radius: 3px 3px 0 0;">Overall Sales Revenue and Quantity Trend by China's Regions </div>
+
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" | 
<div style="border: 1px solid #35383c; padding: 15px 15px 20px; border-radius: 0 0 3px 3px;">
+
[[Uncovering Market-Insights for Charles & Keith: K-Means Clustering|<font color="#3c3c3c"><strong>CLUSTERING</strong></font>]]
Next, we dived in to analyse its performance based on China's specific regions and explore further to find possible trends and insights that aid business decisions.
 
  
A pareto chart with its cumulative total percentage of sales has been generated to identity the region contributed to the highest revenue and where the main bulk of sales comes from.
+
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" | 
 +
[[Uncovering Market-Insights for Charles & Keith: MBA|<font color="#3c3c3c"><strong>MBA</strong></font>]]
 +
|}
 +
</center>
  
Also, a line-bar chart of the revenue created to visualise the changes of net revenue in each region and the changes in number of stores within the 3 years. The high and low profitable regions have been identified. Regions that have inconsistent growth are highlighted as well. The comparision with net revenue and number of stores combined in a chart is to easily see if the increase in net revenue is due to the increase in number of stores or otherwise. The chart can also aid in understanding the possible reasons of the volality of the growth or decline in numbers.
+
[[Image:AYEToolsUsed.jpg|900px|center|AYE Tools Used]]
 
+
[[Image:AYEToolsDescription.png|center|AYE Tools Description]]
Two ranking charts are generated to show the regional ranking based on on overall net revenue and average overall net revenue per store respectively. Anomalities and consistent performing regions are highlighted.
 
</div>
 
 
 
 
 
<div style="border-style: solid solid none; border-color: #35383c; border-width: 1px 1px; padding: 5px; font-size: 120%; font-weight: bold; background-color: #{{LibreOfficeColor2}}; color: #{{LibreOfficeColor3}}; border-radius: 3px 3px 0 0;">Overall Sales Revenue and Quantity Trend by China's Stores </div>
 
<div style="border: 1px solid #35383c; padding: 15px 15px 20px; border-radius: 0 0 3px 3px;">
 
 
 
</div>
 
 
 
 
 
<div style="border-style: solid solid none; border-color: #35383c; border-width: 1px 1px; padding: 5px; font-size: 120%; font-weight: bold; background-color: #{{LibreOfficeColor2}}; color: #{{LibreOfficeColor3}}; border-radius: 3px 3px 0 0;">Consumer Preferences by Product Categories, Class and Subclass</div>
 
<div style="border: 1px solid #35383c; padding: 15px 15px 20px; border-radius: 0 0 3px 3px;">
 
 
 
</div>
 
 
 
 
 
<div style="border-style: solid solid none; border-color: #35383c; border-width: 1px 1px; padding: 5px; font-size: 120%; font-weight: bold; background-color: #{{LibreOfficeColor2}}; color: #{{LibreOfficeColor3}}; border-radius: 3px 3px 0 0;">Consumer Preferences by Specifics</div>
 
<div style="border: 1px solid #35383c; padding: 15px 15px 20px; border-radius: 0 0 3px 3px;">
 
A horizontal bar chart is created to show the number of sales quantities purchased in 2015 for all the product types, based on the colours. This is so to identify the China's consumer preferences in colour. Top 10 colours have been filtered out. The top 2 product categories have been further analyse to see the preferences in colour with bar charts as well.  
 
 
 
</div>
 

Latest revision as of 18:53, 17 April 2016

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
AYE Tools Description