Difference between revisions of "Microheart"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
(Created page with "center|400px {| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="...")
 
 
(32 intermediate revisions by 3 users not shown)
Line 3: Line 3:
 
{| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |
 
{| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |
  
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[Project_Groups | <b>Home</b>]]
+
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[18191is428g1_MicroHeart: Proposal | <b>Proposal</b>]]
  
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[1718t1is428T2 | <b>Proposal</b>]]
+
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[18191is428g1_MicroHeart: Poster | <b>Poster</b>]]
  
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[1718t1is428T2: Poster | <b>Poster</b>]]
+
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[18191is428g1_MicroHeart: Application | <b>Application</b>]]
  
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[1718t1is428T2: Application | <b>Application</b>]]
+
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[18191is428g1_MicroHeart: Research Paper | <b>Research Paper</b>]]
 
 
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[1718t1is428T2: Research Paper | <b>Research Paper</b>]]
 
 
|}
 
|}
  
 
<p></p><br/>
 
<p></p><br/>
 
<div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROBLEM & MOTIVATION</font></div>
 
<div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROBLEM & MOTIVATION</font></div>
WIP
+
<p>'''Problem Description''': By 2030, the elderly and retired population in Singapore is expected to be approximately 90,000 -- almost twice the current figure. Despite the government’s efforts to continuously beef up the availability and accessibility of healthcare for the elderly and retired, there needs to be a means for the government to predict the optimal number of healthcare facilities that best meets the need of our target audience.</p>
 +
 
 +
<p>'''Motivation''': This project is motivated by the varying ratios of (number of elderly and retired) to number of healthcare facilities in each planning area. This brings a need to detect which planning areas require better access to healthcare facilities.</p>
  
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OBJECTIVES</font></div>
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OBJECTIVES</font></div>
<p>In this project, we are interested to create a visualisation that helps users perform the following:</p>
+
<p>In this project, we aim to create visualisations that helps users perform and analyse the following:</p>
WIP
+
<u>'''Descriptive'''</u>
 +
<p> We would like to provide users with up-to-date demographic information, specifically pertaining to the aged population and the distribution across the different areas of Singapore (as per URA 2014). In addition, we would like to include other information, such as the presence of medical facilities and its distribution mapped out on the same planning area chart.</p>
 +
<u>'''Prescriptive'''</u>
 +
<p>Based on the suggested design above, we aim to be able to provide users with insights on which certain planning zones or subzones require development and emphasis on medical facilities based on the volume of ageing population staying there.</p>
 +
<u>'''Predictive'''</u>
 +
<p>We would like to provide users with a visibility on the trend of ageing population. Based on the dependency ratio formulated from the proportion of ageing population out of the working and economically active population, we aim to be able to predict the timeline on which the ageing situation for the country reaches a critical threshold (where ageing population forms a significant proportion out of the population).</p>
  
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">SELECTED DATASET</font></div>
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">SELECTED DATASET</font></div>
WIP
+
The list of selected dataset that we have sourced for to input into our visualizations can be found below. Necessary data pre-processing steps will be taken to clean and transform the data into a format that is suitable to upload into a visualization.
  
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 30%;" | Dataset/Source
+
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 20%;" | Dataset/Source
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 30%" | Data Attributes
+
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 40%" | Data Attributes
 
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | Rationale Of Usage
 
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | Rationale Of Usage
 +
|-
 +
|
 +
 +
<center>[https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data SingStat Population by Geographic Distribution Data]</center>
 +
<p>
 +
The dataset "Singapore Residents by Planning Area/Subzone, Age Group and Sex, June 2000 - 2018" under population trends was selected.
 +
</p>
 +
||
 +
* Planning Area: Character Text, planning areas segmented as per [https://www.ura.gov.sg/Corporate/Planning/Master-Plan/Introduction URA Master Plan 2014]
 +
* Subzones: Character Text, sub-zones of the respective planning areas to show detail area information
 +
* Age Group (bins): Numerical Integer, shows the total count of individuals under the respective age groups in the respective subzones
 +
||
 +
Required dataset to show the volume of population according to the different age groups. Segmented by planning areas, sub-zones, sex and years (across the different sheets)
 
|-
 
|-
 
|  
 
|  
WIP
+
<center>[https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data The dataset "Distribution of Working Population by Planning Area" was selected.]</center>
 
||  
 
||  
WIP
+
* Planning Area: Character Text, planning areas segmented as per [https://www.ura.gov.sg/Corporate/Planning/Master-Plan/Introduction URA Master Plan 2014]
 +
* Total: Numerical integer, displays the count of individuals living in that particular planning area
 +
* Industry: Character Text, displays the category of industry these working individuals fall under
 +
||
 +
This dataset helps ascertain the age-dependency ratio in every planning area.
 +
|-
 +
|
 +
<center>Data for the locations of hospitals and polyclinics.</center>
 +
<p><center>[https://www.healthhub.sg/directory/clinics-and-polyclinics Locations of Polyclinics]</center></p>
 +
<p><center>[https://www.healthhub.sg/directory/hospitals Locations of Hospitals]</center></p>
 
||  
 
||  
<center>WIP</center>
+
* Name of facility: Character Text, provides the title of the medical facility
|-
+
* Address: Character Text and Numerical, location address of the facility and provides information on the planning area it is located in
 +
* Postal Code: Numerical Integer, 6-digit postal code for the facility to determine the planning area it is situated in.
  
 +
<p>A challenge we faced for this dataset was the lack of csv/excel file on the source website. As such, the records for the locations of the medical facilities had to be manually copied onto an excel spreadsheet. Due to the relatively small number of records of medical facilities, the task is manageable. However, the risk of human error does exist for this particular methodology.</p>
 +
||
 +
This dataset provides a distribution of medical facilities across Singapore, based on Master Plan 2014 by URA, and provides an analyses for the gaps between the presence of medical facilities against the volume of ageing population in different planning areas.
 +
|}
  
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">BACKGROUND SURVEY OF RELATED WORKS</font></div>
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">BACKGROUND SURVEY OF RELATED WORKS</font></div>
WIP
+
Our project draws inspiration from the following past works and studies:
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
Line 48: Line 80:
 
|-
 
|-
 
|  
 
|  
<p><center>'''Reference Dataset Title 1''' </center></p>
+
<p><center>'''Age dependency ratio, old, is the ratio of older dependents--people older than 64--to the working-age population--those ages 15-64.''' </center></p>
 
+
<p><center>[[File:PastWork1.png|thumb]|500px]]</center></p>
<p><center>'''Source''': Source URL 1</center></p>
+
<p>[https://www.indexmundi.com/facts/singapore/age-dependency-ratio Data source]: World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects.</p>
||  
+
||  
WIP
+
This visualisation is supposed to depict the trend of the age dependency ratio in Singapore from 1960 to 2017. The axes are not labelled, making it hard for observers to understand the data that is being captured, at a glance.
 
|-
 
|-
| <p><center> '''Reference Dataset Title 2''' </center></p>
+
|  
 
+
<p><center> '''Resident population aged 65 and above by planning area''' </center></p>
<p><center> '''Source''': Source URL 2</center></p>
+
<p><center>[[File:Microheart Agedresident map.png|500px]]</center></p>
 +
<p><center>[https://www.singstat.gov.sg/-/media/files/publications/population/ssnsep10-pg25-29.pdf Data source]</center></p>
 
||
 
||
WIP
+
This visualisation helps users quickly identify which areas in Singapore are relatively more densely populated with the elder generation and thus are more exposed to the effects of an increased ageing population.
 
|-
 
|-
| <p><center> '''Reference Dataset Title 3''' </center></p>
+
| <p><center> '''Old Age Support Ratio -- 1970 to 2018''' </center></p>
 
+
<p><center>[[File:roas.png|500px]]</center></p>
<p><center> '''Source''': Source URL 3 </center></p>
+
<p><center>[https://www.singstat.gov.sg/find-data/search-by-theme/population/population-and-population-structure/visualising-data Data source]</center></p>
 
||  
 
||  
WIP
+
Both axes are clearly labelled. The Old Age Support Ratio is defined succinctly below the diagram so users understand. The tooltips also make the values easier to read.
 
|}
 
|}
  
Line 70: Line 103:
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 50%;" | Proposed Layout
+
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 50%;" | Proposed Layout and Methodology
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | How Analyst Can Conduct Analysis
+
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | How Analyst Can Conduct Analysis (Rationale)
 
|-
 
|-
 
|
 
|
WIP
+
<p> Main population distribution chart based on Master Plan 2014:</p>
||
+
 
WIP
+
<p><center>'''Proposed Approach'''</center></p>
|-
+
<p>
|
+
# Map out the distribution of elderly and retirees by planning area
WIP
+
# Map out the distribution of hospitals and clinics by planning area
 +
# Map out the trend of growth in elderly/retired population based on planning areas and the change in ratio of elderly to number of healthcare facilities
 +
</p>
 +
 
 +
<p>
 +
Draft Designs:
 +
</p>
 +
[[File:Microheart greenmap.PNG|300px]] [[File:Tableau map.jpg|300px]]
 +
 
 
||  
 
||  
WIP
+
* To identify how the elderly and retired population are spread across the island
|-
+
** This steps serves to identify planning areas in Singapore that house a relatively higher number of elderly/retired
|
+
* This information is to be layered on the distribution of elderly and retirees
WIP
+
* Allows analysts to view: for a certain planning area with X number of elderly/retirees, how well equipped it is in terms of fulfilling their immediate healthcare needs
||
+
* Allows analysts to predict which planning areas are likely to face a strain in terms of supporting the elderly/retirees
WIP
+
** Enables analysts to forward plan the setting up of new healthcare facilities
 
|}
 
|}
  
Line 93: Line 134:
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 50%;" | Key Technical Challenges
+
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 30%;" | Key Technical Challenges
 
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | How We Propose To Resolve
 
! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | How We Propose To Resolve
 
|-
 
|-
| <center> Technical Challenge 1 </center> ||  
+
| <center> Using D3.js to create interactive visualizations </center> ||  
Challenge 1 Description
+
Explore more on D3.js and understand how it works through available resources such as GitHub etc
 
|-
 
|-
| <center> Technical Challenge 2 </center> ||  
+
| <center> Data preprocessing </center> ||  
Challenge 2 Description
+
Research on the data required, understand which data set is most important and clean up the data
 
|-
 
|-
| <center> Technical Challenge 3 </center> ||  
+
| <center> Designing insightful Dashboard </center> ||  
Challenge 3 Description
+
Explore the possible ways of visualizing data by researching on the existing charts, graphs etc
 
|-
 
|-
| <center> Technical Challenge 4 </center> ||
 
Challenge 4 Descriptions
 
 
|}
 
|}
  
Line 115: Line 154:
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">TOOLS/TECHNOLOGIES</font></div>
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">TOOLS/TECHNOLOGIES</font></div>
 
<p>The following are some of the tools/technologies that we will be utilizing during the project:</p>
 
<p>The following are some of the tools/technologies that we will be utilizing during the project:</p>
* Excel
+
* Excel: Spreadsheet tool for data pre-processing and transformation
* Tableau
+
* Tableau: Drafting of visualization designs and preliminary iterations
* D3.js
+
* R Plotly and Shiny: Main data visualization design tool and publisher onto web-based platform
 
 
  
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">REFERENCES</font></div>
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">REFERENCES</font></div>
WIP
+
* [https://www.ura.gov.sg/Corporate/Planning/Master-Plan/Introduction Age dependency ratio]
 
+
* [https://www.singstat.gov.sg/-/media/files/publications/population/ssnsep10-pg25-29.pdf Geographic distribution of Singapore resident population]
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR BRAINSTORMING SESSIONS</font></div>
+
* [https://www.ura.gov.sg/Corporate/Planning/Master-Plan/Introduction URA Master Plan 2014]
<p>The following are some of the proposed storyboard that we designed during our brainstorming sessions:</p>
+
* [https://www.sph.nus.edu.sg/sites/default/files/ageing%20population_1.jpg Photo Reference 1]
WIP
+
* [http://www.storm.sg/wp-content/uploads/2017/08/Thus-30082-1.jpg Photo Reference 2]
 
+
* [https://2.bp.blogspot.com/-1TODZCWhMts/WAtURyYSHlI/AAAAAAAAo7Q/M6PxKjl_Yss13v-I3Xniz0dIMRXYuL89QCEw/s1600/Singapore-ageing-population-healthcare-needs.jpg Photo Reference 3]
WIP
+
* [https://www.google.com.sg/url?sa=i&source=images&cd=&cad=rja&uact=8&ved=2ahUKEwi0p_77z-7eAhXKv48KHZeXCi8QjRx6BAgBEAU&url=https%3A%2F%2Fpngtree.com%2Ffreepng%2Fvector-map-nursing-home_3108727.html&psig=AOvVaw2dTsrjx5r-17IxCB8WN_rz&ust=1543203714580219 Photo Reference 4]
 
+
* [https://vignette.wikia.nocookie.net/clubpenguin/images/e/e5/Clinic_Entrance_change_1.PNG/revision/latest?cb=20130411232347 Photo Reference 5]
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">COMMENTS</font></div>
 
<br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">COMMENTS</font></div>
 
<p>Feel free to provide us with comments, suggestions and feedback to help us improve our project! (:</p>
 
<p>Feel free to provide us with comments, suggestions and feedback to help us improve our project! (:</p>

Latest revision as of 13:34, 25 November 2018

Microheart logo.jpg


PROBLEM & MOTIVATION

Problem Description: By 2030, the elderly and retired population in Singapore is expected to be approximately 90,000 -- almost twice the current figure. Despite the government’s efforts to continuously beef up the availability and accessibility of healthcare for the elderly and retired, there needs to be a means for the government to predict the optimal number of healthcare facilities that best meets the need of our target audience.

Motivation: This project is motivated by the varying ratios of (number of elderly and retired) to number of healthcare facilities in each planning area. This brings a need to detect which planning areas require better access to healthcare facilities.


OBJECTIVES

In this project, we aim to create visualisations that helps users perform and analyse the following:

Descriptive

We would like to provide users with up-to-date demographic information, specifically pertaining to the aged population and the distribution across the different areas of Singapore (as per URA 2014). In addition, we would like to include other information, such as the presence of medical facilities and its distribution mapped out on the same planning area chart.

Prescriptive

Based on the suggested design above, we aim to be able to provide users with insights on which certain planning zones or subzones require development and emphasis on medical facilities based on the volume of ageing population staying there.

Predictive

We would like to provide users with a visibility on the trend of ageing population. Based on the dependency ratio formulated from the proportion of ageing population out of the working and economically active population, we aim to be able to predict the timeline on which the ageing situation for the country reaches a critical threshold (where ageing population forms a significant proportion out of the population).


SELECTED DATASET

The list of selected dataset that we have sourced for to input into our visualizations can be found below. Necessary data pre-processing steps will be taken to clean and transform the data into a format that is suitable to upload into a visualization.

Dataset/Source Data Attributes Rationale Of Usage
SingStat Population by Geographic Distribution Data

The dataset "Singapore Residents by Planning Area/Subzone, Age Group and Sex, June 2000 - 2018" under population trends was selected.

  • Planning Area: Character Text, planning areas segmented as per URA Master Plan 2014
  • Subzones: Character Text, sub-zones of the respective planning areas to show detail area information
  • Age Group (bins): Numerical Integer, shows the total count of individuals under the respective age groups in the respective subzones

Required dataset to show the volume of population according to the different age groups. Segmented by planning areas, sub-zones, sex and years (across the different sheets)

The dataset "Distribution of Working Population by Planning Area" was selected.
  • Planning Area: Character Text, planning areas segmented as per URA Master Plan 2014
  • Total: Numerical integer, displays the count of individuals living in that particular planning area
  • Industry: Character Text, displays the category of industry these working individuals fall under

This dataset helps ascertain the age-dependency ratio in every planning area.

Data for the locations of hospitals and polyclinics.

Locations of Polyclinics

Locations of Hospitals

  • Name of facility: Character Text, provides the title of the medical facility
  • Address: Character Text and Numerical, location address of the facility and provides information on the planning area it is located in
  • Postal Code: Numerical Integer, 6-digit postal code for the facility to determine the planning area it is situated in.

A challenge we faced for this dataset was the lack of csv/excel file on the source website. As such, the records for the locations of the medical facilities had to be manually copied onto an excel spreadsheet. Due to the relatively small number of records of medical facilities, the task is manageable. However, the risk of human error does exist for this particular methodology.

This dataset provides a distribution of medical facilities across Singapore, based on Master Plan 2014 by URA, and provides an analyses for the gaps between the presence of medical facilities against the volume of ageing population in different planning areas.


BACKGROUND SURVEY OF RELATED WORKS

Our project draws inspiration from the following past works and studies:

Related Works What We Can Learn

Age dependency ratio, old, is the ratio of older dependents--people older than 64--to the working-age population--those ages 15-64.

thumb]

Data source: World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects.

This visualisation is supposed to depict the trend of the age dependency ratio in Singapore from 1960 to 2017. The axes are not labelled, making it hard for observers to understand the data that is being captured, at a glance.

Resident population aged 65 and above by planning area

Microheart Agedresident map.png

Data source

This visualisation helps users quickly identify which areas in Singapore are relatively more densely populated with the elder generation and thus are more exposed to the effects of an increased ageing population.

Old Age Support Ratio -- 1970 to 2018

Roas.png

Data source

Both axes are clearly labelled. The Old Age Support Ratio is defined succinctly below the diagram so users understand. The tooltips also make the values easier to read.


PROPOSED STORYBOARD
Proposed Layout and Methodology How Analyst Can Conduct Analysis (Rationale)

Main population distribution chart based on Master Plan 2014:

Proposed Approach

  1. Map out the distribution of elderly and retirees by planning area
  2. Map out the distribution of hospitals and clinics by planning area
  3. Map out the trend of growth in elderly/retired population based on planning areas and the change in ratio of elderly to number of healthcare facilities

Draft Designs:

Microheart greenmap.PNG Tableau map.jpg

  • To identify how the elderly and retired population are spread across the island
    • This steps serves to identify planning areas in Singapore that house a relatively higher number of elderly/retired
  • This information is to be layered on the distribution of elderly and retirees
  • Allows analysts to view: for a certain planning area with X number of elderly/retirees, how well equipped it is in terms of fulfilling their immediate healthcare needs
  • Allows analysts to predict which planning areas are likely to face a strain in terms of supporting the elderly/retirees
    • Enables analysts to forward plan the setting up of new healthcare facilities


ADDRESSING KEY TECHNICAL CHALLENGES

The following are some of the key technical challenges that we may face throughout the course of the project:

Key Technical Challenges How We Propose To Resolve
Using D3.js to create interactive visualizations

Explore more on D3.js and understand how it works through available resources such as GitHub etc

Data preprocessing

Research on the data required, understand which data set is most important and clean up the data

Designing insightful Dashboard

Explore the possible ways of visualizing data by researching on the existing charts, graphs etc


PROJECT TIMELINE

The following shows our project timeline for the completion of this project:

Va timeline.jpg


TOOLS/TECHNOLOGIES

The following are some of the tools/technologies that we will be utilizing during the project:

  • Excel: Spreadsheet tool for data pre-processing and transformation
  • Tableau: Drafting of visualization designs and preliminary iterations
  • R Plotly and Shiny: Main data visualization design tool and publisher onto web-based platform


REFERENCES


COMMENTS

Feel free to provide us with comments, suggestions and feedback to help us improve our project! (: