IS428 2016-17 Term1 Assign1 Heng Yi Teng Mabel

From Visual Analytics for Business Intelligence
Revision as of 01:22, 29 August 2016 by Mabel.heng.2012 (talk | contribs)
Jump to navigation Jump to search

Share of the private properties supply in 2015

a. Industrial Properties

ai. Industrial Properties Data Cleaning

From REALIS, private and public property data were extracted separately and csv files were combined using cmd in Windows.

Since there was no field for selecting a timeframe in REALIS, I used “Written Permission Date” as a proxy for when the property was supplied. “Written Permission Date” was reformatted in Excel to ensure it was in Tableau-readable date format. Irrelevant records were deleted where the “Written Permission Date” field was empty or year was 2016. Upon data import into Tableau, it appeared there were no records of commercial public property supply before 2014, making records before 2014 meaningless for calculating share of private property supply. Hence all years were filtered out except for 2014 and 2015.

I also noticed there were columns pertaining to factory space and warehouse space in the dataset, indicating there two categories under industrial properties. Hence I used Excel to recode these columns into a new column "Category" where records were classified into factory or warehouse.

aii. Graphical Design

aiii. Analysis

File:Https://www.dropbox.com/s/29p4rabfc24a4v8/Q1 Share of Industrial Private-Public Properties in 2014 and 2015.jpg