Difference between revisions of "DreamWorks: Proposal"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<!-- Header Start -->
 
<!-- Header Start -->
 
{|style="background-color:#1E6DA9; color:#000000; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |
 
{|style="background-color:#1E6DA9; color:#000000; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |
| style="padding:0.3em; font-size:100%; background-color:#1E6DA9;  border-bottom:0px solid #000000; text-align:center; color:#fffff" width="19%" |
 
[[DreamWorks|<font color="#fffff" size=2><b>ABOUT US</b></font>]]
 
  
 
| style="border-bottom:0px solid #000000; background:none;" width="1%" |
 
| style="border-bottom:0px solid #000000; background:none;" width="1%" |
| style="padding:0.3em; font-size:100%; background-color:#0A3E66;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="19%" |  
+
| style="padding:0.3em; font-size:100%; background-color:#0A3E66;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="24%" |  
 
[[DreamWorks: Proposal|<font color="#fffff" size=2><b>PROPOSAL</b></font>]]
 
[[DreamWorks: Proposal|<font color="#fffff" size=2><b>PROPOSAL</b></font>]]
  
 
| style="border-bottom:0px solid #000000; background:none;" width="1%" |
 
| style="border-bottom:0px solid #000000; background:none;" width="1%" |
| style="padding:0.3em; font-size:100%; background-color:#1E6DA9;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="19%" |  
+
| style="padding:0.3em; font-size:100%; background-color:#1E6DA9;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="24%" |  
 
[[DreamWorks: Poster|<font color="#fffff" size=2><b>POSTER</b></font>]]
 
[[DreamWorks: Poster|<font color="#fffff" size=2><b>POSTER</b></font>]]
  
 
| style="border-bottom:0px solid #000000; background:none;" width="1%" |
 
| style="border-bottom:0px solid #000000; background:none;" width="1%" |
| style="padding:0.3em; font-size:100%; background-color:#1E6DA9;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="19%" |  
+
| style="padding:0.3em; font-size:100%; background-color:#1E6DA9;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="24%" |  
 
[[DreamWorks: Application|<font color="#fffff" size=2><b>APPLICATION</b></font>]]
 
[[DreamWorks: Application|<font color="#fffff" size=2><b>APPLICATION</b></font>]]
  
 
| style="border-bottom:0px solid #000000; background:none;" width="1%" |
 
| style="border-bottom:0px solid #000000; background:none;" width="1%" |
| style="padding:0.3em; font-size:100%; background-color:#1E6DA9;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="19%" |  
+
| style="padding:0.3em; font-size:100%; background-color:#1E6DA9;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="24%" |  
 
[[DreamWorks: Research Paper|<font color="#fffff" size=2><b>RESEARCH PAPER</b></font>]]
 
[[DreamWorks: Research Paper|<font color="#fffff" size=2><b>RESEARCH PAPER</b></font>]]
 
|}
 
|}
Line 27: Line 25:
  
 
<p>
 
<p>
The team recognizes that Singaporean generally has a high-interest to understand the Singapore real estate properties. However, the only reliable source is to rely on the Housing Development Board (HDB)'s website to find out more about the new block launches or the average pricing of flats within an area. The usual website that is frequented to find out information about a HDB block is accessed through this link: [https://services2.hdb.gov.sg/web/fi10/emap.html HDB Website]
+
The Housing Development Board (HDB) is the primary source of information for all things related to housing estates in Singapore. However, the team identifies that there is a lack of context in the understanding of how the Singapore population influences the price of resale and rental in Singapore. Hence, the team would like to identify trends that would highlight the fluctuations in price and present a visual representation of the relevant data that is publicly available.
</p>
 
 
 
<p>
 
A similar visualization was made on Tableau Public and is published by HX Chua through a Hackathon known as DataDriven.sg.[https://public.tableau.com/profile/hx.chua#!/vizhome/hackathon_3/Dashboard1]
 
The team would like to make some changes that would increase the fidelity of the dashboard and make a remodeled visualization that would improve readability and present insights that would be more crucial to users seeking such information.
 
 
</p>
 
</p>
  
 
<br/>
 
<br/>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR DATA</font></div>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR DATA</font></div>
TEST
+
 
 +
{| class="wikitable"
 +
|-
 +
! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | Sources
 +
! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Data name
 +
! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Purpose
 +
|-
 +
|| [https://data.gov.sg/ Data.gov.sg]
 +
|| [https://data.gov.sg/dataset/master-plan-1998-subzone-boundary-no-sea Planning Zone & Subzone]
 +
|| Extract data to form the Singapore Map for data association.
 +
|-
 +
|| [https://data.gov.sg/ Data.gov.sg]
 +
|| [https://data.gov.sg/dataset/estimated-resident-population-living-in-hdb-flats Singapore Population Living in HDB Flats]
 +
|| Extract data to analyze Singapore population currently residing in HDB flats by planning zones.
 +
|-
 +
|| [https://data.gov.sg/ Data.gov.sg]
 +
|| [https://data.gov.sg/dataset/median-rent-by-town-and-flat-type Median Rent by Town & Flat type]
 +
|| Extract data to analyze median rent rate by town and flat type.
 +
|-
 +
|| [https://data.gov.sg/ Data.gov.sg]
 +
|| [https://data.gov.sg/dataset/median-resale-prices-for-registered-applications-by-town-and-flat-type Median Resale Price for Registered Application by Town & Flat type]
 +
|| Extract data to analyze median resale price by town and flat type.
 +
|-
 +
|| [https://www.singstat.gov.sg/ Singstat]
 +
|| [https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data Geographic Distribution of Singapore]
 +
|| Extract data to analyze Singapore population for each dwelling type within Singapore's 2014 Planning Zones
 +
|}
  
 
<br/>
 
<br/>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR BACKGROUND SURVEY</font></div>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR BACKGROUND SURVEY</font></div>
TEST
+
 
 +
<b>1.</b> Housing Development Board - Map Service
 +
[https://services2.hdb.gov.sg/web/fi10/emap.html HDB Map Service]
 +
<p>
 +
The map service provides instant access to understand various property-related information such as facilities in the vicinity, resale price, and rental rate.
 +
However, the map is useful only for searching for specific buildings in a location but not as a platform for storytelling and visualization.
 +
</p>
 +
[[File:HDB Dreamworks.png‎|500px|center]]
 +
 
 +
 
 +
<b>2.</b> Datadriven.sg hackathon - a look at Singapore's property prices
 +
[https://public.tableau.com/profile/hx.chua#!/vizhome/hackathon_3/Dashboard1 Tableau Public]
 +
<p>
 +
The visualization is created by HX Chua for the hackathon as indicated above on Oct 22, 2016. The visualization endeavors to create an analysis tool to identify patterns and trends for the rise and fall of resale price and rental rates in Singapore property based on flat type. The project gathered data from Data.gov.sg and PropertyGuru.com.
 +
</p>
 +
[[File:Tableau Dreamworks.png‎|500px|center]]
 +
 
 +
 
 +
<b>3.</b> Visualization of Population in Singapore
 +
[https://www.citypopulation.de/php/singapore-admin.php Singapore City Population by Planning Area]
 +
<p>
 +
The visualization provides an overview of the resident population in the urban planning areas and subzones in Singapore according to census results and latest official estimates. It serves well to be used as a reference to showcase the density of the population in each Singapore's Planning Area and Subzones. The visualization also incorporates a table to showcase the exact value for the population that resides in a given location.
 +
</p>
 +
[[File:CityPop Dreamworks.png‎|500px|center]]
 +
 
 +
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">DASHBOARD IDEATION</font></div>
 +
 
 +
<br>
 +
{| style="margin-left: auto; margin-right: auto; border: none;"
 +
|-
 +
| [[File:Slide1_Dreamworks.png|400px|center]] || [[File:Slide2_Dreamworks.png|400px|center]] || [[File:Slide3_Dreamworks.png|400px|center]]
 +
|}
  
 
<br/>
 
<br/>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR CHALLENGES</font></div>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR CHALLENGES</font></div>
TEST
+
{| class="wikitable"
 +
|-
 +
! Potential Challenges !! Issues !! Mitigation
 +
|-
 +
| <b>1.</b> Lack of Domain Knowledge || Singapore real estate is a challenging topic to cover, given that there are alot of external factors that affect a property's value. || Learn more from HDB and understand trends from exsisting data sources.
 +
|-
 +
| <b>2.</b> Data Constraints || There are few access to datasets where it is comprehensive enough to cover the real estate industry in Singapore. || Make do with what we can find from Singapore's exsisting data sources such as Data.gov and Sing Stat.
 +
|-
 +
| <b>3.</b> Experience with R Programming|| Our members are new to R programming and it will take some time to fully understand the new programming language. || Anticipate risks when using R packages, and rely on Prof Kam's notes and stack overflow for directions.
 +
|}
  
 
<br/>
 
<br/>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR PROPOSED MILESTONES</font></div>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR PROPOSED MILESTONES</font></div>
TEST
+
<br>
 +
{| style="margin-left: auto; margin-right: auto; border: none;"
 +
|-
 +
| [[File:Tasklist_Dreamworks.png|500px|center]] || [[File:Timeline_Dreamworks.png|500px|center]]
 +
|}
  
 
<br/>
 
<br/>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">COMMENTS</font></div>
 
<div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">COMMENTS</font></div>
 
Feel free to comment!
 
Feel free to comment!

Latest revision as of 18:36, 17 November 2019

PROPOSAL

POSTER

APPLICATION

RESEARCH PAPER



PROBLEM & MOTIVATION

The Housing Development Board (HDB) is the primary source of information for all things related to housing estates in Singapore. However, the team identifies that there is a lack of context in the understanding of how the Singapore population influences the price of resale and rental in Singapore. Hence, the team would like to identify trends that would highlight the fluctuations in price and present a visual representation of the relevant data that is publicly available.


OUR DATA
Sources Data name Purpose
Data.gov.sg Planning Zone & Subzone Extract data to form the Singapore Map for data association.
Data.gov.sg Singapore Population Living in HDB Flats Extract data to analyze Singapore population currently residing in HDB flats by planning zones.
Data.gov.sg Median Rent by Town & Flat type Extract data to analyze median rent rate by town and flat type.
Data.gov.sg Median Resale Price for Registered Application by Town & Flat type Extract data to analyze median resale price by town and flat type.
Singstat Geographic Distribution of Singapore Extract data to analyze Singapore population for each dwelling type within Singapore's 2014 Planning Zones


OUR BACKGROUND SURVEY

1. Housing Development Board - Map Service HDB Map Service

The map service provides instant access to understand various property-related information such as facilities in the vicinity, resale price, and rental rate. However, the map is useful only for searching for specific buildings in a location but not as a platform for storytelling and visualization.

HDB Dreamworks.png


2. Datadriven.sg hackathon - a look at Singapore's property prices Tableau Public

The visualization is created by HX Chua for the hackathon as indicated above on Oct 22, 2016. The visualization endeavors to create an analysis tool to identify patterns and trends for the rise and fall of resale price and rental rates in Singapore property based on flat type. The project gathered data from Data.gov.sg and PropertyGuru.com.

Tableau Dreamworks.png


3. Visualization of Population in Singapore Singapore City Population by Planning Area

The visualization provides an overview of the resident population in the urban planning areas and subzones in Singapore according to census results and latest official estimates. It serves well to be used as a reference to showcase the density of the population in each Singapore's Planning Area and Subzones. The visualization also incorporates a table to showcase the exact value for the population that resides in a given location.

CityPop Dreamworks.png
DASHBOARD IDEATION


Slide1 Dreamworks.png
Slide2 Dreamworks.png
Slide3 Dreamworks.png


OUR CHALLENGES
Potential Challenges Issues Mitigation
1. Lack of Domain Knowledge Singapore real estate is a challenging topic to cover, given that there are alot of external factors that affect a property's value. Learn more from HDB and understand trends from exsisting data sources.
2. Data Constraints There are few access to datasets where it is comprehensive enough to cover the real estate industry in Singapore. Make do with what we can find from Singapore's exsisting data sources such as Data.gov and Sing Stat.
3. Experience with R Programming Our members are new to R programming and it will take some time to fully understand the new programming language. Anticipate risks when using R packages, and rely on Prof Kam's notes and stack overflow for directions.


OUR PROPOSED MILESTONES


Tasklist Dreamworks.png
Timeline Dreamworks.png


COMMENTS

Feel free to comment!