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
Resident Working Persons by Planning Area and Usual Mode of Transport to Work	A dataset containing the total number of people with different transportation choice at each planning area Used to visualize the population socioeconomic situation https://data.gov.sg/dataset/resident-working-persons-aged-15-yrs-n-over-by-planning-area-n-usual-mode-of-transport-to-work-2015

Proposed Storyboard

#1: Introduction page

To provide background story, problem and motivation of this project

#2: Economic Overview

• Economic Health
  • Economic Status of different planning areas
  • Breakdown of economic status at each planning area by genders
  • Dependency ratio of different planning areas
• Economic Sector
  • Distribution of working resident in different industries
  • Distribution of working resident in different sectors of the service industry
  • Breakdown of different industries employment by planning areas
  • Breakdown of different sectors employment in the service industry by planning area
  • Distribution of working resident in different occupation groups
  • Breakdown of different occupation group by planning area

#3: Socioeconomic Overview

• Income Statistics
  • Wealth distribution each different planning area at different income range
  • Breakdown of monthly income at each planning areas
• Education Statistics
  • Highest qualification achieved by residents at each planning areas

#4: Quality of life Overview

• Housing distribution
  • Type of dwelling at different planning areas
  • Breakdown of housing type at each planning area
  • Distribution of different household size around Singapore
  • Percentage of each household size at different planning areas
• Transport Trends
  • Breakdown of transportation choice at each planning area
• Relationship
  • Breakdown of marital situation by genders and planning areas

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!