IS428 AY2019-20T2 Assign GABRIEL CHUAN ZHAN HONG
IS428 Visual Analytics for Business Intelligence
|
|
|
Contents
Overview
Every two years, 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. The latest survey is currently on going and will be ended by 17th February 2020.
The 2018 Survey Results can be found here and the full report is available by following this link. The past reports are mainly made-up of pages of tables, which are very difficult to comprehend. In view of this, your task is to apply appropriate data visualisation to transform these tables into visual representation that allow SMU libraries to gain useful insights.
Data Cleaning & Preparation
There are 2 files on the data we will look at:
Raw data 2018-03-07 SMU LCS data file – KLG.xls
This contains most, if not all of the data that we will work with for this visualization. All the responses to the survey questions are in the 1st sheet, with many of the values encoded. The key to the encoding can be found in the 2nd sheet in the same XLS file. We will use those to convert the encoded values into something that's human readable.
2018-02-16 SMU Library Survey Comments MAC.xls
This file contains text based answers for students feedback on suggestions on how to improve the library.
| Problem 1 | Building Data |
| Issue | The data set is entirely coded in numerical values which makes it hard for anyone to interpret. In order to solve this, we have to reverse encode it into their textual representations. For instance, an answer to Question I01 would map to the Question text of "I am informed about the Library services". To do this, we use Tableau's functions. |
| Solution |
 |
The Dataset
For the purpose of this assignment, the 2018 Survey dataset will be used. You need to download the dataset from eLearn.
Visualisation Software
To perform the visual analysis, students are encouraged to explore any one or a combination of the following software:
- Tableau
- JMP Pro
- Qlik Sense
- Microsoft Power BI
One of the goals of this assignment is for you to learn to use and evaluate the effectiveness of these visual analytics tools.
Submission details
This is an individual assignment. You are required to work on the assignment and prepare submission individually. Your completed assignment is due on 15th March 2020 (Sunday), by 11.59pm mid-night.
You need to edit your assignment in the appropriate wiki page of the Assignment Dropbox. The title of the wiki page should be in the form of: IS428_AY2019-20T2_Assign_FullName.
The assignment wiki page should include the URL link to the web-based interactive data visualization system prepared.
Reference
Past Assignment Page
Specially mentioned
- IS428 2016-17 Term1 Assign3 Gwendoline Tan Wan Xin
- IS428 2016-17 Term1 Assign3 Lim Kim Yong
- IS428 2016-17 Term1 Assign3 Tan Kee Hock
Assignment Q&A
Need more clarification, please feel free to pen down your questions.
