Difference between revisions of "ISSS608 2016-17 T1 Assign1 Frandy Eddy"
| Line 26: | Line 26: | ||
Text | Text | ||
== Share of Resale Public Housing Supply in 2015 == | == Share of Resale Public Housing Supply in 2015 == | ||
| − | + | The share of resale public housing supply in 2015 can be observed by flat type, flat model, or town. | |
=== By Flat Type === | === By Flat Type === | ||
[[File:2015 Flat Type.jpg]] | [[File:2015 Flat Type.jpg]] | ||
| + | |||
| + | Text | ||
=== By Flat Model === | === By Flat Model === | ||
[[File:Flat Model.jpg]] | [[File:Flat Model.jpg]] | ||
| + | |||
| + | Text | ||
=== By Flat Model and Type === | === By Flat Model and Type === | ||
[[File:Flat Model & Type.jpg]] | [[File:Flat Model & Type.jpg]] | ||
| + | |||
| + | Text | ||
=== By Town === | === By Town === | ||
[[File:Town.jpg]] | [[File:Town.jpg]] | ||
| + | Text | ||
== Distribution of Resale Public Housing Prices in 2015 == | == Distribution of Resale Public Housing Prices in 2015 == | ||
| Line 44: | Line 51: | ||
=== Price Distribution === | === Price Distribution === | ||
[[File:Resale Price Distribution.jpg]] | [[File:Resale Price Distribution.jpg]] | ||
| + | |||
| + | Text | ||
=== By Flat Model === | === By Flat Model === | ||
[[File:Resale Price by Flat Model.jpg]] | [[File:Resale Price by Flat Model.jpg]] | ||
| + | |||
| + | Text | ||
=== By Town === | === By Town === | ||
[[File:Resale Price by Town.jpg]] | [[File:Resale Price by Town.jpg]] | ||
| + | Text | ||
== First Half of 2016 vs 2015 == | == First Half of 2016 vs 2015 == | ||
| Line 56: | Line 68: | ||
=== By Flat Type === | === By Flat Type === | ||
[[File:Flat Type 2015 vs 2016.jpg]] | [[File:Flat Type 2015 vs 2016.jpg]] | ||
| + | |||
| + | Text | ||
=== By Town === | === By Town === | ||
[[File:Town 2015 vs 2016.jpg]] | [[File:Town 2015 vs 2016.jpg]] | ||
| + | |||
| + | Text | ||
Revision as of 01:24, 29 August 2016
Contents
Abstract
Abstract
Problem and Motivation
Knowing sufficient information about resale flat prices, the trend, and the factors affecting the price is important for someone who wants to buy or sell a flat. Some of the key points that need to be answered includes the following:
- What are the shares of the resale public housing supply in 2015?
- What are the distribution of the resale public housing prices in 2015?
- Compare the patterns of the first-half of 2016 with the patterns of 2015
Approaches
Data Preparation
The data can be obtained from https://data.gov.sg/dataset/resale-flat-prices. As we are more interested to analyze the resale flat price in 2015 and 2016, we will use the dataset from March 2012 onwards. After connecting the data to Tableau, we need to create a calculated field to transform the "Month" from text to date format. This can be done by using DATE(LEFT([Month],4)+"-"+RIGHT([Month],2)+"-01").
Data Analysis
The analysis done are mainly focused on comparing the patterns of 2015 with the patterns of the first-half of 2016.
Tools Utilized
Tableau is used for data preparation and analysis
Results
Text
The share of resale public housing supply in 2015 can be observed by flat type, flat model, or town.
By Flat Type
Text
By Flat Model
Text
By Flat Model and Type
Text
By Town
Text
Distribution of Resale Public Housing Prices in 2015
Text
Price Distribution
Text
By Flat Model
Text
By Town
Text
First Half of 2016 vs 2015
Text
By Flat Type
Text
By Town
Text
