Difference between revisions of "Microheart"
Line 28: | Line 28: | ||
<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> | ||
− | 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 | + | 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%" | ||
Line 90: | Line 90: | ||
{| 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) |
|- | |- | ||
| | | | ||
− | + | <p> Main population distribution chart based on Master Plan 2014:</p> | |
+ | |||
+ | <p><center>'''Proposed Approach'''</center></p> | ||
+ | <p> | ||
+ | # Map out the distribution of elderly and retirees by planning area | ||
+ | # 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> | ||
|| | || | ||
− | + | * 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 | ||
|- | |- | ||
| | | |
Revision as of 21:54, 13 October 2018
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.
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).
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 |
---|---|---|
The dataset "Singapore Residents by Planning Area/Subzone, Age Group and Sex, June 2000 - 2018" under population trends was selected. |
|
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 |
WIP |
WIP |
Our project draws inspiration from the following past works and studies:
Related Works | What We Can Learn |
---|---|
|
WIP |
WIP | |
WIP |
WIP
Proposed Layout and Methodology | How Analyst Can Conduct Analysis (Rationale) |
---|---|
Main population distribution chart based on Master Plan 2014:
|
|
WIP |
WIP |
WIP |
WIP |
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 |
---|---|
Explore more on D3.js and understand how it works through available resources such as GitHub etc | |
Research on the data required, understand which data set is most important and clean up the data | |
Explore the possible ways of visualizing data by researching on the existing charts, graphs etc |
The following shows our project timeline for the completion of this project:
The following are some of the tools/technologies that we will be utilizing during the project:
- Excel
- Tableau
- D3.js
- JMP Pro
WIP
Feel free to provide us with comments, suggestions and feedback to help us improve our project! (: