Difference between revisions of "ISSS608 2016-17 T1 Assign1 XU Qiuhui"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 19: Line 19:
  
 
== Dataset Variables ==
 
== Dataset Variables ==
 +
Dataset contain following variables:
 +
{| class="wikitable sortable"
 +
|-
 +
! Variables !! Description
 +
|-
 +
| Month || It's the date of registration, in the format of 'yyyy-mm'.
 +
|-
 +
| Town || Shows the location of the flat by town.
 +
|-
 +
| Flat Type || Includes 7 type of HDB flat
 +
|-
 +
| Block || Shows the block number of the flat
 +
|-
 +
| Street Name || Shows the street name that the flat located
 +
|-
 +
| Story Range || Divide story into 25 ranges, in the format of 'xx To xx"
 +
|-
 +
| Floor Area sqm || Shows flat area in square meters.
 +
|-
 +
| Flat Model || Shows the model type of the flat, including 19 types of models.
 +
|-
 +
| Lease Commencement Date || It is the date that the flat first time push into market.
 +
|-
 +
| Resale Price || It is the total price of the flat.|-
 +
| Example || Example
 +
|}
 +
 +
<br/>
  
 
== Data Modelling ==
 
== Data Modelling ==

Revision as of 12:24, 29 August 2016

Abstract

This report focuses on analysis of resale public housing market, 5 factors, flat type, flat size, flat age, flat location, resale price per sqm, are considered.


Problem and Motivation

Huge influence and fast changing make resale public housing market one of the most concerned market by Singapore residents. This report is aimed to provide visualized analysis to

  • help buyers get good knowledge of resale public housing market price distribution break down by flat type, location, flat age, etc. to choose the most suitable house according to their particular conditions;
  • let sellers acknowledged with resale public housing market trends of both supply and price, to sell their house in a good time and price;
  • help investors find houses with highest investment potential


Data

Data Acquisition

Dataset Resale Transaction by Flat Type (based on registered cases) is downloaded in csv directly from data.gov.sg.


Dataset Variables

Dataset contain following variables:

Variables Description
Month It's the date of registration, in the format of 'yyyy-mm'.
Town Shows the location of the flat by town.
Flat Type Includes 7 type of HDB flat
Block Shows the block number of the flat
Street Name Shows the street name that the flat located
Story Range Divide story into 25 ranges, in the format of 'xx To xx"
Floor Area sqm Shows flat area in square meters.
Flat Model Shows the model type of the flat, including 19 types of models.
Lease Commencement Date It is the date that the flat first time push into market.
Resale Price - Example Example


Data Modelling

Approaches

General Colour Scheme for Charts

Data Analysis

Share of the resale public housing supply in 2015

Distribution of the resale public housing prices in 2015

Comparison of patterns of the first-half of 2016 with the patterns of 2015

Infographics



Tools Utilised

  1. SAS JMP 12 – for initial data exploration and analysis
  2. Tableau 10.0 – for charting
  3. Microsoft Powerpoint – for Infographics layout



Results


Retrieved from ‘https://wiki.smu.edu.sg/1617t1ISSS608g1/index.php?title=ISSS608_2016-17_T1_Assign1_XU_Qiuhui&oldid=1623’