IS428 2016-17 Term1 Assign1 Ong Ming Hao

Problem & Motivation

A recent study done by the Economist Intelligence Unit (EIU) in 2016 found out that Singapore is the most expensive city in the world. [1] This report is done by comparing the cost of living in New York City with Cities around the world. From housing, food, education, etc.
In addition, according to the Singapore Real Estate Exchange, it found out that the median price for an executive apartment in Singapore is $626,000. [2] At this price, many Singaporeans would find it hard to buy a house and start their own families. Singaporeans should not have to take up exorbitant loans for basic housing. As such, the focus of this article is to examine and analyse the following:

1. Singapore Property Market
2. Current Government Plans
3. Current Government Policies

By doing so, we are able to determine whether the government is doing is effective job in bringing the price of the Singapore’s Housing Market, and what more can be done to reduce the price of the average Singapore property.

Targeted Data & Policies

Rationale for choosing Data

I have chosen a few data sets from REALIS. The first data set is a list of private property transactions done in 2015. This would help me identify any trends in the private property market, in terms of location, type of housing or pricing per square foot. The next set of data that I want to analyse is vacancy and vacancy rate of private property and the amount of private property projects in progress. This would help me identify places of interest where the government should reduce building in, or change the type of building (commercial, businesses,parks,residential,etc.)

Initial Data Cleaning

Some data that I retrieved from REALIS was needed to be appended together. Such as determining the vacancy rate and vacancy of Condominiums. As such, I had to do some data cleaning to ensure that Tableau was able to read the information.

Targeted Policies

The primary policy that i would be looking into is the Master Plan by the Urban Redevelopment Authority (URA). The master plan is the plan which is renewed by the URA every 5 years, which outlines and dictates where parks, commercial buildings, businesses and residential properties would be located at.
For this article, I would be focusing on planning regions and not planning areas due to the time constraint that I had to work with. If I have more time, I would spend a significant more time analysing the various planning areas.

Approaches

Initial Analysis

For the initial analysis, i looked into URA's Master Plan 2014 and analyzed the various places of interest. Here are my findings:

• West - Has the most businesses among all the regions
• Central - Has the most business parks and shopping centers among all the regions
• North - Has the most parks and open spaces among all the regions

Overall Analysis

The first analysis i did was an overall analysis of the transactions that occured in the year 2015. These are my findings:

From the image above i was able to get the following insights:

• Central - Has the most expensive transactions (Unit Cost Per Square Foot)
• North & North East(Punggol) - Has the least number of transactions taking place at that area.
• The Area around Marine Parade an unusual amount of transactions.

Using this information, i had to ask the following Questions:
1. Why was people spending so much to have a property in central of Singapore?
2. why was there an unusual amount of people buying properties at Marine Parade?
3. Why were there very little people buying properties at the North Region and Punggol?

Since a datamap may not be accurate in representing data accurately, i decided to analyze all these data again to confirm my findings. I was able to replicate the results. The average transaction at

Tools

Tableau Microsoft Excel Adobe Photoshop