IS428 2016-17 Term1 Assign1 Chen Huiyan

Abstract

The focus of this project is to reveal patterns regarding the share of private properties supply as well as the distribution of the private properties prices in 2015. Through these findings, the project is able to provide policy recommendations for 2016.

Problem and Motivation

According to available executive condominium chart, except for quarter4 in 2015, the vacancy rate of each quarter is around 15% and for available private properties chart, the vacancy rate is around 7% or 8%, although the price of private property is declining in 2015. From this phenomenon, we can induce that the demand for private properties is not promising. Therefore, the government may consider easing cooling measurement to stimulate the private property development.

Approaches

Through examining the supplies in the pipeline of private properties and executive condominium by development status and completed supplies which are available to sell, readers will have a better picture about the share of private properties supplies in 2015. Even though private properties prices are declining, the market is still downbeat by analyzing vacancy rates.

Tools Utilized

• Tableau
• Excel
• REALIS

The share of private properties supplies in 2015

Rationale of data selection:
I have found supply in the pipeline for both private residential units and executive condominiums which contribute to private properties supplies in 2015.

Three patterns observed:

• Supply of private residential units in the pipeline is decreasing in 2015.
• Supply of executive condominiums in the pipeline is declining in 2015.
• The total supply in the pipeline is decreasing in 2015.

Rationale of chart design: I choose the stacked bar chart to differentiate the pipeline supply of private residential units from executive condominiums under the same period and label the number of units for executive condominium to let readers have a clear view of changes.

Break down supply of private residential units in the pipeline

Break down supply of executive condominiums in the pipeline

Rationale of chart design: I choose side-by-side bar chart to represent different types of pipeline supply by using different colours for private residential units and executive condominium.

Available Private Properties and Executive Condominium