IS428 AY2019-20T2 Assign RYAN WONG POH FAI

From Visual Analytics for Business Intelligence
Revision as of 23:01, 15 March 2020 by Ryan.wong.2016 (talk | contribs)
Jump to navigation Jump to search

Data Preparation

For Data Preparation, I referred to the following video for some guidance.

Data Cleaning and Transformation

Screenshots Steps
Data 1 - Pivot I01 - P27.jpg
 1. Pivot I01-I26, P01-P27
Data 2 - Rename Columns.jpg
 2. Rename Pivot Field Names and Pivot Field Values to "QuestionID" and "Score" respectively
Data 3 - Inner Join with Legend.jpg
 3. Drag Legend and Inner Join with SMU tab (QuestionID = Code)
Data 4 - Rename Item Column to QuestionText.jpg
 4. Rename Item Column to QuestionText
Data 5 - Hide Columns.jpg
 5. Hide Columns: Code, Free text, 0-10, F15-F18
Data 6 - Create Dimension for Position.jpg
 6. In a new Sheet, Duplicate Position under Measures > Rename it as Position (Category)
Data 8 - Create Aliases for Position.jpg
 7. Create Aliases for Position
Data 7 - Aliases for Position.jpg
 8. Rename Aliases for Position
Data 10 - Create Dimension for Library.jpg
 9. Duplicate Library under Measures > Rename it as Library (Category)
Data 9 - Create Aliases for Library.jpg
 10. Create Aliases for Library
Data 10 - Aliases for Library.jpg
 11. Rename Aliases according to the screenshot
Data 12 - Duplicate and Rename Score Dimensions.jpg
 12. Under Measures, duplicate Score and convert it to a dimension

13. Then, rename the Score dimension to "Score (Category)"

Comments on Survey

One issue with the Library Survey is that it does not assign a description to each score. The Survey only gave a description of Low for a score of 1, and a description of High for a score of 7. The Survey should improve on this by providing descriptions for each score. An example given:

Score Description
1
 Not important at all / Not satisfied at all
2
 Not important / Not satisfied
3
 Slightly not important / Slightly unsatisfied
4
 Neutral
5
 Slightly important / Slightly satisfied
6
 Important / Satisfied
7
 Extremely Important / Extremely satisfied

By providing descriptions, survey respondents will have a better idea of what each score represents. Therefore, for the purposes of analysing this survey, I will assume that the scores follow the table above.


Analysis and Insights

Dashboard Link

Dashboard can be downloaded from here: Tableau Public

Undergraduates

Importance

UG1 - Top 5 Important.jpg

For undergraduates, these are the 5 Most Important Library services:

  1. Q18 - I can get wireless access in the Library when I need to
  2. Q14 - I can find a quiet place in the Library to study when I need to
  3. Q19 - Printing, scanning and photocopying facilities in the Library meet my needs
  4. Q17 - Laptop facilities (e.g. desks, power) in the Library meet my needs
  5. Q06 - Opening hours meet my needs


Performance

UG3 - Best 5 Performance.png

The 5 Worst Performing Services for Undergraduates are:

  1. P15 - I can find a place in the Library to work in a group when I need to
  2. P26 - I find it easy to use mobile devices (e.g. tablets and phones) to access online resources
  3. P14 - I can find a quiet place in the Library to study when I need to
  4. P16 - A computer is available when I need one
  5. P01 - I am informed about the Library services
UG2 - Worst 5 Performance.png

As for the 5 Best Performing services:

  1. P12 - Library staff provide accurate answers to my enquiries
  2. P21 - Online resources (e.g. online articles, databases, ebooks) are useful for my studies and help me with my learning and research needs
  3. P08 - Self Service (e.g. self-check loans, requests, renewals, holds) meets my needs
  4. P13 - I can get help from library staff when I need it
  5. P18 - I can get wireless access in the Library when I need to


Biggest gaps between Importance and Performance

UG4 - Top 5 Gaps.jpg

I have ranked the areas in order of the largest average score gap between Importance and Performance.

  1. Q14 - I can find a quiet place in the Library to study when I need to (Gap: 1.59)
  2. Q15 - Finding a place in the Library to work in a group when needed (Gap: 1.41)
  3. Q19 - Printing, scanning and photocopying facilities in the Library meet my needs (Gap: 0.83)
  4. Q26 - I find it easy to use mobile devices (e.g. tablets and phones) to access online resources (Gap: 0.66)
  5. Q06 - Opening hours meet my needs (Gap: 0.5)

Based on the areas identified above, it shows that SMU Library should first prioritise improving the amount of spaces needed for students to study and work in a group. There was also a huge gap in the printing, scanning and photocopying facilities of SMU Library, hence SMU library should look towards finding more ways to increase the amount of printers.

Undergraduates also experience a gap in using mobile devices to access online resources at SMU Library. Hence, SMU Library should focus on improving mobile access to their online resources.

As for opening hours, undergraduates still feel a lack in the current operating hours of SMU Library.


Comparison between LKS and KGC Library as a Study/Work Space

From the survey, Undergraduates who use Kwa Geok Choo Library more often tend to find it better in providing a space for students to study or work in a group. Kwa Geok Choo Library actually scored better when comparing both averages. However, both scores are still relatively weak and would still need to be improved on.

Net Promoter Score

UG7 - UG NPS.png

The total NPS for Undergraduates is 28.28. Note that for this visualization, the NPS Score calculated field within the tooltip is taken across all Undergraduates. This shows that overall, Undergraduates are pleased with SMU Library and are likely to recommend the Library to others.

After comparing the NPS between the different years of Undergraduates, Year 2 students scored the lowest in terms of NPS at 18.81. One likely cause of the year 2’s NPS could be the incident where Kwa Geok Choo Library was flooded and they had a bad first-time experience with SMU Library. This shows that the Library should have focused on the Year 2 Undergraduates during 2018 to find out what caused the huge difference in NPS.


Postgraduates

Importance

PG1 - 5 Most Important.png

For postgraduates, the 5 Most important services are:

  • I18
  • I14
  • I19
  • I17
  • I06
PG2 - Most Important Doctoral.png

When looking at the 5 most important services between Masters and Doctoral postgraduates, there was actually a difference.

PG3 - Most Important Masters.png

For Masters students: 1. I18 2. I19 3. I14 4. I17 5. I15


For Doctoral students:

  1. I18
  2. I23
  3. I21
  4. I13
  5. I24



Performance

PG4 - 5 Worst Performance.png

The 5 Worst Performing Library Services for Postgraduates are:

  1. P14
  2. P15
  3. P16
  4. P05
  5. P04
PG5 - 5 Best Performance.png

The 5 Best Performing Library Services for Postgraduates are:

  1. P17
  2. P08
  3. P12
  4. P13
  5. P18


Net Promoter Score

PG6 - NPS.png

In terms of Net Promoter Score, Postgraduates scored much higher as compared to Undergraduates at 46.15, showing that they are much more likely to recommend SMU Library to others as compared to Undergraduates.

Both Masters and Doctoral students have very similar Net Promoter Scores, with Masters students’ NPS at 46.05 and Doctoral students’ NPS at 46.67. Showing that both groups of Postgraduate students are satisfied with SMU Library’s services.


Faculty

Importance

The 5 most important services for Faculty are:

  1. I21
  2. I24
  3. I23
  4. I13
  5. I25


Performance

The 5 worst performing services for Faculty are:

  1. P16
  2. P19
  3. P15
  4. P14
  5. P05


The 5 best performing services for Faculty are:

  1. P08
  2. P09
  3. P12
  4. P13
  5. P07


Net Promoter Score

The total NPS for Faculty overall scored 57.63. This is much higher as compared to the Undergraduates and Postgraduates and shows that Faculty are more likely to recommend the Library to others.

After finding out that the only detractors within the Faculty were Lecturers/Senior Lecturers, I decided to take a look at the Performance Levels for Library services response from Lecturer/Senior Lecturers. I Identified that the main struggles they face are in the photo below.

  1. P14 and P15: Not being able to find a quiet place in the Library to work at alone or in a group
  2. P22: Finding that the Course-specific resources do not meet their learning needs
  3. P05
  4. P10
  5. P07
  6. P21

Hence, should SMU Library want to improve the service levels for Lecturers/Senior Lecturers, they can look into the above areas.

Staff

Importance

For the Staff, the 5 most important services are:

  1. I18
  2. I13
  3. I21
  4. I14
  5. I12

Performance

As for the 5 worst performing services:

  1. P16
  2. P04
  3. P05
  4. P26
  5. P11


As for the 5 best performing services:

  1. P08
  2. P12
  3. P06
  4. P13
  5. P18

Net Promoter Score

The total NPS for Staff overall totalled to 29.69. This makes Staff the demographic with the 2nd lowest NPS, meaning that they are much less likely to recommend the Library to other

After diving into the NPS scores for each sub-group, I found that Researchers only have an NPS of 16, which was the main reason why the overall NPS for Staff scored so low.

After looking into the Performance service levels for Researchers, I found the 5 worst performing services for Researchers:

  1. P26
  2. P24
  3. P01
  4. P02
  5. P05
Retrieved from ‘https://wiki.smu.edu.sg/1920t2is428/index.php?title=IS428_AY2019-20T2_Assign_RYAN_WONG_POH_FAI&oldid=3892’