Difference between revisions of "IS428 2016-17 Term1 Assign1 Wang Jingxuan"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 31: Line 31:
 
Transactions of property in 2015 directly answered our most concerning question:how was property selling and buying in 2015?<br />
 
Transactions of property in 2015 directly answered our most concerning question:how was property selling and buying in 2015?<br />
 
[[Image:Quarterly_property_supply.png]]<br/>
 
[[Image:Quarterly_property_supply.png]]<br/>
 +
Total units in projects keeps dropping from 29% to 21% over 4 quarters. The decreasing trend indicates a slow down in property supply.
 
[[Image:Quarterly_property_projects.png]]<br/>
 
[[Image:Quarterly_property_projects.png]]<br/>
 
[[Image:Quarterly_property_transactions.png]]<br/>
 
[[Image:Quarterly_property_transactions.png]]<br/>

Revision as of 04:56, 29 August 2016

Abstract

Problem & Motivation

We know that private property pricing in Singapore has been rather high due to its land limit, and its government has introduced a series of cooling measures. Some people believe in the value of private property, some people say the value of property is decreasing. Through exploring the private property supply and demand in 2015, we want to answer these questions:

  • For buyers, is it a good time to invest in private property, what and where should they invest?
  • For policy makers, is it a good time to further constrain the supply of property, and what type of property?

Tools

Approaches

Data Selection and Preparation

Data Source: The data sources selected are:

  • Transactions of Private Residential Property in 2015
  • Quarterly Supply of Private Residential Properties in 2015

There is no raw data for supply grouped by dates, region and area. In order to collect data from database REALIS, I have to select region then select quarter. It was very troublesome as I can only download one file of data in one region or area during one quarter, then I combined and merged all the downloaded files together as integrated data for exploration.
Data collection.png
The downloaded transactions are in 18 files so when I explored data, I have to union them.
Union transactions.png

The quarterly supply of private residential properties downloaded are in 4 csv files, and each file contains a quarterly supply data. However quarterly supply data does not contain quarter number so I added in quarter parameter in csv files, then I unioned them with tableau.

General Trend

Transactions of property in 2015 directly answered our most concerning question:how was property selling and buying in 2015?
Quarterly property supply.png
Total units in projects keeps dropping from 29% to 21% over 4 quarters. The decreasing trend indicates a slow down in property supply. Quarterly property projects.png
Quarterly property transactions.png
Transactions of property.png
Quarterly transaction price.png
Quarterly unit price.png
This graph shows number of transactions over 4 quarters. The first quarter contains least number of transactions, and the 3rd quarter contains the largest number of transactions.

Geographical Location

Geographic.png Regional property transactions.png Transaction number over area.png SengKang.png Total transacted price.png Bukit Timah.png

Recommendations

Inforgraphics

Comments