View source for ANLY482 AY2017-18 T2 Group15 Project Overview Version 1


<font face="Helvetica">
{| style="background-color:#FFFFFF; color:#ffcc16 padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |

| style="padding:0.3em; font-family:Arimo; font-size:110%; border-bottom:4px solid #aaaaaa; border-top:4px solid #aaaaaa; background:#ffcc16; text-align:center;" width="10%" | 
[[ANLY482_AY2017-18_T2_Group 15 |<font face ="Helvetica" color="#3f3d3d"><strong>HOME</strong></font>]] 

| style="padding:0.3em; font-family:Arimo; font-size:110%; border-bottom:4px solid #aaaaaa; border-top:4px solid #aaaaaa; background:#d8d8d8; text-align:center;" width="10%" |  
[[ANLY482_AY2017-18_T2_Group15_Project_Overview|<font face ="Helvetica" color="#3f3d3d"><strong> PROJECT OVERVIEW</strong></font>]]

| style="padding:0.3em; font-family:Arimo; font-size:110%; border-bottom:4px solid #aaaaaa; border-top:4px solid #aaaaaa; background:#ffcc16; text-align:center;" width="10%" |
[[ANLY482_AY2017-18_T2_Group15_Data_Analysis|<font face ="Helvetica" color="#3f3d3d"><strong> DATA ANALYSIS</strong></font>]]

| style="padding:0.3em; font-family:Arimo; font-size:110%; border-bottom:4px solid #aaaaaa; border-top:4px solid #aaaaaa; background:#ffcc16; text-align:center;" width="10%" |
[[ANLY482_AY2017-18_T2_Group15_Documentation|<font  face ="Helvetica" color="#3f3d3d"><strong> DOCUMENTATION</strong></font>]]

| style="padding:0.3em; font-family:Arimo; font-size:110%; border-bottom:4px solid #aaaaaa; border-top:4px solid #aaaaaa; background:#ffcc16; text-align:center;" width="10%" |
[[ANLY482_AY2017-18_T2_Group15_Recommendations|<font  face ="Helvetica" color="#3f3d3d"><strong> RECOMMENDATIONS</strong></font>]]

| style="padding:0.3em; font-family:Helvetica; font-size:110%; border-bottom:4px solid #aaaaaa; border-top:4px solid #aaaaaa; background:#ffcc16; text-align:center;" width="10%" |
[[ANLY482_AY2017-18_T2_Group15_About_group|<font  face ="Helvetica" color="#3f3d3d"><strong>ABOUT US </strong></font>]]

| style="padding:0.3em; font-family:Helvetica; font-size:110%; border-bottom:4px solid #aaaaaa; border-top:4px solid #aaaaaa; background:#ffcc16; text-align:center;" width="10%" |
[[ANLY482_AY2017-18_Term_2|<font  face ="Helvetica" color="#3f3d3d"><strong>BACK TO MAIN ANLY82 </strong></font>]]

|}


<!--Sub Header-->

{| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |

| style="vertical-align:top;width:50%;" | <div style="padding: 1px; text-align:center; line-height: wrap_content; font-size:14px; border-top:3px solid #ffcc16;background:#545454;border-bottom:3px solid #ffcc16 "> [[ANLY482 AY2017-18 T2 Group15 Project Overview Version 1| <font color="#FFFFFF"><b>'''VERSION 1'''</b>]]

| style="vertical-align:top;width:50%;" | <div style="padding: 1px; text-align:center; line-height: wrap_content; font-size:14px;  border-top:3px solid #ffcc16;border-bottom:3px solid #ffcc16"> [[ANLY482_AY2017-18_T2_Group15_Project_Overview| <font color="#000000"><b>FINAL</b>]]

|

|}
&nbsp;
<!--/Sub Header-->

<div align="Left">
<div style="background: #ffebba; padding: 12px;font-family:Helvetica; font-size: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #ffcc16 solid 10px; border-right: #ffcc16 solid 10px; text-align:center "><font color="#3f3d3d">OUR MOTIVATIONS</font></div>
<br/>
::To address the company’s concerns as stated by their representatives, our group aims to add value to the company by helping them to discover the determinants of a stronger brand – the extent to which advertising impacts sales. This would give the company’s marketing team a clear view of the concrete steps to take so their brands achieve increased market share.

::In addition, we aim to create a comprehensive information dashboard displaying statistics and analytics which will allow users to obtain a clear overview of sales trends, business outcomes from various marketing decisions, and other details to facilitate management’s decision-making process.
<br/>

<div align="Left">
<div style="background: #ffebba; padding: 12px;font-family:Helvetica; font-size: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #ffcc16 solid 10px; border-right: #ffcc16 solid 10px; text-align:center "><font color="#3f3d3d">METHODOLOGY</font></div>
<br/>
::Our project methodology will consist of, but is not limited to, the following:

:::1.	'''Correlation Analysis''' 

::::Correlation Analysis will be done between Marketing Expenditure and Brand Equity Scores. This will show how a particular marketing action affects the sales of the various product brands.

:::2.	'''Market Basket Analysis '''

::::This is an analysis between how the sales of different brands correlate to each other. One of the main deliverables of interest will be the analytics of cannibalization effects among the brands. 

:::3.	'''Seasonality Trends''' 

::::We will analyze how sales fluctuate on a broader scale, such as during holiday months and seasons, as well as how marketing campaigns affect sales trends.

::The main tool to be utilised will be JMP Pro 13. This tool is selected for its combination of statistical analyses capabilities and visualization features provided. The end deliverable will be an interactive, updatable (through synchronisation) HTML dashboard that is accessible through mobile devices. 


::Some examples of JMP functionalities that we may use is shown below.
{| class="wikitable" 
|-
! style="font-weight: bold;width: 50%;" | Visualization 
! style="font-weight: bold;;" | Description
|-
| 
<p><center>'''Time Series''' </center></p>
[[File:time_series.png|center|300px]]
 || 
This is a simple and easily understood visualization to display sales trends. Individual graphs could be used to visualize the sales trends for each product, or for each sales channel, etc.
|-
| 
<p><center>'''Actual by Predicted''' </center></p>
[[File:actual_by_predicted.png|center|300px]]
 || 
This plot provides analysis of model fit, taking into account variations due to random effects. After establishing the impact of marketing spending on sales, this visualization can help users discern the accuracy of sales predictions based on marketing spending by comparing the predictions against actual historical sales. 

|}

<br/>

<div align="Left">
<div style="background: #ffebba; padding: 12px;font-family:Helvetica; font-size: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #ffcc16 solid 10px; border-right: #ffcc16 solid 10px; text-align:center "><font color="#3f3d3d">SCOPE OF THE PROJECT</font></div>
<br/>

::We will be working with data of all products sold by the company in Singapore. In terms of data, we will be working mainly with Marketing and Sales data as our primary focus is to link these two segments meaningfully.
<br/>

<div align="Left">
<div style="background: #ffebba; padding: 12px;font-family:Helvetica; font-size: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #ffcc16 solid 10px; border-right: #ffcc16 solid 10px; text-align:center "><font color="#3f3d3d">DATA USED</font></div>
<br/>

::'''Company X provided us excel files containing the following data:'''

::*Distribution of stores Company X supplies to across Singapore from 2014 to 2017, according to the type of store, the product brand supplied and the region the store is located. There are four types of stores, namely:
::**TYPE 1: supermarkets, convenience stores and petrol marts.
::**TYPE 2: Chinese restaurants and seafood restaurants. 
::**TYPE 3: modern cafés, bars and pubs.
::**TYPE 4: stores which are not permanent such as carnivals and sponsorships.

::*Key performance indicators of each brand from 2014 to 2017 for different age groups of males. The KPI scores are derived from surveys conducted by Company X.
::*Price index of each brand from 2015 to 2017. This shows the average retail prices.
::*Details of the promotions which retailers advertised on newspapers such as The Strait Times and Lian He Zao Bao, from 2017 to 2018, for the brands Company X owns as well as competing brands.
::*Duration and date of the campaigns Company X held for each brand in 2017.
::*Monthly sales volume for each brand from 2014 to 2017.



<div align="Left">
<div style="background: #ffebba; padding: 12px;font-family:Helvetica; font-size: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #ffcc16 solid 10px; border-right: #ffcc16 solid 10px; text-align:center "><font color="#3f3d3d">OUR WORK PLAN</font></div>
<br/>
[[file:Work plan.png|1000px|center]]