Difference between revisions of "IS428 2016-17 Term1 Assign1 Zheng Xiye"
| Line 18: | Line 18: | ||
==Approaches== | ==Approaches== | ||
| − | === Private Property Sale Overview 2015 === | + | === Share of Private Property Supply 2015 === |
| − | + | ==== Private Property Sale Overview 2015 ==== | |
| + | After merging data downloaded from REALIS namely: Residential Supply 2015 q1-q4, I came to realize that in order to trace the trend of private property sale across 2015, an additional column, Quarter is required. <br> | ||
| + | [[File: Private Property Sale Overview.JPG]] | ||
| + | Chart plotted above illustrates change in percentage of total no.of completed and sold private properties across 4 quarters of 2015. Both of which reflect reducing heat in private property supply as indicated by the down-going percentage trend. Assuming that the reducing heat is not attributed to a seasonal effect and positive correlation between total completed and sold, we are able to conclude that private property supply will continue to shrink in 2016. | ||
Revision as of 00:28, 29 August 2016
Contents
Abstract
Problem & Motivation
With limited amount of land available for construction and high demand for private properties, Singapore has always been a 'low-hanging fruit' for real-estate players to gain substantial benefits from constructing and selling excessive number of private properties.
By referring to Morgan Stanley Research on Singapore Residential Supply, private properties supply reached its peak around millennium, decreased to historical minimum around 2008 Global Economic Crisis and re-bounced to around 40K units in 2014. The rapidly inflating real-estate market flashed 'red-light' upon Singapore government, urging policy makers to structure regulating measures in preventing the 'real-estate bubble' from bursting.
In order to facilitate policy makers' decision making process, this study aims to identify both supply and pricing patterns of private properties across the entire Singapore. By doing so, policy makers will be having a 'touch and feel' on the landscape of real-estate market. Effectively identifying real-dangers and potential risks, policy makers will be empowered to structure preventive mitigation actions accordingly, which ensures the well-being of Singapore real-estate market.
Tools
- Microsoft Excel: mainly for data pre-processing: data cleaning, sorting and transforming.
- Tableau 10.0: creating charts that effectively identify patterns hidden in huge data-sets and providing insights that may be proven helpful in facilitating policy makers' decision making process.
Approaches
Private Property Sale Overview 2015
After merging data downloaded from REALIS namely: Residential Supply 2015 q1-q4, I came to realize that in order to trace the trend of private property sale across 2015, an additional column, Quarter is required.
Chart plotted above illustrates change in percentage of total no.of completed and sold private properties across 4 quarters of 2015. Both of which reflect reducing heat in private property supply as indicated by the down-going percentage trend. Assuming that the reducing heat is not attributed to a seasonal effect and positive correlation between total completed and sold, we are able to conclude that private property supply will continue to shrink in 2016.
