IS428 AY2019-20T2 Assign CHOY YU MIN JUSTIN
Contents
Background and Motivation
SMU Libraries strives to achieve the following Mission and vision
Mission:
- To enable a culture of life-long learning through collaboration, engagement and outreach. It aims to provide seamless access to information using innovative and leading edge technology. The Library is committed to delivering exceptional services and building dynamic relationships within the SMU community and beyond.
Vision:
- To be a leading research library providing ubiquitous access to information using innovative strategies to drive intellectual exchange and the creation of knowledge.
As such, they have built their library service offerings that cover 4 main areas: Communication, Facilities and Equipment, Information & Resources, and Service delivery. These offerings cater to the Library's 4 main stakeholders - Faculty, Graduates, Staff, and Undergraduates (The biggest stakeholder). We can also understand that these stakeholders mainly fall under SMU's schools (Law, Information Systems, Social Sciences, Economics, Business(Largest number), Accountancy, and Others.
To ensure that SMU's offerings are constantly relevant and meet the demands of their stakeholders, SMU Libraries conducts a 2 yearly survey to gather important KPIs to better improve their services. However, this data is large in dimentionality and is largely opinionated in nature. This makes it difficult to draw truthful insights and careful analytics is required to clean, process, and visualise the data for accurate insights. Given the richness of the 2018 Library survey, it is all the more exciting to carefully unpack the data and visualise it to help SMU Libraries draw key insights to better improve their offerings.
Objectives
The objective of this project is to build a good and truthful data visualisation to help gather key insights from the libraries four main stakeholders:
- The undergraduate students,
- The postgraduate students,
- The faculty,
- The staff.
Success of the project would be seen as the following: (Users are able to...)
- Able to acquire clear insight on how the library is doing overall.
- Able to acquire clear insight on how satisfied each stakeholder group is with each offering.
- Able to identify specific areas that contribute to dissatisfaction/satisfaction through survey questions.
- Numbers backed up by relevant comments that show more objective feedback for actionable improvement.
Dataset Analysis
Raw Data Set
The Data provided was a set of 3 files:
1. Raw data 2018-03-07 SMU LCS data file - KLG.xlsx 2. 2018-02-16 SMU Library Survey Comments MAC.xls 3. SMULibraries_BeHeardSurvey_FullReport.pdf
Of which, I only utilized "Raw data 2018-03-07 SMU LCS data file - KLG.xlsx", as it contained all the necessary fields and data points needed for the analysis.
Dataset Transformation
Explain Data Transformation
Handling Null Data
Explain handling null
Handling Likert (ordinal to categorical)
explain ...
Interactive Visualization
The interactive visualization can be accessed here: https://public.tableau.com/profile/justin.choy#!/vizhome/JustinChoySMULibrarySurveyAnalysis/SMULibrary2018Storyboard
