IS428 AY2019-20T2 Assign NEO TEE YONG

SMU Library Survey

Background

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

With the feedback obtain from the survey, I am tasked to utilize visual analytics approach to reveal the level of services provided by SMU libraries as perceived by:

• the undergraduate students,
• the postgraduate students,
• the faculty,
• the staff.

Summarising Data Set & Planning for Visualisation

The Dataset being used in this visualisation is from SMU Library: 2018 Survey Results. Can be found here

Dashboard	Purpose	Variable Require	Measurement
Overview	This will be the home dashboard of the visualisation which summarise the entire processed data. It is interactive as viewer able to toggle filtering simply by selecting the field. This include: Total number of respondents and the background of the respondents Total respondents reponding to Li Ka Shing and Kwa Geok Choo Law Libraries respectively Total respondents from different position such as Undergraduate/ Graduate / Staff/ Faculty Total respondents from different study area such as Accountancy/ Business/ Economics	StudyArea, ResponseID, Position	Number of respondents
Importance VS Performance	This dashboard will provide an overview of respondents' response to libraries service. Rating their importancy and performance for different aspect. Presenting 1 being the lowest to 7 the highest. This will be a interactive interface where viewer able to toggle filtering to narrow down the details such as filtering through which library, which study area and their group position	Assessment Item, Score, HowOftenL, HowOftenW	Distribution of score rating 1 - 7, Number of respondents
Summary	This dashboard will provide an summary of the analysed data where viewer able to compare satisfactory between study area to on the general scale. This could acts as a medium for library to target specific study area to cater to their needs. It also allow viewer to see respondents relationship towards recommending to others based on their overall satisfactory	StudyArea, Number of Records, likelihood of recommend the library service to others	Satisfactory difference between study area Correlation between people who are satisfied and people who likely to recommend to others

Hand-drawn visualisation

                                                                              Overview

Chart1:

Chart2:

                                                                       Importance vs Performance

For performance and important (chart 3&4):

                                                                             Summary

Chart 5:

Chart 6:

Data preparation

Screenshot	Steps Taken
	Data Preparation: Hiding Hide column NA1-NA26 and comment by right clicking and select hide
	Data Preparation: Pivot Select column from I01-P27 Right click and select pivot
	Data Preparation: Renaming Rename the column heading: 'Pivot Field Names' to 'Assessment Item' 'Pivot Field Values' to 'Score' 'How Often L' to 'Visit Library Frequency' 'How Often C' to 'Visit Campus Frequency' 'How Often W' to 'Resources Used Frequency' 'Nps1' to 'likelihood of recommend the library service'
	Edit Alias for fields Right click the attribute Select Aliases Change the value(Alias) Change for Position, Study Area,Campus, Frequency
	New calculated field and set Gannt percent, Gannt start, count negative, total count negative, percentage, total count for creating divergent chart in Important Vs Performance Dashboard. Kwa Geok Choo Law Library & Li Ka Shing Library for creating pyramid chart in Overview Dashboard. Performance Score and Important Score were use for Important Vs Performance Dashboard to show the meaning of the legend PositionGroup were use to group position together for filtering and for Overview Dashboard.

Interactive Visualization

The interactive visualization can be accessed here:https://public.tableau.com/profile/neo.tee.yong#!/vizhome/assignment3_15842852167560/LibrarySurvery2018

Overview Dashboard

Overview dashboard.This dashboard depicts a pyramid chart with Kwa Geok Choo Law and Li Ka Shing Libraries with the number of respondents in each study area. It also shows the demographic of the respondents. The interactivity allows user to examine the no. of respondents from KGC Law and LKS libraries in each study area and also in demographic of people in each study area

Library Importance vs Performance

Library Importance vs Performance dashboard. This dashboard shows a divergent chart as the main visualisation of both important and performance of each different aspect. The interactive of the filter button allows users to narrow the search to get the information easily.

Summary

Summary dashboard. This dashboard shows a stacked bar graph of each study area rating the performance of the libraries. It also have a Correlation matrix table that allows users to see the degree of correlation between the rating given to the performance against the likelihood of them recommending to others. The interactive of the filter button allows users to narrow the search to get the information easily.

Findings

Insights

S/N	screen shot	Insight and Significance
1		Overview Based on the pyramid chart, we can learnt that there is high respondents from business and law that go to Kwa Geok Choo Library as compared to other study area. We also can see that there afew repondents from law will go Li Ka Shing Library. This could because that Kwa Geok Choo Library is nearer to their study area and respondents preferred to go nearer libraries than travelling to a further library
2		Among all the assessment item, availability of group work space was graded the lowest in term of performance. This could be an area that need to be improve or find out the reasons behind it.
3		Among all the assessment item, availability of computer was graded the lowest in term of important. Libraries can consider removing it to cut expense or find others used for the computer.
4		In the stacked column chart, respondents from information systems and econonmics have a higher percent of dissatisfactory. Library could find reach out to these study area to assisted them more or to understand their needs in order to cater for them.
5		In the correlation chart, we ca see that although respondents might be satisfied with the library services, there are some not willing to recommend it to others. This may because either the space not enough or they are more willing to spend their time alone in the libraries without any disturbance.

Reference

<ref>https://www.datarevelations.com/resources/visualizing-net-promoter-score-data/<ref>
<ref>https://www.datarevelations.com/resources/rethinkingdivergent/<ref>
<ref>https://www.datarevelations.com/resources/got-likert-data-neutrals/<ref>
<ref>https://blog.hubspot.com/service/how-to-calculate-nps<ref>
<ref>https://www.udemy.com/course/tableau10-advanced/<ref>
Prof week 6 class exercise on divergent chart