IS428 AY2019-20T2 Assign CHUA MING YU

IS428 Visual Analytics for Business Intelligence

Overview

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.

The interactive tableau chart can be found at here [1]

Data Preperation

Tableau Prep was used to process the data given in "Raw data 2018-03-07 SMU LCS data file - KLG.xlsx"

The overall steps look like:

Below will be a step by step guide of what I did to get the final output.

Screenshot	Steps
	I added both sheets into tableau prep
	I removed all the responses where respondents responded that it is not applicable to them
	I pivoted the values so that instead of having multiple responses to multiple questions in one row, each row will represent one response to one question
	I renamed several columns so that the headers have more meaning. Then I pivoted it so that there will be one row per question and answer.
	I filtered out all the null values that appear due to the previous pivot step.
	I did an inner join on both sheets so that I can get all the responses and their corresponding meaning
	I used a whole bunch of merge statements to replace the responses for Position, StudyArea, ID, Campus. This allows for the values to have meaning instead of staying as numbered responses.

Graphs and insights

Undergraduates

Number	Screenshot	Insights
1		Almost all undergraduates who responded have visited the library before, whereas there are a few undergraduates who have not utilized the library resources before. There may be an underlying issue here about how undergraduates do not know how to access the library services, and that more could be done to educate undergraduates on how to access library resources.
2		Undergraduates here are likely to recommend the library to others. Even though their scoring is lowest among all 4 groups, however it is still positive.
3		It seems that there is a huge difference in the perceived importance of the facilities in the library, and its actual performance. Among all the undergraduates who rate the facilities as important, there is a gap of 29.2% in the number of users who rate the actual performance of the library as high.
4		Examining the issue further by looking into the individual questions for the category, facilities, we notice a few questions that are instrumental in causin the gap in performance and importance. They are the issues of users being unable to find places in the library to conduct group work, the library is too noisy, and the the printing services do not meet the needs of the users. Since the survey was done in 2018, with the recent opening of SMU connexion, we might see improvements in the amount of spaces available for undergraduates to conduct group work. Last year in 2019, SMU was on a journey to improve the printing services. This action could have been spurred by the results of the survey. As for whether it helped to improve printing services, we have to examine the survey results of future years. As for the noise levels in the library, more could be done by the library to get users to keep their volume as low as possible.
5		Another area where there is a noticible different between performance and importance is in the informantion resources category.
6		Looking into the individual questions for information resource, we notice that the greatest discrepancy comes from the question of whether users find it easy to use mobile devices to access online resources. What we can take away is that the infrastructure of the school does not allow for users to be able to easily gain access to the information while on mobile devices. Personally I feel that this is a very salient point as undergraduates need to fully utilize their time to study, even while travelling on public transport. Have mobile friendly access to resources will allow for users to be able to study as and when they want to, even if they are travelling from home to school
7		As for the communication category,
8
9
10