IS428 AY2019-20T2 Assign GUO LINGXING

Problem and Motivation

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. However, despite all the efforts in developing the surveys, the past reports were too primitive and difficult to gather high-level insights. Hence a more interactive dashboard visualisation is needed to help the management to understand how well the library has been serving the SMU community.

We will be using visual analytics approach to reveal the level of services provided by SMU libraries as perceived by:

• the undergraduate students,
• the postgraduate students,
• the faculty,
• the staff.

Dataset Analysis & Transformation Process

This section will elaborate on the dataset analysis and transformation process for each dataset in order to prepare the data for import and analysis on interactive visualization. There's one excel file provided which contains 2 sheets:

• Sheet1: SMU
• Sheet2: Legend

SMU sheet contains all the data that were recorded in 2018. Legend Sheet contains all the legends for all the values in each column in the SMU sheet.

Generally, we can breakdown the dataset into 2 broad categories, Respondent Characteristic categories, Question categories. For Respondent Characteristic we have:

1. Campus
2. StudyArea
3. Position
4. Response ID

For Question categories, we can further break it down into 4 different categories:

1. Importance and Performance Question, which consists of 4 categories (5 for performance):

• Communication
• Service Delivery
• Facilities and Equipment
• Information Resources
• Overall Satisfaction (Only applicable to performance)

2. Frequency of the Library Resource Usage Question, which contains questions that query the respondents the number of usage/access towards library resources.
3. Is the service applicable to the surveyee (NA) Question, which questions the respondents if the services in importance/performance are applicable to them.
4. Net Promoter Score (NPS) Question

Fixing the "Fat and short" Data table problem

The datasheet (SMU) is challenging to interpret for both human eyes and machine to process. Therefore, we need to preprocess and massage the data before we design and visual.

Issue: Dataset is "fat and short", in other words, not machine friendly. As the raw data have not been processed the two broad categories, respondent characteristics and question category, are not properly segregated and this will confuse the analytics tools. Therefore, the records are difficult for the machine to process and for us to form proper visuals. Hence we need to slim it down to "tall and long" so that we can do proper calculations which tableau.

Solution: Pivot and Pivot. Since we need certain fields to help us to identify our records, we will not touch the respondent characteristics fields and keep it as it is for now. However, we need to do some processing with the question categories using Tableau Prep Builder.

1. Upload the data into Tableau Prep Builder, remove fields that we will not be working on.

2. Pivot the columns that belong to the 4 question categories we have identified earlier.

We will pivot the fields that fall under Importance and Performance (inclusive of p27).



Create a new step in tableau prep for the remaining question categories, except NPS question as it only has a single field. (Single fields are not required to pivot.)


3. Save the flow and output the processed result and the data will be ready for tableau!