Difference between revisions of "Sunny Singapore"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 87: Line 87:
 
! style="font-weight: bold;background: #FFFFFF;color:#000000;" | Rationale
 
! style="font-weight: bold;background: #FFFFFF;color:#000000;" | Rationale
 
|-
 
|-
| <center> Administrative Boundaries, Taiwan </center> ||  
+
| <center> Planing Areas of Singapore </center> ||  
* A dataset containing SHP files of the administrative boundaries of taiwan (county, town, village)
+
* A dataset containing SHP files of the administrative boundaries of Singapore
* Used as a reference to digitize IFC branch trade areas
+
* Used as a reference to digitize Singapore planning areas
 +
* https://data.gov.sg/dataset/master-plan-2014-planning-area-boundary-no-sea?resource_id=c8185fd3-3c78-48c8-94bc-a957699b4e92
 
|-
 
|-
| <center> Branch location of IFC, Taiwan </center> ||  
+
| <center> Population distribution in Singapore by age, sex and planning areas </center> ||  
* A dataset containing the geographical information of each individual branch.
+
* A dataset containing the total number of citizen by age and sex at each planning area in Singapore
* Used as the main target of our project
+
* Used to visualize the demographic at each planning area
 +
* https://data.gov.sg/dataset/singapore-residents-by-planning-area-subzone-age-group-and-sex
 
|-
 
|-
| <center> Point of Interests , Taiwan </center> ||  
+
| <center> Resident households in Singapore by household size and planning areas </center> ||  
* A dataset containing each individual Point-Of-Interests in Taiwan (e.g. ATMs, Amusement Parks, Banks)
+
* A dataset containing the total number of households in each planning area by household size
* Used as features for analysis with regards to each branch
+
* Used to visualize the population demographic and living standard in Singapore
 +
* https://data.gov.sg/dataset/resident-households-by-planning-area-and-household-size-2015
 
|-
 
|-
| <center> Outlets Monthly Sales Data </center> ||  
+
| <center> Resident households in Singapore by household income and planning areas  </center> ||  
* A dataset containing the monthly sales information of each individual branch
+
* A dataset containing the total number of households in each planning area by household income range
* Used to study the sales data along with the profile of each branch to generate yielding patterns (e.g. top and bottom performer)
+
* Used to visualize the population demographic and living standard in Singapore
 +
* https://data.gov.sg/dataset/resident-households-by-planning-area-and-monthly-household-income-from-work-2015
 +
|-
 +
|-
 +
| <center> Population in Singapore by sex, economy status and planning areas  </center> ||
 +
* A dataset containing the total number of people by economic status and sex at each planning area
 +
* Used to visualize the population demographic and living standard in Singapore
 +
* https://data.gov.sg/dataset/resident-population-aged-15-years-and-over-by-planning-area-economic-status-and-sex-2015
 +
|-
 +
| <center> Population in Singapore by sex, marital status and planning areas  </center> ||
 +
* A dataset containing the total number of people by marital status and sex at each planning area
 +
* Used to visualize the population demographic and living standard in Singapore
 +
* https://data.gov.sg/dataset/resident-population-aged-15-years-and-over-by-planning-area-marital-status-and-sex-2015
 +
|-
 +
|-
 +
| <center> Working residents in Singapore by industry and planning areas  </center> ||
 +
*
 +
*
 +
*
 
|-
 
|-
 
|}
 
|}

Revision as of 15:23, 14 October 2019

Sunny singapore2.jpg
 

PROPOSAL

 

POSTER

 

APPLICATION

 

RESEARCH PAPER


Introduction

Singapore is a leading economy in its region, but an astonishing number of its citizens fall below the first-world poverty line.

First-world poverty is a new concept to many, as it represents a group of citizens who are earning less than sufficient to cover the cost of living of their country of residence. For the fifth consecutive year, Singapore has held to its number one position as the most expensive city to live in. Although welfare is extensive in Singapore, it is definitely not exhaustive. Thus, this has become our main source of motivation for this project.

We seek to develop a tool that is easy use, analyse and to act on because we strongly believe that helping our communities should not be limited to the efforts of the government. We aim to design a platform where users can recognise the less-privileged areas and understand intuitively the type of support required. As such, any citizen, committees or even organisations can utilise this resource to lend a helping hand immediately and effectively.

Problem and Motivation

To build a dashboard that allows for:

  • Profiling of neighbourhoods in Singapore by attributes: income, job specification, transportation, housing and qualifications
  • Other sub-attributes to provide for analytical context: age, race/religion, expenditure, marital status, political views
  • Infographic on First-World Poverty
  • General guidelines on the support type for various helpgroups

Objectives

This project aims to provide insights into the following:

  1. Income data by geography
  2. Socioeconomic status by income
  3. Support types categorised by socioeconomic situation
  4. Scalable system to incorporate future data

Background Survey of Related Works

to be updated

Proposed Storyboard

#1: Home Page

To provide background story, define Singapore's first-world poverty and navigation to other pages

#2: Geographical overview

Income by geography - highlight the areas that are below Singapore's poverty line

#3: Socioeconomic Overview

Compare the areas where this group of people have fallen behind the average

#4: Support type

Proposed support suggestions for these groups of people

Tools and Libraries

  • Microsoft Excel
  • R Studio
  • Tableau
  • Google Drive

Datasets

These are the datasets we plan to use:

Dataset Rationale
Planing Areas of Singapore
Population distribution in Singapore by age, sex and planning areas
Resident households in Singapore by household size and planning areas
Resident households in Singapore by household income and planning areas
Population in Singapore by sex, economy status and planning areas
Population in Singapore by sex, marital status and planning areas
Working residents in Singapore by industry and planning areas

Foreseen Technical Challenges

We encountered the following technical challenges throughout the course of the project. We have indicated our proposed solutions, and the outcomes of the solutions.

Key Technical Challenges Reason Proposed Solution
Data is limited

We will be retrieving our datasets from singstat.gov.sg and data.gov.sg. These two platforms provide an exhaustive list but only have data for the recent decades.

NA

Technical difficulties

Unfamiliar with tools that are required to for data visualisation.

Complete the Datacamp course to learn more about R and R Shiny

Project Timeline

Week 8: Complete detailed project proposal and gather datasets supervised by Alexia
Week 9: Clean datasets supervised by Pham
Week 10: Create data visualisation & consult on quality of work supervised by Parth
Week 11: Finalise storyboard teamwork with help of professor!
Week 12: Get ready for deadlines whoop!

References

Comments

Feel free to leave comments / suggestions!