IS428 AY2019-20T2 Assign LIM PAO LING RACHEL
Overview
Every 2 years, SMU libraries will conduct a comprehensive survey to provide an opportunity for faculty, students and staff to rate and comment various aspects of SMU library services. The survey aims at creating input that could possibly enhance existing services as well as to anticipate the emerging needs of SMU students, graduates, faculty and staff.
On the contrary, past library survey reports were not as comprehensive as intended, since the report consisted of numerous tables of data that could be better depicted with visualisations. The large amount of textual data collated poses as an issue when it comes to summarising data into a single visualisation, hence, appropriate categorising of charts and tables by performance metrics, importance metrics and other valuable metrics is key for an organised presentation of data.
Visual Analytics is used to provide insight into the various level of services provided by SMU libraries that is perceived by 4 main groups:
1. Undergraduate Students
2. Postgraduate Students
3. Faculty Lecturers
4. School staff
Data Description
| Data Attribute | Data Description | |
|---|---|---|
(online articles, databases, ebooks) | ||
Data Preparation
By referencing the Legend tab in the Raw Data excel file (Raw data 2018-03-07 SMU LCS data file – KLG), a reorganisation of data columns and rows were done to convert the coded data into textual representations. This is to ensure that there are readable headers when doing up the visualisations in Tableau. A general use of excel coding functions such as ‘VLOOKUP’, ‘HLOOKUP’ were used to match the legends to the specific header codes.
| Screen Shot | Data Cleaning Description |
|---|---|
  |
For dimensions:[ Campus, Position, Study Area, ID ] the use of HLOOKUP was done to create aliases for coded categorical data
=HLOOKUP(B3,'Legend (Categorised)'!$A$1:$R$8,2,FALSE)
|
 |
Creating Pivot columns for the Survey Questions & Ratings
Using keyboard functions (ctrl + shift + right arrow key) to highlight all columns (I01 – I26, P01 – P27, NA01 – NA26) and right-click to select the pivot grouping function in Tableau. The 2 new columns containing the various survey questions and respondent ratings per question are renamed to ‘SurveyQns’ and ‘Ratings’ respectively.
|
 |
Filtering out NULL or 0 data from the raw data set
While matching the headers to the appropriate columns found in the excel data set, there were some ‘NULL’ or ‘0’ data discrepancy found. When uploading the re-organised data set into Tableau, the filter function was used. The various columns were added to the filter to select data that was to be excluded before any visualisations can be created. |
  |
Further adjustments to Data columns in Tableau:
Converted measures into dimensions: HowOftenW --- Frequency of Accessing Library Resources HowOftenC --- Freq of Campus Visit HowOftenL --- Freq of Library Visit Ratings --- Ratings Renamed aliases: Daily, Monthly, Weekly, Quarterly, Never |
  |
Categorising the Survey Questions using ‘create groups’
Each of the survey questions are categorised into 5 main topics: 1. Communication 2. Service Delivery 3. Facilities Equipment 4. Information Resources 5. Not Applicable (NA) |
