Difference between revisions of "IS428 AY2019-20T2 Assign CHUA MING YU"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 64: Line 64:
 
=Graphs and insights=
 
=Graphs and insights=
 
===Undergraduates===
 
===Undergraduates===
 +
 +
{| class="wikitable" style="margin-left: auto; margin-right: auto; width: 100%;
 +
|-
 +
! style="font-family:Verdana; background: #3b3b3b;color:#fbfcfd;width: 3%;font-size:18px;" |Number
 +
! style="font-family:Verdana; background: #3b3b3b;color:#fbfcfd;width: 15%;font-size:18px;" |Screenshot
 +
! style="font-family:Verdana; background: #3b3b3b;color:#fbfcfd;width: 15%;font-size:18px;" |Insights
 +
 +
|-
 +
|1
 +
|
 +
[[File:Resourceutilization(never).png|400px|center]]
 +
|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
 +
|
 +
[[File:Nps scoring v2.png|400px|center]]
 +
|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
 +
|
 +
[[File:Performance facilities.png|400px|frameless|center]]
 +
|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
 +
|
 +
[[File:Response facilities.png|400px|center]]
 +
|Examining the issue further by looking into the individual questions for the category, facilities, we notice that the main causes for the gap in performance and importance lies in users being unable to find places in the library to conduct group work, and that the library is too noisy. 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. 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
 +
|
 +
|
 +
 +
|-
 +
|6
 +
|
 +
|
 +
 +
|-
 +
|7
 +
|
 +
|
 +
 +
|-
 +
|8
 +
|
 +
|
 +
 +
|-
 +
|9
 +
|
 +
|
 +
 +
|-
 +
|10
 +
|
 +
|
 +
 +
 +
|}
  
 
===Graduates===
 
===Graduates===

Revision as of 21:02, 15 March 2020

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:

9 overall 2.png

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

Screenshot Steps
1step1.png
 I added both sheets into tableau prep
2remove na.png
 I removed all the responses where respondents responded that it is not applicable to them
3pivot1.png
 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
4pivot2.png
 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.
5filter null.png


6remove null.png
 I filtered out all the null values that appear due to the previous pivot step.
7join.png
 I did an inner join on both sheets so that I can get all the responses and their corresponding meaning
8clean.png
 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
Resourceutilization(never).png
 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
Nps scoring v2.png
 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
Performance facilities.png
 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
Response facilities.png
 Examining the issue further by looking into the individual questions for the category, facilities, we notice that the main causes for the gap in performance and importance lies in users being unable to find places in the library to conduct group work, and that the library is too noisy. 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. 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
6
7
8
9
10


Graduates

Faculty

Staff

Retrieved from ‘https://wiki.smu.edu.sg/1920t2is428/index.php?title=IS428_AY2019-20T2_Assign_CHUA_MING_YU&oldid=3560’