ISSS608 2016-17 T1 Assign1 Kee Bei Jia

Abstract

Still in Progress

Tools Utilized

Tableau was used.

Data preparations: There are some transformation :

1. Conversion of Date field: The Date field in the data set was in the format YYYY-MM, as in “2012-03” for March 2012 as type string. To convert to a date format, the following formula was used on the Month field: DATEPARSE("yyyy-MM",[Month] )

1. Calculating the price per square meter of resale prices: The prices in the data set was the transaction price, As such for a fairer comparison, Price per square meter was calculated using the formula: [Resale Price]/[Floor Area Sqm]

During analysis:

Preparation of info-graphics: To create a histogram, a bins dimension was created from the Price per square meter measure, bin size was dependent on a parameter bin size which could be altered in Tableau dashboard. Filters could also be added in for further drill down if required. (They were left our as it was an info graphic.)

The info graphic was also prepared in Tableau Dashboard tab, and exported from there as PNG file.

Resale Flat Info-graphics

Results

General observations