Difference between revisions of "ANLY482 AY2017-18 T2 Group 15"

From Analytics Practicum
Jump to navigation Jump to search
 
(5 intermediate revisions by one other user not shown)
Line 25: Line 25:
  
 
|}
 
|}
 
 
 
<!------ END OF TOP HEADER ----->
 
<!------ END OF TOP HEADER ----->
  
Line 42: Line 40:
 
&nbsp;
 
&nbsp;
 
<!--/Sub Header-->
 
<!--/Sub Header-->
 
 
 
<!------ START OF DETAILS----->
 
<!------ START OF DETAILS----->
 
<div align="left">
 
<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">PROJECT DESCRIPTION</font></div>
 
<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">PROJECT DESCRIPTION</font></div>
 
<br/>
 
<br/>
::Our sponsor, Company X, is a global company with products available in over 75 markets globally. With a number of large brands in their portfolio, specific and targeted marketing campaigns are crucial in driving sales and establishing brand uniqueness between one another. As a project team, we would like to determine the effect of marketing on sales, thus allowing our client to make improved marketing decisions.
+
::Data visualization software is a powerful analytical tool. With the necessary data, an ideal set of visualizations provides clear information about sales trends and operational data and is highly adaptable to users’ changing needs. This helps businesses better understand their strengths, weaknesses, and performance against competitors, and make quicker and more effective business decisions. A competitive edge is thus obtained against users of primitive data visualization methods, such as static charts and graphs - which are less customizable, take more time to update and provide less information in the long run.
 +
 
 +
::This project will explore the benefits of data visualization improvements on a client, which is a well-established Fast-Moving Consumer Goods (FMCG) company. The study will use actual data for distribution, sales, Key Performance Indicators (KPIs) and price between 2014 and 2017. The data is currently visualized in a simple Excel dashboard, which provides limited information. In this project, we begin with data-cleaning and transformation processes in converting raw data into the flat data structure necessary for visualization, then assess the suitability of two more powerful and sophisticated visualization methods – Tableau and Qlik Sense. Finally, we recommend the platform which best suits the client’s needs, along with plans and recommendations for the client moving forward.
 +
 
 +
::As a project team, we aim to improve our client’s data processing and analytics methods to improve their efficiency, provide clearer and more dynamic visualizations, and allow them to make improved marketing decisions.
 +
 
  
 
<br/>
 
<br/>
Line 55: Line 56:
  
 
<br>
 
<br>
{{Progress bar|80|height = 10px| text = completed |width = 50%}}
+
{{Progress bar|100|height = 10px| text = completed |width = 50%}}
{{Center|Final Report, USDA and Poster Presentation in Progress}}
+
 
 
<br/>
 
<br/>
  
Line 79: Line 80:
 
:Conference Paper - 20%
 
:Conference Paper - 20%
 
:Poster - 10%<br /><br />
 
:Poster - 10%<br /><br />
<b>14-15 Apr 2018: </b> Undergraduate Conference Days - (09:00 - 18:00)<br /><br />
+
<b>12-13 Apr 2018: </b> Undergraduate Conference Days - (09:00 - 18:00)<br /><br />
<b>22 Apr 2018: </b> Final Submission - 23:59
+
<b>15 Apr 2018: </b> Final Submission - 23:59
 
:Analytical Sandbox and Code - 15%
 
:Analytical Sandbox and Code - 15%
 
:Wikipage - 5%<br /><br />
 
:Wikipage - 5%<br /><br />
  
 
</div>
 
</div>

Latest revision as of 20:47, 15 April 2018

HOME

PROJECT OVERVIEW

DATA ANALYSIS

DOCUMENTATION

RECOMMENDATIONS

ABOUT US

BACK TO MAIN ANLY82


 

PROJECT DESCRIPTION


Data visualization software is a powerful analytical tool. With the necessary data, an ideal set of visualizations provides clear information about sales trends and operational data and is highly adaptable to users’ changing needs. This helps businesses better understand their strengths, weaknesses, and performance against competitors, and make quicker and more effective business decisions. A competitive edge is thus obtained against users of primitive data visualization methods, such as static charts and graphs - which are less customizable, take more time to update and provide less information in the long run.
This project will explore the benefits of data visualization improvements on a client, which is a well-established Fast-Moving Consumer Goods (FMCG) company. The study will use actual data for distribution, sales, Key Performance Indicators (KPIs) and price between 2014 and 2017. The data is currently visualized in a simple Excel dashboard, which provides limited information. In this project, we begin with data-cleaning and transformation processes in converting raw data into the flat data structure necessary for visualization, then assess the suitability of two more powerful and sophisticated visualization methods – Tableau and Qlik Sense. Finally, we recommend the platform which best suits the client’s needs, along with plans and recommendations for the client moving forward.
As a project team, we aim to improve our client’s data processing and analytics methods to improve their efficiency, provide clearer and more dynamic visualizations, and allow them to make improved marketing decisions.



PROJECT STATUS


100% completed

   


Group15timeline.PNG


PROJECT DELIVERABLES

14 Jan 2018: Proposal Submission - 23:59

Wikipage - 5%
Proposal Report - 10%

25 Feb 2018 Interim Report - 23:59

Interim Report (wikipage) - 5%
Analytical Sandbox - 15%

26 Feb 2018 - 4 Mar 2018: Interim Presentation - (08:30 – 11:30, 13:30-17.30)

Interim Presentation - 10%

01 Apr 2018: Undergraduate Conference Abstract Submission - 23:59

Conference Abstract - 5%

08 Apr 2018: Undergraduate Conference Full Paper Submission - 23:59

Conference Paper - 20%
Poster - 10%

12-13 Apr 2018: Undergraduate Conference Days - (09:00 - 18:00)

15 Apr 2018: Final Submission - 23:59

Analytical Sandbox and Code - 15%
Wikipage - 5%