|
|
| Line 1: |
Line 1: |
| − | == 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 [https://library.smu.edu.sg/about-us/library-service-quality-survey latest survey] is currently ongoing and will be ended by 17th February 2020.
| |
| | | | |
| − | The 2018 Survey Results can be found [https://library.smu.edu.sg/about/about-us/library-service-quality-survey/2018-survey-results here] and the full report is available by following this [https://library.smu.edu.sg/sites/library.smu.edu.sg/files/library/pdf/SMULibraries_BeHeardSurvey_FullReport.pdf link]. The past reports are mainly made-up of pages of tables, which are very difficult to comprehend. Given this, your task is to apply appropriate data visualisation to transform these tables into a visual representation that allow SMU libraries to gain useful insights.
| |
| − |
| |
| − |
| |
| − | == Task ==
| |
| − | In this assignment, you are required to use 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.
| |
| − |
| |
| − | == Data preparation ==
| |
| − | <p>We are given 2 datasets, Raw data 2018-03-07 and SMU Library Survey Comments. Unfortunately, these two given datasets are not well structured and cannot be directly used. So, I will mainly focus on data cleaning and data preparation in this section.</p>
| |
| − |
| |
| − | '''Raw data 2018-03-07 SMU LCS data file'''
| |
| − | <p>There are two worksheets in this raw data. The first worksheet record all response data from all participants. The second worksheet contains all the column name (legend)
| |
| − | for the first worksheet.</p>
| |
| − | [[File:Mz3.jpg|900px|center]]<br>
| |
| − |
| |
| − | <p>'''Issue 1:''' When I take a closer look into the data, I realized that all the assessments are in measures format instead of dimensions.</p>
| |
| − |
| |
| − | <p>'''Solution:''' Use tableau to pivot the selected survey assessment values. <br> Detail steps 1. Select column from 'I01' to the end. 2. Under the drop down menu select 'pivot'. 3. Rename the Pivot Field Name to Assessments, Pivot Filed Value to score.</p>
| |
| − | [[File:Mz5.jpg|900px|center]]<br>
| |
| − | <p>'''Issue 2:''' The column name (legend) and data rows are in two separate worksheets. Without knowing about each column's name, it is impossible for us to conduct the visualization.</p>
| |
| − |
| |
| − | <p>'''Solution:''' Use tableau built-in function to join these two dataset together. <br> Detail steps 1. Import the raw data into tableau. 2. Drag the worksheets to the connection field and choose left join (SMU on left side, Legend on right side). 3. Under left join, select Assessments = Code.</p>
| |
| − | [[File:Mz4.png|500px|center]]
| |
| − | <br>
| |
| − |
| |
| − | == Interactive Visualization ==
| |
| − |
| |
| − | <p>'''The interactive visualization can be accessed here:https://public.tableau.com/profile/tian.mingze#!/vizhome/assignment_15840201936860/Story1'''</p>
| |
| − | <p>The followings are some of the interactive technics that used by this application:</p>
| |
| − | {| class="wikitable"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | Interactive Technique
| |
| − | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Rationale
| |
| − | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;" | Brief Implementation Steps
| |
| − | |-
| |
| − | | <center>'''Filter participant postion with a single value selection list''' <br/>
| |
| − | [[File:Mz6.png|150px|center]]
| |
| − | </center>
| |
| − | || <center>Provide flexibility for analysts, the analyst can choose the participant position that they are interested to analyse.
| |
| − | The checkboxes are not used in this case because it requires the analyst manually uncheck the unwanted value. And the dropdown menu is not intuitive enough in this case. Thus, a single selection value list is preferred.</center>
| |
| − | ||
| |
| − | # Use calculation field to convert the position from digit value to plain text (ie. undergraduate, staff ...)
| |
| − | # Rename the calculation field as 'Choose Participant Position'
| |
| − | # Put both the calculation field and the 'position' dimension into the filter to filter out those useless value (ie. others, exchange...)
| |
| − | |-
| |
| − | | <center>'''Filter different libraries with a single value selection list'''
| |
| − | [[File:Mz7.png|150px|center]]
| |
| − | </center>
| |
| − | || <center>It is unnecessary to use a drop-down menu right here since we only have two different libraries. This also provides the flexibility for analysts, the analyst can choose the library that they are interested to analyse.</center>
| |
| − | ||
| |
| − | # Use calculation field to convert the Campus dimension from digit value to plain text
| |
| − | <br>
| |
| − | <center>2. Rename the calculation field as 'Choose Library'</center>
| |
| − | |-
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | === Dashboard ===
| |
| − | <p>My analysis contains four visualizations and one comment field and they located in a different dashboard. So, I decided to use a storyboard. By using this storyboard, the analyst can easily navigate to between different dashboards.</p><br/>
| |
| − | [[File:Mz21.png|800px|center]]
| |
| − |
| |
| − | === Overview ===
| |
| − | <p>This Overview dashboard provides an overall result for all quantitative survey assessments. For this section, Instead of calculating each assessment's average score, I use the count number of promoters. Because, the average score is not a good way to measure participants' satisfaction level. I used a combined bar chart to make a comparison between importance and performance and sort the bar chart based on importance. Based on this combined bar chart, the analyst can have an overview of each service's importance and performance. </p><br/>
| |
| − | [[File:Mz22.png|800px|center]]
| |
| − | {| class="wikitable"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | Interactive Technique
| |
| − | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Rationale
| |
| − | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;" | Brief Implementation Steps
| |
| − |
| |
| − | |-
| |
| − | | <center>'''Dynamic Title''' <br>
| |
| − | [[File:Mz8.png|500px|center]]
| |
| − | </center>
| |
| − | || <center>By adding this dynamic title, all the filter value will appear in the title. The visualization will become more intuitive for the analyst. </center>
| |
| − | ||
| |
| − | # Double click the title and choose insert. Select the two calculation field (Choose Library, Choose Participant Position)
| |
| − | # Use the red colour to highlight important information.
| |
| − |
| |
| − | |-
| |
| − | |}
| |
| − | <br/>
| |
| − | ===Gap between Importance and Performance & suggestions===
| |
| − | <p>This page is mainly for us to find out the service gap between library users' expectation and its actual performance. Relevant library service needs to be improved if the gap is too wide.
| |
| − | Gap equals to 50 means there are 50 library survey participants belive that this specific service is important to them but its performance is bad. </p><br/>
| |
| − | [[File:Mz23.png|1400px|center]]
| |
| − | {| class="wikitable"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | Interactive Technique
| |
| − | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Rationale
| |
| − | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;" | Brief Implementation Steps
| |
| − |
| |
| − | |-
| |
| − | | <center>'''Dynamic Tooltip''' <br>
| |
| − | [[File:Mz9.png|500px|center]]
| |
| − | </center>
| |
| − | || <center>When the analyst hovers his mouse on this treemap, he will be able to see an interactive tooltip which shows the suggestions on this assessment. He can adopt further actions (ie check the satisfactory level, important comments) based on this suggestion.</center>
| |
| − | ||
| |
| − | <center> 1. Create another calculation field 'tooltip_for_treemap' to generate appropriate suggestions based on the gap between library users' expectation of this service and this service's actual performance.</center>
| |
| − | <br>
| |
| − | <center> 2. Put this calculation field under 'detail' and insert into the tooltip.</center>
| |
| − |
| |
| − | |-
| |
| − | |}
| |
| − | ===Level of Satisfaction & Comments===
| |
| − | <p>This page is mainly for the analyst to check library users' satisfaction level by detractors, passives, promoters and their comments. </p>
| |
| − | [[File:Mz24.png|1200px|center]]
| |
| − | == Analysis & Insights ==
| |
| − |
| |
| − | === Undergraduate Students ===
| |
| − | ====Li Ka Shing Library====
| |
| − | [[File:Mz27.png|1000px|center]]
| |
| − | # Among all the undergraduate students who think the '''quite learning space''' provided by Li Ka Shing Library is important '''(select 6/7 or 7/7 for the importance field)''', around '''48%''' of them are '''not satisfied''' with the performance '''(did not select 6/7 or 7/7 for the same performance field)''' of this service. (736 out of 1535 responds)
| |
| − | # Among all the undergraduate students who think the '''group discussion space''' provided by Li Ka Shing Library is important, around '''46%''' of them are '''not satisfied''' with the performance of this service. (606 out of 1310 responds)
| |
| − | # Among those undergraduate students who think the '''printing, scanning and photocopying facilities''' in the Li Ka Shing Library is important, around '''23%''' of them are '''not satisfied''' with the performance of this service. (347 out of 1514 responds)
| |
| − |
| |
| − | ====Kwa Geok Choo Library====
| |
| − | [[File:Mz28.png|900px|center]]
| |
| − | # Among all the undergraduate students who think the '''quite learning space''' provided by Kwa Geok Choo library is important, around '''43%''' of them are '''not satisfied''' with the performance of this service. (113 out of 265 responds)
| |
| − | # Among all the undergraduate students who think the '''group discussion space''' provided by Kwa Geok Choo library is important, around '''44%''' of them are '''not satisfied''' with the performance of this service. (105 out of 239 responds)
| |
| − | # Among all the undergraduate students who think the '''opening hours''' in Kwa Geok Choo library is important, around '''30%''' of them are '''not satisfied''' with the performance of this service. (72 out of 247 responds)
| |
| − | # Among all the undergraduate students who think the '''printing, scanning and photocopying facilities''' in the Kwa Geok Choo library is important, around '''27%''' of them are '''not satisfied''' with the performance of this service. (66 out of 248 responds)
| |
| − |
| |
| − |
| |
| − | === Postgraduate Students ===
| |
| − | ====Li Ka Shing Library====
| |
| − | [[File:Mz29.png|1000px|center]]
| |
| − | # Among all the postgraduate students who think the '''quite learning space''' provided by Li Ka Shing Library is important, around '''40%''' of them are '''not satisfied''' with the performance of this service. (83 out of 205 responds)
| |
| − | # Among all the postgraduate students who think the '''group discussion space''' provided by Li Ka Shing Library is important, around '''35%''' of them are '''not satisfied''' with the performance of this service. (67 out of 191 responds)
| |
| − | # Among all the postgraduate students who think the '''printing, scanning and photocopying facilities''' in the Li Ka Shing Library is important, around '''23%''' of them are '''not satisfied''' with the performance of this service. (44 out of 189 responds)
| |
| − |
| |
| − | ====Kwa Geok Choo Library====
| |
| − | [[File:Mz30.png|700px|center]]
| |
| − | # Among the postgraduate students who think the '''printing, scanning and photocopying facilities''' in the Kwa Geok Choo library is important, around '''68%''' of them are '''not satisfied''' with the performance of this service. (15 out of 22 responds)
| |
| − | # Among the postgraduate students who think the '''opening hours''' in Kwa Geok Choo library is important, around '''45%''' of them are '''not satisfied''' with the performance of this service. (10 out of 23 responds)
| |
| − |
| |
| − | === Faculty ===
| |
| − | ====Li Ka Shing Library====
| |
| − | [[File:Mz31.png|700px|center]]
| |
| − | # Among the faculties who think the '''search engine''' in Li Ka Shing Library is important, around '''38%'''of them are '''not satisfied''' with the performance of this service. (18 out of 47 responds)
| |
| − |
| |
| − | === Staff ===
| |
| − | ====Li Ka Shing Library====
| |
| − | [[File:Mz32.png|800px|center]]
| |
| − | #Among the staffs who think the '''book management service (books are usually on shelves)''' in Li Ka Shing Library is important, around '''32%''' of them are '''not satisfied''' with the performance of this service. (23 out of 71 responds)
| |
| − | # Among the staffs who think the '''search engine''' in Li Ka Shing Library is important, around '''27%''' of them are '''not satisfied''' with the performance of this service. (20 out of 73 responds)
| |
| − |
| |
| − | == Reference ==
| |
| − | https://wiki.smu.edu.sg/1617t1IS428g1/IS428_2016-17_Term1_Assign3_Gwendoline_Tan_Wan_Xin
| |
