IS428 2016-17 Term1 Assign1 Joanne Ong Shi Ying

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search

Abstract

This project aims to discuss and analyze the supply and prices of private property in Singapore. Due to land scarcity, the management of land utilization is extremely important. Throughout this project, we will realize that there is an oversupply of private properties and the price of private properties has been decreasing. Given such situations, I would like to suggest that the supply and price has to be controlled, and that we should boost the demand for private properties to reduce the rise of vacancy of private properties.

Problem and Motivation

Singapore faces land scarcity, hence we should maximize the utilization of land and weigh the opportunity cost of all options. It is important to analyze if we are currently oversupplying private properties, leading to lack of land space, which may affect our country’s growth.

Share patterns of private properties supply in 2015

Condo vs other property types price.png

From the bar chart, it is observed that apartment has the highest vacancy rate, followed by condominium with 9.437% vacancy rate.

1-2j.png

As we look deeper, condominium in the North East region has the highest average vacancy rate, which is about 5 times more than condominiums in the West region.

1-3j.png

Hence, I have decided to focus on the vacancy rate of the different regions for condominium in Singapore. It is observed that the vacancy rate for condominiums in the North East and East region has been increasing across quarters in 2015, while the vacancy rate of condominiums in the West, Central and North region has been decreasing steadily.


1-4j.png

The graph above shows the number of planned development condominium units in the different regions. As we can see, Central and West region have increased the number of planned developments with the decreasing vacancy rate, and North East region has no planned development with the increasing vacancy rate. However, East region has increased the planned development despite the increasing vacancy rate and North region has no planned development although the vacancy rate has been dropping.

Planned vs Vacant.png

It has led to a growing number of new planned development units and yet, an increasing number of vacant units, thus, causing an oversupply of condominiums.

Distribution of the private properties prices in 2015

2-1j.png

Looking at the prices of the different property types in Singapore, the average unit price per square metre is the highest for condominiums.

Prices.png

All property types had a decrease in price. The average unit price of detached houses decreased the most, at 14.80%, followed by terrace houses, at 9.33%. However, the average unit price of apartment fluctuates the most whereas, other property types decrease steadily.

Tools Utilized

  • Tableau
  • Microsoft Excel

Conclusion

Supply

  1. Apartment has the highest vacancy rate, followed by condominium.
  2. Condominium in the North East region has the highest average vacancy rate, which is about 5 times more than condominiums in the West region.
  3. There is an oversupply of condominiums.

Prices

  1. The average unit price per square metre is the highest for condominiums.
  2. All property types had a decrease in price.
  3. The average unit price of apartment fluctuates the most whereas, other property types decrease steadily.

Recommendation

  1. The supply of condominiums has to be managed in 2016, especially in the East and North region.
  2. The government should control the decrease in private property prices, as it might lead to a drop in investment.
  3. There is a relative high rate of vacancy, hence the government should also take up measures to boost demand.

Infographics

Infographics (Joanne).001.jpeg