|
|
| Line 1: |
Line 1: |
| − | <div style="background: #3b3b3b; padding: 15px; font-weight: bold; line-height: 1em; text-indent: 30px; border-left: #a9a9a9 solid 32px; font-size: 20px"><font color="white">SMU Libraries Survey</font></div>
| |
| | | | |
| − | ==Problem and Motivation==
| |
| − | Every two years, SMU Libraries conduct a comprehensive survey in which faculty, students and staff have the opportunity to rate various aspects of SMU library's services. The survey provides SMU libraries with input to help enhance existing services and to anticipate emerging needs of SMU faculty, students and staff.
| |
| − |
| |
| − |
| |
| − | ==Objectives==
| |
| − |
| |
| − |
| |
| − | The 2018 Survey Results past reports are mainly made-up of pages of tables, which are very difficult to comprehend. In view of this, there is a need to apply appropriate data visualisation to transform these tables into visual representation that allow SMU libraries to gain useful insights.
| |
| − |
| |
| − | The insights revealed in the Insights and Recommendations tab will cover the following areas of interest:
| |
| − | # Undergraduate Students
| |
| − | # Postgraduate Students
| |
| − | # Faculty
| |
| − | # Staff
| |
| − |
| |
| − |
| |
| − | ==Data Cleaning==
| |
| − |
| |
| − | '''Renaming of Column Variables'''
| |
| − |
| |
| − | To make the dataset more easier to work with and easier to comprehend, I have to rename the columns that corresponds to their equal value in the legend.
| |
| − |
| |
| − |
| |
| − |
| |
| − | [[File:Picture 1.png|thumb]]
| |
| − | This is the current structure.
| |
| − |
| |
| − |
| |
| − |
| |
| − |
| |
| − |
| |
| − | {| class="wikitable"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #3b3b3b;color:#fbfcfd;width: 5%;" | Dashboard
| |
| − | ! style="font-weight: bold;background: #3b3b3b;color:#fbfcfd;width: 30%;" | Purpose
| |
| − | ! style="font-weight: bold;background: #3b3b3b;color:#fbfcfd;width: 30%;" | Variables Require
| |
| − | ! style="font-weight: bold;background: #3b3b3b;color:#fbfcfd;width: 30%;" | Measurement
| |
| − | |-
| |
| − | | <center>'''General Information'''</center>
| |
| − | || This will be the home dashboard of the visualisation, to present general data of the survey's result. This include:
| |
| − | *Brief introduction of survey background, survey's questions
| |
| − | *Total respondents from different position - Undergraduate Y1/ Professor/ Staff and study area
| |
| − | *Frequency of libraries visits, campus visits, access of libraries resources
| |
| − | *Respondents that are exchange/local students
| |
| − | ||<center> Campus, StudyArea, Position, ID, HowOftenL, HowOftenC, HowOftenW <center>
| |
| − | ||<center> Respondents input <center>
| |
| − | |-
| |
| − | | <center>'''Libraries Advocacy'''<center>
| |
| − | |<center>Display net promoter score and % detractor/passive/promoter of each respective position and study area<center>
| |
| − | |<center> NPS1 <center>
| |
| − | |<center>Net Promoter Score, 1 - 10<center>
| |
| − | |-
| |
| − |
| |
| − |
| |
| − |
| |
| − |
| |
| − |
| |
| − |
| |
| − | {| class="wikitable"
| |
| − | |-
| |
| − | |<center>'''Screenshot'''</center>
| |
| − | |<center>'''Steps Taken'''</center>
| |
| − | |-
| |
| − | |[[File:3 ky.png|center|400px]]
| |
| − | |valign="top"| testing testingtestingtestingtestingtestingtestingtestingtestingtestingtestingtestingtestingtesting
| |
| − |
| |
| − | |-
| |
| − | |[[File:4 ky.png|center|400px]]
| |
| − | |valign="top"|
| |
| − |
| |
| − | |-
| |
| − | |-
| |
| − | |[[File:5 ky.png|center|400px]]
| |
| − | |valign="top"|
| |
| − |
| |
| − | |-
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | <div style="background: #3b3b3b; padding: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #a9a9a9 solid 32px; font-size: 20px"><font color="white">Interactive Visualization</font></div>
| |
| − |
| |
| − | <p>The interactive visualization can be accessed here:https://public.tableau.com/profile/lim.kim.yong#!/vizhome/VA_Assignment3_Final6/Home_Page</p>
| |
| − |
| |
| − |
| |
| − | ===Home Dashboard===
| |
| − |
| |
| − |
| |
| − |
| |
| − | The following shows the home dashboard:
| |
| − | [[File:Home ky.png|800px|center]]
| |
| − |
| |
| − |
| |
| − | <div style="background: #3b3b3b; padding: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #a9a9a9 solid 32px; font-size: 20px"><font color="white">Patterns & Anomalies</font></div>
| |
| − |
| |
| − | ===Findings from survey===
| |
| − |
| |
| − | {| class="wikitable"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #3b3b3b;color:#fbfcfd;width: 5%;" | S/N
| |
| − | ! style="font-weight: bold;background: #3b3b3b;color:#fbfcfd;width: 48%;" | Interesting Pattern
| |
| − | ! style="font-weight: bold;background: #3b3b3b;color:#fbfcfd;" | Significance
| |
| − | |-
| |
| − | | <center>'''1'''</center>
| |
| − | ||On floor 1 and 2, the bathroom exhaust fan is turn on continuously throughout the whole day. However, on floor 3, the bathroom exhaust fan power is only consuming power between 7am to 10pm.
| |
| − | || Through this pattern, we can see that floor 1 & floor 2 does not comply with the energy efficiency standards. Knowing that energy are non-renewable resources and will eventually run out. Adopting best practices to conserve energy not only helps to conserve resources but also translates into cost savings.
| |
| − | |-
| |
| − | | <center>'''2'''</center>
| |
| − | ||In general, most energy usages were consumed within the corridor areas throughout all floors.
| |
| − | || This is exceptionally bad for the company as the corridor spaces do not contribute greatly to employee's productive or efficiency. Furthermore, not only does it contributes to energy wastages, it causes the company to incur unnecessary costs. Therefore, management should come out with policies to curb such issue.
| |
| − | |-
| |
| − |
| |
| − | |}
| |
| − |
| |
| − | ==Reference==
| |
