IS428 AY2019-20T2 Assign CHOY YU MIN JUSTIN

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Justin choy title.png

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:

  • 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

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

Analysis & Insights

Undergraduate Students

Postgraduate Students

Faculty

Staff

Conclusion & Future Work