Difference between revisions of "Group11 proposal V2"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
(Created page with "<div style="margin-bottom:30px;">200px|frameless|center</div> <!--Header--> {|style="background-color:#343436; color:#4d79ff; padding: 10 0 10 0;" w...")
 
Line 65: Line 65:
 
==<div style="background: #121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Agency FB; "><font color= #00ffd5><center>Data Set(s) Used</center></font></div>==
 
==<div style="background: #121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Agency FB; "><font color= #00ffd5><center>Data Set(s) Used</center></font></div>==
 
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 
{| class="wikitable" style="margin-left: auto; margin-right: auto; width: 90%;
 
|-
 
! style="font-family:Agency FB; font-weight: bold;background: #00ffd5;color: #121f29;width: 30%;font-size:18px;" |DataSource
 
! style="font-family:Agency FB; font-weight: bold;background: #273746;color: #00ffd5;width: 15%;font-size:18px;" |Data Attribute
 
! style="font-family:Agency FB; font-weight: bold;background: #273746;color: #00ffd5;width: 15%;font-size:18px;" |Data Description
 
! style="font-family:Agency FB; font-weight: bold;background: #00ffd5;color: #121f295;width: 40%;font-size:18px;" |Rationale of Usage
 
|-
 
| rowspan='10'|
 
<center>
 
HDB Resale Flat Prices
 
</br>'''[2012 - 2020]'''
 
https://data.gov.sg/dataset/resale-flat-prices
 
</center>
 
| <center>Month
 
| <center>Year-Month label
 
| rowspan='10'|
 
To attain valuable insights on Resale HDB Real estate prices which can be classified by the following </br>
 
# Resale Prices trend by location
 
# Cost Per Square Metre (PSM)
 
# Maturity of estate
 
# Area size and floor level vs Price
 
|-
 
| <center>Town
 
| <center>The various Singapore estates that have HDBs
 
|-
 
| <center>Flat Type
 
| <center>The types of HDB Flats in terms of number of rooms in the flat
 
|-
 
| <center>Block
 
| <center>The block numbers of each HDB flat
 
|-
 
| <center>Street Name
 
| <center>The various street names where the HDB flats are located
 
|-
 
| <center>Floor Area sqm (SQM)
 
| <center>The overall floor size of the HDB flat
 
|-
 
| <center>Flat Model
 
| <center>The phase in which the HDB flat is categorized under
 
|-
 
| <center>Lease Commence Date
 
| <center>Date lease begins for the HDB flat
 
|-
 
| <center>Remaining Lease
 
| <center>The number of years left for the HDB flat is reclaimed back by the government
 
|-
 
| <center>Resale Price
 
| <center>The price after the HDB is sold
 
|}
 
 
</div>
 
  
 
==<div style="background: #121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Agency FB; "><font color= #00ffd5><center>Background Survey</center></font></div>==
 
==<div style="background: #121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Agency FB; "><font color= #00ffd5><center>Background Survey</center></font></div>==
Line 130: Line 78:
 
<center>
 
<center>
 
</br>
 
</br>
[[File:2nd.PNG|frameless|600px|center]]
+
 
 
</br>
 
</br>
 
</center>
 
</center>
 
||  
 
||  
* The time-series chart used provides a detailed overview of the trending price index of HDB resale flats as each plotted point follows a quarter/year timeline. However, showing each year’s quarter does make the x-axis legend hard to process upon a quick glance.
+
* New Insights / Comparisons and what to do better
* This chart could  be further improved by adding a filtered selection to view the quarters for a specific year rather than all quarters for the 25 years displayed.
 
* Also, an average reference line could be added to provide a benchmark for the various price
 
 
|-
 
|-
 
|
 
|
 
<center>
 
<center>
 
</br>
 
</br>
[[File:3rd.PNG|frameless|600px|center]]
+
 
 
</br>
 
</br>
 
</center>
 
</center>
 
||  
 
||  
* Although the use of HDB flat icons on the map does help in depicting the cluster of HDB flats in the specified area, however, it makes the visualisation too cluttered which impacts the map visuals as the street names / landmarks might be blocked.
+
* New Insights / Comparisons and what to do better
 
|-
 
|-
 
|  
 
|  
 
<center>
 
<center>
 
</br>
 
</br>
[[File:4th.PNG|frameless|600px|center]]
+
 
 
</br>
 
</br>
 
</center>
 
</center>
 
||  
 
||  
* The heatmap provided good sectioning of HDB densities across singapore, however a lighter grey shade of the planning areas that are not highlighted could be included.
+
* New Insights / Comparisons and what to do better  
* With this addition it could depict a better idea on where the densities of HDBs are close to which other areas for route planning or even workplace mapping.
+
**  
* The various colours used might not be a clear representation of exactly how dense the HDB planning area is.
 
* A gradual gradient of single colour could be used:
 
** darkest tone → lightest tone (Most dense town → Least dense town respectively)
 
 
|-
 
|-
 
|
 
|
 
<center>
 
<center>
 
</br>
 
</br>
[[File:5th.PNG|frameless|600px|center]]
+
 
 
</br>
 
</br>
 
</center>
 
</center>
 
||  
 
||  
* The use of pin-drop allows the user to get a visual representation of the landmarks in the area and the details provided in the visualisation are plentiful.
+
* New Insights / Comparisons and what to do better  
* However, the most important detail, pricing is not included which may defer users from utilising this platform to compare prices.
 
* The cluttered pins and multi-colour pins may be confusing to the user and the differences are not clear at first glance for a HDB buyer.
 
|-
 
|
 
<center>
 
</br>
 
[[File:6th.PNG|frameless|600px|center]]
 
</br>
 
</center>
 
||
 
* The use of legends helps to tell which lines belong to which estate but the use of too many colours might detract viewers from the main purpose of the visualisation
 
|-
 
|
 
<center>
 
</br>
 
[[File:7th.png|frameless|600px|center]]
 
</br>
 
</center>
 
||
 
* Here, the use of the treemap is good in terms of the colour-shading as appropriate colours are used depict the varying resale prices
 
** (Red → High Resale Prices)
 
** (Green → Average to Low Resale Prices)
 
* What’s lacking in this treemap is a little more in-depth information on the type of HDBs within the planning areas stated.
 
* The colour of the font used could be of a better choice to allow easy viewing
 
* It would be good to let viewers gain insight on which type of HDBs tend toward higher resale prices for future planning if home dwellers decide to sell the house at a later time
 
 
 
 
|}
 
|}
 
</div>
 
</div>

Revision as of 14:15, 27 March 2020

WeHouse Logo.png

Proposal

 

Poster

 

Application

 

Research Paper

 

Roles


Version 1

 

Version 2


Problem

Cheatsheet.jpg

The above is an example of information online in helping Singaporeans decide the type of house they could choose from. In the context of this project, Resale HDBs is the focal point of our project. Choosing a resale HDB has never been easy as there are many factors to consider such as location, HDB type, number of remaining lease years, resale value, etc. On top of that, thousands of Resale HDBs transactions are happening each month, making it almost impossible for an owner to get a view of every transaction. Therefore, the majority of buyers and/or sellers have to consult property agents for their services.

However, there are times where the service of a property agent may not be satisfactory to the buyer and/or seller. It is still advisable for the buyer and/or seller to have a better understanding of the resale market before making an informed decision. In most cases, people tend to rely on multiple platforms to help them in understanding and predicting the market trend. On that note, our team would like to know whether the information provided to them is truly insightful or usable. Thus, WeHouse comes into play to provide greater insights for people to better understand the HDB resale market which can provide better aid in making more informed decisions.

Motivation

Given the abundance of information available on the internet in terms of resale prices, there are online resources provided to map out HDB locations and prices. However, such visualisations tend to be overwhelming due to vast data and non-specialised focus on visualisations. Throughout the course, we have learned how to discern between a good and bad visualised graph. This has allowed us to decide the usefulness of the charts displayed on various platforms. Therefore, instead of leaving people unsettled about the kind of housing choice to make, we are here to aid with our proposed visualisations! Coupled with the hands-on in-class sessions, we are able to reinforce what we learnt to play and explore re-organisation of the data to present an interactive dashboard, specifically pertaining to HDB dwellings, to empower users to make better-informed choices of their HDB location.

Objectives

In this project, we aim to deliver a focused and compact visualisation to allow Singaporeans to be well-informed of the average HDBs resale prices around their desired location.

  1. Overall changes in the flat prices over time for each subzone by estates.
  2. Price differences for each estate and subzone depending on the remaining lease of the flat.
  3. Find out which month sells at the highest and lowest resale price and transactions
  4. Specifically identify the most expensive street within each town area

Data Set(s) Used

Background Survey


Example Takeaways



  • New Insights / Comparisons and what to do better



  • New Insights / Comparisons and what to do better



  • New Insights / Comparisons and what to do better



  • New Insights / Comparisons and what to do better

List of References

Proposed Storyboard


Dashboards Rationale

Dashboard 1: Overview of Resale Trend in Singapore Volume VS Price
Sketch1.jpg


  • With the 1st dashboard, we will go with a dual axis bar and line chart to provide an overview on the trending HDB resale pricing over a series of 8 years.
  • Each of the bars will depict the average resale prices per year coupled with a trending line that will depict if the resale prices are increasing or decreasing over the years.
  • We have also included a side-bar that will enable users to filter their view of the trending resale prices of a specific town area in singapore.

Dashboard 2: Tree Map of Room Cost Vs Area
Sketch3.jpg


  • The 2nd dashboard aims at providing insight on how the HBD densities are segregated by the various towns within Singapore.
  • With the use of a Treemap, we can depict the volume of HDBs by the size of each rectangular portion on the Treemap, upon clicking onto a specific town area, a box plot chart pop-up provides a detailed understanding of the averaging resale prices across the various HDB room types.

Dashboard 3: Animated Visualisation Heat Map of Singapore's HDB PSF Cost
Sketch2.jpg
Reference.gif


  • We are intending to use an animated version with a static map that illustrates the variations in the changing cost Per Square Feet (PSF) in generalised land marks
  • With the animated version, we are able to note the trend of changing cost PSF in each area
  • Together with the static version, any Singaporeans would be asble to understand the cost of HDB in each respective area

Technologies Used

Our Current Timeline

Key Technical Challenges

Challenges Actions Taken

Unfamiliarity with R Shiny and little knowledge of R

  • Recap on R through past slides and exercises
  • Learning of R shiny will be done through class lessons and weekly use of Datacamp to further reinforce the learning.

Limited knowledge in storyboard designing

Explore online resource through Tableau Public / Viz CookBook and Datacamp


Lack of postal code provided in the data

Use of OneMap API, together with python script, to retrieve Postal Codes of the Area and Street level. However, Postal Codes are insufficient for Tableau to zoom into street level visualization.

  • Hence, we will use QGIS learnt in SMT 201 for better visualisation.

Team Milestones

Our Current Timeline


Comments

Do Leave a Comment on how we can improve :)
No. Name Comments

1

Name

Insert Comment Here

2.

Name

Insert Comment Here

3.

Name

Insert Comment Here