IS428 AY2019-20T2 Assign SIM HUEI MIN AARON

SMU Libraries Survey

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:

1. Undergraduate Students
2. Postgraduate Students
3. Faculty
4. 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.

This is the current structure.

Dashboard	Purpose	Variables Require	Measurement
General Information	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	Campus, StudyArea, Position, ID, HowOftenL, HowOftenC, HowOftenW	Respondents input
Libraries Advocacy	Display net promoter score and % detractor/passive/promoter of each respective position and study area	NPS1	Net Promoter Score, 1 - 10

Screenshot	Steps Taken
400px	testing testingtestingtestingtestingtestingtestingtestingtestingtestingtestingtestingtestingtesting
400px
400px

Interactive Visualization

The interactive visualization can be accessed here:https://public.tableau.com/profile/lim.kim.yong#!/vizhome/VA_Assignment3_Final6/Home_Page

Home Dashboard

The following shows the home dashboard:

800px

Patterns & Anomalies

Findings from survey

S/N	Interesting Pattern	Significance
1	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.
2	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.