ISSS608 2016-17 T1 Assign1 WEI Jingxian

Problem and Motivation

Public housing is an icon of Singapore, and HDB flats are home to over 80% of Singapore's resident population. However, sometime it is not easy for resident to apply flats due to financial or other problems. The resale flat is a good choice for these resident. We purpose to provide a clear view of resale flats for residents who are interested in resale flats and help them in making decisions. The dataset we used is from HDB, resale-flat-price

There are two key variables have significant impacts on resident’s choice, including price and location. First of all, people always concern about price. Apart from price, people would also care about locations of flats.

1. What are the shares of the resale public housing supply in 2015 (at least three observation),
2. What are the distribution of the resale public housing prices in 2015 (at least three observation), and
3. With reference to the findings, compare the patterns of the first-half of 2016 with the patterns of 2015.

Approaches

Data Preparation

There are ten variables in the dataset, including registration date, flat information, and flat price. The sample data has shown below. Noticed that the date variable Month is treated as string in Tableau, so we need to calculate a new variable, which is in date format in Tableau, so that we can use the variable to do further analysis.