IS428 AY2019-20T2 Assign JIANG XI

--

LIBRARY SURVEY 2018

DATA PREPARATION

MODIFICATIONS

Tool	Tasks and Modifications
Microsoft Excel
Tableau Prep	Pivoting the dataset so as to bring the different rows for each question to columns. This make analysis on Tableau easier.

DATA TRANSFORMATION

Original Data	Processed Data

KEY TECHNICAL CHALLENGES & MITIGATION

No.	Challenge	Description	Mitigation
1.	Lack of Familiarity with Tools	Everyone in the group do not know how to program in RShiny for visualisation	We will learn Rshiny during class, call for consultation and rely on Googling for any programming challenges. Alternatively, there is also Datacamp available for us.
2.	Viability of Ideas	We do not know if the current dataset is sufficient in providing all the information needed to conduct analysis and building of planned visualizations.	There are multiple dataset online to use and we can use Prof Kam's REALIS dataset provided to us to supplement our dataset if we are lacking of certain variables. We could also derive our own variables based on the current dataset if needed (e.g. Geocoding).
3.	Lack of Domain Knowledge	HDB resale prices are affected by a spectrum of different factors such as policy measures and redevelopment. It is hard for us to understand without domain knowledge.	Learn from informative websites such as from HDB and iteratively discover and learn insights into the dataset