Group01 proposal

Team

Proposal

Poster

Application

Research Paper

<-- Go back to project groups

PROBLEM & MOTIVATION

With Singapore’s growing population and limited resources, she faces many pressing challenges for progressive development and economic growth. These challenges span across housing affordability, rising healthcare, aging population, education/income inequality, and low birth rates. For Singapore to continue progressing, it is imperative that the government continues to take proactive measures to plan and utilise its resources effectively. In this fashion, we strive to use visual analytics to help uncover some of the cracks in and opportunities in Singapore’s social demographic to assist the government in sharpening its current policies and to look into future plans. This is well in line with the government’s effort of making socially relevant data public to encourage innovation and discovery.

PROJECT OBJECTIVES

TO DO: Explain project Objectives

SELECTED DATABASE

The Data Sets we will be using for our analysis and for our application is listed below:

Dataset/Source	Data Attributes	Rationale Of Usage
Resident by planning Area, subgroup, age Group, sex and dwelling (2000 - 2019, June) https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data	Planning area SubZone Age group Type of dwelling Gender	This dataset covers a good time series from 2000-2019 and the breakdown by subzone/planning area allows it to serve as the base platform to integrating with other population data sets that are grouped by subzone/planning area as well. From here, we can also get a good view of Singapore’s residential distribution by gender and age group that might give us a few initial findings that help for further investigation with the help of complimentary data sets.
Singapore General Household Survey & Census of population (2000, 2010, 2015) https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data	Contains the following attributes by Planning Area: Gender Occupation Income Levels Travel Time to work/School Educational Qualification Language Preference Religion	This data adds a very rich level of dimensionality on top of the residential data as mentioned above. However, it only covers limited points in time and so we intend to use this data separately for more deep time static analysis. Also, as this data is very rich, we hope that it can further serve as a bridge to more abstract but complementary data.
Birth & Fertility Rate (1960 - 2018, annual) https://www.singstat.gov.sg/find-data/search-by-theme/population/births-and-fertility/latest-data	Total Fertility rate Fertility Rate by age group Fertility rate by ethinic group Gross and net reproduction rate Crude birth rate Total live-births Resident live-births Total live - birth by ethnic group and gender	This data set gives quite good coverage on the number of births by different dimentions i.e. ethnicity, age group, educational background of parents. This will be helpful in helping us bridge this data set with the other population data sets to explore Singapore’s Birthrate problems in greater detail.
Hospital Admission Rate By Sex and Age (1984 - 2018) https://www.singstat.gov.sg/find-data/search-by-theme/society/health/latest-data	Acute / Community / Psychiatric hospital By age group (0-14, 15-64, >65 ) Total Number of admissions by hospital	This data helps to give a high level view on the hospitals of singapore and how many admissions they had each year. It will be useful to integrate this with the population data set to see how taxed each hospital is in caring for different age groups through the years.

We will be using these data sets as our main inputs. However, we are still open to add complimentary data sets to further enhance the quality insights attained from our visualisation.

BACKGROUND SURVEY

To begin, we explored current charts that were used to visualise the key areas that we defined to explore (e.g. inequality, urban planning, geo-plots). This is a summary of the more interesting visualisations we found:

Reference of Other Interactive Visualization	Learning Point
Title: Income distribution by country over the years Source: https://www.gapminder.org/tools/#$chart-type=mountain	Learning Points: Highly interactive; The detailed data of the region can be displayed at corner upon selecting An overview of all the countries, income population, distribution in the same chart. Converted the Continent information into different colours. Possible Usage: It allowed the team to discover all the subzone/ planning area income distribution in the same chart with a generic reference line of average income of the Singapore or world poverty line. It would be helpful for the decision maker to redistribute the resource for the needy residents Area for Improvement: The selection has the animation of highlighted areas instead of lines. The user could get wrong information as they might be misled by the proportion of the offset area.
Title: Changing Ranks of States by Congressional Representation Source: https://www.census.gov/dataviz/visualizations/023/	Learning Points: Provide the consistency of changing rank over the sampling period. Possible Usage: Helpful for indicating the rank of the population density rank or other rank to find the changing of the hotspots between 2 or more periods. Area for Improvement: No actual data has been displayed. Only limited insights could be found from the chart The colour and intercepted points among the used could cause misunderstanding
Title: Interactive map visualization Source: https://morphocode.com/the-5-minute-walk/	Learning Points: Chart A enables users to zoom into different planning areas in the geographic distribution. Then, information of the resident population by subgroup, age group, type of dwelling will be presented by the bar chart. It allows immediate comparison of the resident population between the planning areas and draws trends among other observations. Moreover, with possible available datasets of schools, hospitals, resident household income, etc by location point, interactivity can be applied as shown in chart B. By clicking into a specific subzone, it allows users to adjust a range of radius. As the radius expands, a pie chart will show the increase in number of schools, hospitals, resident household, income, etc. Possible Usage: This can be used in our setting to do sharp analysis of specific amenities and how much of the population they cater to. E.g the user could perhaps look at common places of leisure (Parks), or Hospitals and using a radius of Planning areas, calculate the proportion of age group that the facility caters to. Area for Improvement: This chart needs very specific location data which is not available for us. Thus we will need to re-think how to use the "radius" filter function accordingly.
Title: Bricks Map Source: https://www.perceptualedge.com/blog/?p=1627	Learning Points: (Type point here) Possible Usage: (Type point here) Area for Improvement: (Type point here)
Title: Circular Network Diagram Source: https://www.census.gov/dataviz/visualizations/stem/stem-html/	Learning Points: Help to find the relationship of redistribution between 2 and more variables. Possible Usage: Display the same subzone and planning relationship and distribution between the education level and income level. Area for Improvement: No actual data has been displayed. The circle design and proportion used may not reflect the distribution accurately due to the transformation to the round shape.

BRAINSTORMING SESSIONS

(TO DO: Insert Brainstorming charts & Explain)

500px

(Type in methodology of brainstorming sessions and explain how each chart was derived and the potential use)

PROPOSED STORYBOARD

Below is the proposed story board for our project:

Storyboard	Insights / Comments
Title: DASHBOARD 1 - Home View (Helicopter View Exploration) 400px	storyboard This chart serves as the landing page where users will explore the data set at a high level. It will offer a time based playable view over key social demographics at national level on things like Age-sex pyramid, Fertility rate (with trend), Household income, Education levels. Using this page, the user will be able to identify trends that they have interest in and pick out high level insights to be explored further using the other dashboards. The time playable view will allow the user to gain deeper insights as the data can be expressed in higher dimentionality rather than condensing it to fit in a trend based line chart. We will also consider adding it different high level view options that the map can play out. (i.e. it is currently population density by planning areas, but it could also be selectively changed to income distribution/educational level...etc.)
Title: DASHBOARD 2 - Social Demographic Investigator 400px	This view is a specific analytic view that has more specific charts and filter options to allow the user to dive in to explore social demographic issues like inequality with greater precision. We intend for this view to be able to show down to the sub-zone but understand that data is limited if we use that level of detail. As such, the view might only be able to show 2000, 2010, 2015 in greater detail as supported by the population census data. We hope to explore more potential views that help display population demographic data like education and income levels, to really help policy makers and planners get down to building more creative and targeted solutions based on sharper insights.
Title: DASHBOARD 2 - Family and Birth Rate Investigator 400px	One of the things that made us excited about this project at first was being able to explore what are the key factors that lead to low birth rate. As such, we hope to use this visualisation to help identify areas with high/low birth rate and fit complimentary data to get down to the factors behind these low/high birth rates. Some of the factors we can imagine that are of interest are: education levels, age of marriage, religion, type of House ... etc. As such, we hope to implement charts that help to visualise some of these relationships and make the exploration more fruitful in giving insights for targeted planning and policy making. We also would like to build in charts (Interactive map visualisation) to analyse public ammenities and how they provide for different population groups for better planning.
Title: DASHBOARD 3 - Healthcare Investigator 400px	This storyboard is heavily focused on identifying the healthcare facilities and how much strain they are getting from the population. We hope to use interactive map visualisations to allow users to selectively explore healthcare facilities and their usage and stress according to planning areas and subzones. As preventive healthcare is also the general direction of the government, we hope to build in features to help them understand where to locate certain public amenities like fitness zones or eldercare centres to optimise the land planning.

TECHNOLOGY USED

The technologies we will be using for this Project are as below: (TO DO: Show png of the tech used)

650px

CHALLENGES, RISK ASSESMENT AND MITIGATION

Challenges	Mitigation Plan
Unfamiliarity of visualisation tools such as R, R Shiny, Tableau.	Hands on practice using the different training platforms such as Data Camps Watch video tutorials from YouTube Peer Learning
Unfamiliarity of data cleaning and transformation using Tableau Prep	Attend workshop on data cleaning methods Watch video tutorials on how to fully utilise Tableau Prep Trial and test on the different cleaned data sets while maintaining the raw data
Limited knowledge and the jargon used in Indonesia’s trading industry	Research and learn the situation of Indonesia’ export and import in the last ten years Read articles or news to find out the recent trends and global updates on trade

PROPOSED TIMELINE

(TODO: Insert High level timeline & Gantt Chart)

1000px

COMMENTS AND FEEDBACK

Feel free to leave us some comments so that we can improve!

No.	Name	Date	Comments
1.	Insert your name here	Insert date here	Insert comment here
2.	Insert your name here	Insert date here	Insert comment here
3.	Insert your name here	Insert date here	Insert comment here