HomeIntel

Team

Proposal

Poster

Application

Research Paper

<--- Go Back to Project Groups

Selected Dataset

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

Dataset/Source	Data Attributes	Rationale of Usage
Resale Flat Price (Jan 2015 - Aug 2019) (https://data.gov.sg/dataset/resale-flat-prices?resource_id=42ff9cfe-abe5-4b54-beda-c88f9bb438ee)	Month Town Flat type Block Street Name Storey range Floor Area sqm Flat Model Lease Commence Date Remaining Lease Resale Price	This dataset will be used to understand the resale transacted price and see the price trend change over year.

Background Survey

Our team did background research on the topic before creating the storyboards. It will expose us to the different types of charts and graphs that we can use for the project and consider how we can make it better. Some of the visualisations that we draw inspiration from are as follows:

Reference of Other Interactive Visualization	Learning Points
Title: Historical Average of HDB Resale Prices in Ang Mo Kio Source: https://getaflat.herokuapp.com/charts	This is a time-series chart which allow users to see the trend in resale prices by room type over time The axis titles are missing We will be using this chart as a reference and improving it by adding filters such as the age of flat and story range
Title: Distribution of 4-Room HDB Resale Prices By Town Source: https://public.tableau.com/profile/priyadarsan.shankar#!/vizhome/Singapore4-ROOMHDBresalepricesvisualization/HDBdashboard	The box plots can be used to identify towns with high median resale prices Outliers can be identified easily and we can see if the data is skewed
Title: Singapore Property Prices Heatmap Source: https://www.greyloft.com/singapore/property-prices-heatmap	The heatmap focuses on the price per square foot by district. Users can select the date range The tooltips provide more information on the trend, the number of transactions and towns within the district Easy to interpret the chart and the legends are useful. The Central area stands out well. Good colour choice to represent the high price per sqf We will do a heatmap on the average resale price by town and provide more information in the tooltip
Title: Heat Map of Median Resale Price Source: https://public.tableau.com/profile/darrick8462#!/vizhome/HDBResaleAnalysisDDO/HDBRESALEDASHBOARD	The heat map shows the relationship between flat type and the storey range We can improve this further by creating a heatmap based on an additional field called Estate Type (mature and non-mature estates)

Proposed Dashboard

Our group has proposed the following storyboard in our Visual Application:

Dashboards	Rationale
Storyboard 1: Overview of Resale Price Trends	As this is the 1st storyboard, we would like to provide the reader with the big picture of resale prices before narrowing down the scope. The aim of this dashboard is to show the resale price trends and to allow the user to identify areas that are more expensive. Users can filter by year/month, region, town, flat type and age. When the user hovers over the map, the average floor area in sqm, the average price per sqm and the number of transactions will be displayed.
Storyboard 2: Key Factors Affecting Resale Prices	The aim of this dashboard is to find out if variables such as flat type, storey range, and region can influence the resale price. The same filters used in the previous storyboard can be used for this storyboard.
Storyboard 3: Past HDB Resale Transactions	There are pros and cons in buying a new home in a mature and non-mature estate. Towns that have been around for more than 20 years are deemed mature. The aim of this dashboard is to make comparisons between the 2 estate types and see if there are any distinct differences in terms of pricing and floor area. The user can also see the seasonal trend of people selling their homes

Challenges

Challenges	Description	Mitigation Plan
Unfamiliarity of Visualization Technologies such as Tableau, R,Rshiny etc.	We are new to R and RShiny and we are not sure of its capabilities	Independent Hands-on Practice via online resources such as Datacamp Ask team mates for help

Comments

Name	Comments
Your Name	Comment
Your Name	Comment