Difference between revisions of "ANLY482 AY2016-17 T2 Group13 - Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
(Created page with "<!-- Logo --> <br> <!-- End Logo --> <!-- Start Nav Bar --> {| style="background-color:#fff; color:#000000 padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0"...")
 
 
(6 intermediate revisions by 2 users not shown)
Line 6: Line 6:
  
 
{| style="background-color:#fff; color:#000000 padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |
 
{| style="background-color:#fff; color:#000000 padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center;" width="15%" |
+
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center;" width="14%" |
 +
&nbsp;[[ANLY482 AY2016-17 Term 2 | <font color="#ffffff" size="2"><strong>AP PROJECTS</strong></font>]]
 +
 
 +
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center;" width="14%" |
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 | <font color="#ffffff" size="2"><strong>HOME</strong></font>]]
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 | <font color="#ffffff" size="2"><strong>HOME</strong></font>]]
  
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center; border-left: 0px" width="15%" |  
+
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center; border-left: 0px" width="14%" |  
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - About_Us | <font color="#ffffff" size="2"><strong>ABOUT US</strong></font>]]
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - About_Us | <font color="#ffffff" size="2"><strong>ABOUT US</strong></font>]]
  
| style="font-family:Century Gothic; font-size:100%; background:#f4f9fd; text-align:center;border-left: 0px" width="15%" |  
+
| style="font-family:Century Gothic; font-size:100%; background:#f4f9fd; text-align:center;border-left: 0px" width="14%" |  
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - Project Overview | <font color="#000000" size="2"><strong>PROJECT OVERVIEW</strong></font>]]
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - Project Overview | <font color="#000000" size="2"><strong>PROJECT OVERVIEW</strong></font>]]
  
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center;border-left: 0px" width="15%" |  
+
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center;border-left: 0px" width="14%" |  
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - Project_Findings | <font color="#ffffff" size="2"><strong>PROJECT FINDINGS</strong></font>]]
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - Project_Findings | <font color="#ffffff" size="2"><strong>PROJECT FINDINGS</strong></font>]]
  
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center; border-left: 0px" width="15%" |  
+
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center; border-left: 0px" width="14%" |  
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - Project_Management | <font color="#ffffff" size="2"><strong>PROJECT MANAGEMENT</strong></font>]]
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - Project_Management | <font color="#ffffff" size="2"><strong>PROJECT MANAGEMENT</strong></font>]]
  
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center; border-left: 0px" width="15%" |  
+
| style="font-family:Century Gothic; font-size:100%; background:#003464; text-align:center; border-left: 0px" width="14%" |  
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - Documentation | <font color="#ffffff" size="2"><strong>DOCUMENTATION</strong></font>]]
 
&nbsp;[[ANLY482 AY2016-17 T2 Group13 - Documentation | <font color="#ffffff" size="2"><strong>DOCUMENTATION</strong></font>]]
  
|}<!-- End Nav Bar -->
+
|}
 +
<!-- End Nav Bar -->
  
  
Line 30: Line 34:
 
{| style="background-color:white; color:000000 padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |
 
{| style="background-color:white; color:000000 padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |
  
| style="vertical-align:top;width:14%;" | <div style="padding: 3px; text-align:center; line-height: wrap_content; font-size:15px; border-bottom:5px solid #0163bd; font-family:Century Gothic"> [[Qui Vivra Verra - Project Overview| <b>Motivation & Objectives</b>]]
+
| style="vertical-align:top;width:14%;" | <div style="padding: 3px; text-align:center; line-height: wrap_content; font-size:15px; border-bottom:5px solid #0163bd; font-family:Century Gothic"> [[ANLY482 AY2016-17 T2 Group13 - Project Overview| <b>Motivation & Objectives</b>]]
 +
 
 +
| style="vertical-align:top;width:14%;" | <div style="padding: 3px; text-align:center; line-height: wrap_content; font-size:15px; border-bottom:2px solid #0163bd; font-family:Century Gothic"> [[ANLY482 AY2016-17 T2 Group13 - Technology| <b>Technology</b>]]
  
| style="vertical-align:top;width:14%;" | <div style="padding: 3px; text-align:center; line-height: wrap_content; font-size:15px; border-bottom:2px solid #0163bd; font-family:Century Gothic"> [[Qui Vivra Verra - Technology| <b>Technology</b>]]
+
| style="vertical-align:top;width:14%;" | <div style="padding: 3px; text-align:center; line-height: wrap_content; font-size:15px; border-bottom:2px solid #0163bd; font-family:Century Gothic"> [[ANLY482 AY2016-17 T2 Group13 - Data| <b>Data Provided</b>]]
  
 
|}
 
|}
Line 39: Line 45:
  
 
<!------- Details ---->
 
<!------- Details ---->
 +
<div style="background: #dce6f9; line-height: 0.3em; font-family:Century Gothic;  border-left: #003464 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#000000"><strong>Motivation</strong></font></div></div>
  
<div style="background: #dce6f9; line-height: 0.3em; font-family:Century Gothic;  border-left: #003464 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#000000"><strong>Motivation</strong></font></div></div>
+
The objective for our group in undertaking this project was simple: to create meaningful insights for an organisation that can have a larger impact on society. Linking up with the Department of International Trade (DIT) within our sponsor organisation will allow us to provide data-based insights to their employees, which will hopefully allow the DIT to make trade decisions that could allow jobs to be created and strengthen ties between the UK and Singapore.
 +
 
 +
<div style="background: #dce6f9; line-height: 0.3em; font-family:Century Gothic;  border-left: #003464 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#000000"><strong>Problem</strong></font></div></div>
  
Every year, the Department for International Trade (DIT) plans and reviews marketing campaigns that the UK should take to encourage British businesses to expand into Singapore. These campaigns are categorised into 16 main sectors, 5 of which are currently the main focus for Singapore. To justify a High-Value Campaign, the sector has to be estimated to be worth about £250 million in export volume over 4 years. <br>
+
Every year, the Department for International Trade (DIT) plans and reviews marketing campaigns that the United Kingdom (UK) should take to encourage British businesses to expand into Singapore. These campaigns are categorised into 18 main sectors, 5 of which are currently the main focus for Singapore. To justify a High-Value Campaign, the sector has to be estimated to be worth about £250 million in export volume over 4 years. <br>
  
Traditionally, decisions made for these marketing campaigns do not refer to existing historical trade data. Instead, these crucial decisions are built merely upon the sentiments of staff within the department or past successful campaigns. Any patterns in specific import and export data between UK and Singapore as well as between other countries and Singapore are not analysed and are not effectively utilised in BHC’s marketing campaigns. This could lead to a loss in untapped trade opportunities for the UK, which decreases UK’s export revenue and potentially, their overall GDP.<br>
+
Traditionally, decisions made for these marketing campaigns do not refer to existing historical trade data. Instead, these crucial decisions are built merely upon the sentiments of staff within the department or past successful campaigns. Any patterns in specific import and export data between UK and Singapore as well as between other countries and Singapore are not analysed and are not effectively utilised in DIT's marketing campaigns. This could lead to a loss in untapped trade opportunities for the UK, which decreases UK's export revenue and potentially, their overall GDP.<br>
  
 
<div style="background: #dce6f9; line-height: 0.3em; font-family:Century Gothic;  border-left: #003464 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#000000"><strong>Objectives</strong></font></div></div>
 
<div style="background: #dce6f9; line-height: 0.3em; font-family:Century Gothic;  border-left: #003464 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#000000"><strong>Objectives</strong></font></div></div>
  
A user-friendly system which displays information on trade volume, type and directions that can provide insights into UK’s current trade patterns with Singapore would thus be valuable to DIT’s decision making. <br>
+
A user-friendly system which displays information on trade volume, type and directions that can provide insights into UK's current trade patterns with Singapore would thus be valuable to DIT’s decision making. <br>
  
 
The main aim of the project is to provide the DIT with valuable insights for decision-making by developing an analytical dashboard contained in a web application. This dashboard will help the end-user determine the following:
 
The main aim of the project is to provide the DIT with valuable insights for decision-making by developing an analytical dashboard contained in a web application. This dashboard will help the end-user determine the following:

Latest revision as of 00:02, 20 February 2017



  AP PROJECTS

  HOME

  ABOUT US

  PROJECT OVERVIEW

  PROJECT FINDINGS

  PROJECT MANAGEMENT

  DOCUMENTATION


Motivation

The objective for our group in undertaking this project was simple: to create meaningful insights for an organisation that can have a larger impact on society. Linking up with the Department of International Trade (DIT) within our sponsor organisation will allow us to provide data-based insights to their employees, which will hopefully allow the DIT to make trade decisions that could allow jobs to be created and strengthen ties between the UK and Singapore.

Problem

Every year, the Department for International Trade (DIT) plans and reviews marketing campaigns that the United Kingdom (UK) should take to encourage British businesses to expand into Singapore. These campaigns are categorised into 18 main sectors, 5 of which are currently the main focus for Singapore. To justify a High-Value Campaign, the sector has to be estimated to be worth about £250 million in export volume over 4 years.

Traditionally, decisions made for these marketing campaigns do not refer to existing historical trade data. Instead, these crucial decisions are built merely upon the sentiments of staff within the department or past successful campaigns. Any patterns in specific import and export data between UK and Singapore as well as between other countries and Singapore are not analysed and are not effectively utilised in DIT's marketing campaigns. This could lead to a loss in untapped trade opportunities for the UK, which decreases UK's export revenue and potentially, their overall GDP.

Objectives

A user-friendly system which displays information on trade volume, type and directions that can provide insights into UK's current trade patterns with Singapore would thus be valuable to DIT’s decision making.

The main aim of the project is to provide the DIT with valuable insights for decision-making by developing an analytical dashboard contained in a web application. This dashboard will help the end-user determine the following:

  • Trade sectors to focus on
  • High - / low-performing goods and services that should or should not be imported into Singapore
  • High-/low-risk competitors importing into Singapore