|
|
| Line 1: |
Line 1: |
| − | --<div style="margin-bottom:30px;">[[File:Library Image.jpg|frameless|center|1000px]]</div>
| |
| | | | |
| − | <!--Header-->
| |
| − | <div style="width:100%; text-align:center;">
| |
| − | {|style="background-color:#432c67; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top"|
| |
| − | | style="padding:0.2em; font-weight: bold; font-size:100%; background-color:#432c67; text-align:center; color:#F5F5F5" width="10%" |
| |
| − | <font color="#F5F5F5" size=5 face="Helvetica">LIBRARY SURVEY 2018</font>
| |
| − | |}
| |
| − | </div>
| |
| − | <!--/Header-->
| |
| − | <div></div>
| |
| − | <br /><br />
| |
| − | ==<div style="background:#432c67; padding: 15px; font-weight: bold; line-height: 0.3em; font-size:20px"><font color=#fbfcfd face="Helvetica"><center>PROBLEM & MOTIVATION</center></font></div>==
| |
| − |
| |
| − | ===<center>PROBLEM</center>===
| |
| − | <p>
| |
| − | </p>
| |
| − |
| |
| − | ===<center>MOTIVATION</center>===
| |
| − | <p>
| |
| − |
| |
| − | </p>
| |
| − |
| |
| − | ==<div style="background:#432c67; padding: 15px; font-weight: bold; line-height: 0.3em;font-size:20px"><font color=#fbfcfd face="Helvetica"><center>DATA PREPARATION</center></font></div>==
| |
| − | ===<center>MODIFICATIONS</center>===
| |
| − | <p>
| |
| − | <center>
| |
| − | {| class="wikitable" width="100%"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 7%;" |Tool
| |
| − | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 30%;" |Tasks and Modifications
| |
| − | |-
| |
| − | |
| |
| − | <center>
| |
| − | Microsoft Excel
| |
| − | </center>
| |
| − | |
| |
| − | <ol>
| |
| − | </ol>
| |
| − | |-
| |
| − | |
| |
| − | <center>
| |
| − | Tableau Prep
| |
| − | </center>
| |
| − | |
| |
| − | <ol>
| |
| − | <li> Pivoting the dataset so as to bring the different rows for each question to columns. This make analysis on Tableau easier. </li>
| |
| − |
| |
| − | </ol>
| |
| − | |-
| |
| − | |}
| |
| − | </center>
| |
| − | </p>
| |
| − |
| |
| − | ===<center>TABLEAU PREP FLOW</center> <br>===
| |
| − | <p>
| |
| − | <center>
| |
| − |
| |
| − | </center>
| |
| − | </p>
| |
| − |
| |
| − | ===<center>DATA TRANSFORMATION</center>===
| |
| − | <p>
| |
| − | <center>
| |
| − | {| class="wikitable" width="100%"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 30%;" |Original Data
| |
| − | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 30%;" |Processed Data
| |
| − | |-
| |
| − | |
| |
| − |
| |
| − | |
| |
| − |
| |
| − | |}
| |
| − | </center>
| |
| − | </p>
| |
| − |
| |
| − | ==<div style="background:#432c67; padding: 15px; font-weight: bold; line-height: 0.3em; font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>STORYBOARD</center></font></div>==
| |
| − |
| |
| − | ===<center>SKETCH 1: Survey Overview Dashboard</center>===
| |
| − | <p>
| |
| − |
| |
| − | </p>
| |
| − | ===<center>SKETCH 2: Survey Dashboard 1</center>===
| |
| − | <p>
| |
| − |
| |
| − | </p>
| |
| − | ===<center>SKETCH 3: Survey Dashboard 2</center>===
| |
| − | <p>
| |
| − |
| |
| − | </p>
| |
| − |
| |
| − | ==<div style="background:#432c67; padding: 15px; font-weight: bold; line-height: 0.3em; font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>KEY TECHNICAL CHALLENGES & MITIGATION</center></font></div>==
| |
| − |
| |
| − | {| class="wikitable" width="100%"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 5%;" |No.
| |
| − | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 15%;" |Challenge
| |
| − | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 40%;" |Description
| |
| − | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 40%;" |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
| |
| − | |}
| |
| − | </center>
| |
