Difference between revisions of "IS428 2016-17 Term1 Assign1 Heng Yi Teng Mabel"
Line 12: | Line 12: | ||
==== aii. Graphical Design ==== | ==== aii. Graphical Design ==== | ||
− | ==== aiii. Analysis ==== | + | ==== aiii. Analysis - Share of private industrial properties decreased in 2015 ==== |
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. | 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. | ||
[[File: Number_of_Industrial_Properties.JPG|none|400px|Number of industrial properties supplied]] | [[File: Number_of_Industrial_Properties.JPG|none|400px|Number of industrial properties supplied]] | ||
− | However, further analysis shows that the share of private industrial properties actually | + | Across public and private factories and warehouses, all categories experienced growth in supply. |
+ | [[File: Number_of_Industrial_Properties_by_Category.jpg|none|Number of factories & warehouses supplied in 2014 & 2015]] | ||
+ | |||
+ | However, further analysis shows that the share of private industrial properties actually decreased in 2015. Compared to 2014, 2015 had a reduced share of private properties and an increased share of public properties. | ||
[[File: Share_of_Industrial_Properties.jpg|none|Share of private/public industrial properties supplied in 2014 & 2015]] | [[File: Share_of_Industrial_Properties.jpg|none|Share of private/public industrial properties supplied in 2014 & 2015]] | ||
− | |||
− | |||
− | |||
== Policy Recommendations == | == Policy Recommendations == | ||
=== Recommendation 1: Reduce Industrial Property Supply === | === Recommendation 1: Reduce Industrial Property Supply === |
Revision as of 02:18, 29 August 2016
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
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.
Across public and private factories and warehouses, all categories experienced growth in supply.
However, further analysis shows that the share of private industrial properties actually decreased in 2015. Compared to 2014, 2015 had a reduced share of private properties and an increased share of public properties.