IS428 2016-17 Term1 Assign1 Heng Yi Teng Mabel
Contents
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
In 2014 and 2015, the supply in number of private industrial properties far exceeded that of public industrial properties. 2015 also saw an increase in number of both private and public industrial properties as compared to 2014.
However, further analysis shows that the share of private industrial properties actually fell in 2015. Compared to 2014, 2015 had a decreased share of private properties and an increased share of public properties.
Across public and private factories and warehouses, all categories experienced growth in supply. It is unclear which category caused the decrease share of private properties.
