Sunny Singapore

PROPOSAL

POSTER

APPLICATION

RESEARCH PAPER

Introduction

As the jewel of Southeast Asia, Singapore is a chart topper for many global, accredited rankings. However, these prominent awards narrowly focused on the nation’s economic development, technological infrastructure and overall prosperity. In fact, much less emphasis was placed on Singapore’s real and present problems – a struggling middle class, isolated social class and undefined first-world poverty. This passion project seeks to unearth the realities by designing an intuitive application that provides straightforward visualisations of key trends and statistics of Singapore.

Problem and Motivation

Despite Singapore has its own statistical government office and multiple websites such as SingStat or data.gov.sg, most of the data you can find are in the format of an Excel spreadsheet, which is very hard to understand and draw insight for the general public. Hence, we are motivated to come up with a more user-friendly visualized tool that allows everyone to instantly identify the pattern and insight about Singapore socioeconomic situation

Objectives

In this project, we are creating a visualisation dashboard that is able to discover different aspects of Singapore:

• Economic situation and demographic of different planning areas
• The income inequality and wealth distribution
• The life standard of Singapore residents through:
  • Highest qualification achieved
  • Marital status
  • Choice of transportation
  • Accommodation situation

Datasets

These are the datasets we plan to use:

Dataset	Rationale
Map of Planing Areas in Singapore	A dataset containing SHP files of the administrative boundaries of Singapore 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
Population distribution in Singapore by age, sex and planning areas	A dataset containing the total number of citizen by age and sex at each planning area in Singapore Used to visualize the demographic at each planning area https://data.gov.sg/dataset/singapore-residents-by-planning-area-subzone-age-group-and-sex
Resident households in Singapore by household size and planning areas	A dataset containing the total number of households in each planning area by household size 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
Population in Singapore by sex, economy status and planning areas	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
Population in Singapore by sex, marital status and planning areas	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
Working residents in Singapore by industry and planning areas	A dataset containing the total number of people working in each industry at each each planning area Used to visualize the population demographic https://data.gov.sg/dataset/resident-working-persons-aged-15-years-and-over-by-planning-area-and-industry-2015
Working residents in Singapore by monthly income and planning areas	A dataset containing the total number of people within each income range at each planning area Used to visualize the population wealth distribution https://data.gov.sg/dataset/resident-working-persons-aged-15-years-over-by-planning-area-gross-monthly-income-from-work-2015
Working residents in Singapore by occupation and planning areas	A dataset containing the total number of people working in some occupation group at each planning area Used to visualize the population socioeconomic situation https://data.gov.sg/dataset/resident-working-persons-aged-15-years-and-over-by-planning-area-and-occupation-2015
Highest qualification achieved by Singapore resident by planning area	A dataset containing the total number of people at each different qualification level at each planning area Used to visualize the population socioeconomic situation https://data.gov.sg/dataset/resident-population-aged-15-years-and-over-by-planning-area-and-highest-qualification-attained-2015
Resident Households by Planning Area and Type of Dwelling	A dataset containing the total number of people at each type of dwelling at each planning area Used to visualize the population socioeconomic situation https://data.gov.sg/dataset/resident-households-by-planning-area-n-type-of-dwelling-2015

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

Background Survey of Related Works

There are multiple visualizations around the world with the goal to uncover the poverty situation in different countries. Although there are not a lot of visualizations about the situation in Singapore, we were able to found a few visualizations about the US to draw inspiration from:

Reference of Other Visualizations	What we can learn from
Title: 2018 Median Household Income in the United State	Example
Example	Example
Example	Example

Tools and Libraries

• Microsoft Excel
• R Studio
• Tableau
• Tableau Prep
• Google Drive

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

Data Analysis and Transformation

Proposed Visualizations and Storyboard

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

• Tableau: https://www.tableau.com/learn/training
• R Shiny: https://shiny.rstudio.com/tutorial/

Comments

Feel free to leave comments / suggestions!