Difference between revisions of "Sunny Singapore"
| Line 54: | Line 54: | ||
{| class="wikitable" style="background-color:#FFFFFF;" width="100%" | {| class="wikitable" style="background-color:#FFFFFF;" width="100%" | ||
|- | |- | ||
| − | ! style="font-weight: bold;background: #FFFFFF;color:#000000;width: | + | ! style="font-weight: bold;background: #FFFFFF;color:#000000;width: 25%;" | Dataset |
! style="font-weight: bold;background: #FFFFFF;color:#000000;" | Rationale | ! style="font-weight: bold;background: #FFFFFF;color:#000000;" | Rationale | ||
|- | |- | ||
| Line 106: | Line 106: | ||
* Used to visualize the population socioeconomic situation | * Used to visualize the population socioeconomic situation | ||
* https://data.gov.sg/dataset/resident-households-by-planning-area-n-type-of-dwelling-2015 | * https://data.gov.sg/dataset/resident-households-by-planning-area-n-type-of-dwelling-2015 | ||
| + | |- | ||
| + | | <center> Resident Working Persons by Planning Area and Usual Mode of Transport to Work </center> || | ||
| + | * 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 | ||
|- | |- | ||
|} | |} | ||
Revision as of 15:46, 23 November 2019
Contents
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 |
|---|---|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|
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 |
|---|---|---|
|
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 | |
|
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!
