Difference between revisions of "IS428 AY2019-20T2 Assign CHUA MING YU"
Jump to navigation
Jump to search
(Created page with "<div style=background:#2B3856 border:#A3BFB1> <font size = 5; color="#FFFFFF">IS428 Visual Analytics for Business Intelligence </font> </div> <!--MAIN HEADER --> <br/> =Overv...") |
(→Data) |
||
| Line 11: | Line 11: | ||
The interactive tableau chart can be found at here [https://public.tableau.com/profile/chua.ming.yu#!/vizhome/assignmentv2_15842653998620/Story1?publish=yes] | The interactive tableau chart can be found at here [https://public.tableau.com/profile/chua.ming.yu#!/vizhome/assignmentv2_15842653998620/Story1?publish=yes] | ||
| − | =Data= | + | =Data Preperation= |
| + | Tableau Prep was used to process the data given in "Raw data 2018-03-07 SMU LCS data file - KLG.xlsx" | ||
| + | The overall steps look like: | ||
| + | [[File:9 overall 2.png|1000px|center]] | ||
| + | |||
| + | Below will be a step by step guide of what I did to get the final output. | ||
| + | |||
| + | {| class="wikitable" style="margin-left: auto; margin-right: auto; width: 100%; | ||
| + | |- | ||
| + | ! style="font-family:Verdana; background: #03c2fc;color: #FFFFFF;width: 15%;font-size:18px;" |Screenshot | ||
| + | ! style="font-family:Verdana; background: #03c2fc;color: #FFFFFF;width: 15%;font-size:18px;" |Steps | ||
| + | |||
| + | |- | ||
| + | |[[File:1step1.png|200px|center]] | ||
| + | | I added both sheets into tableau prep | ||
| + | |||
| + | |- | ||
| + | | | ||
| + | [[File:2remove na.png|200px|center]] | ||
| + | | I removed all the responses where respondents responded that it is not applicable to them | ||
| + | |||
| + | |- | ||
| + | | | ||
| + | [[File:3pivot1.png|200px|center]] | ||
| + | | I pivoted the values so that instead of having multiple responses to multiple questions in one row, each row will represent one response to one question | ||
| + | |||
| + | |- | ||
| + | | | ||
| + | [[File:4pivot2.png|200px|center]] | ||
| + | | I renamed several columns so that the headers have more meaning. Then I pivoted it so that there will be one row per question and answer. | ||
| + | |||
| + | |- | ||
| + | | | ||
| + | [[File:5filter null.png|200px | center]] | ||
| + | <br> | ||
| + | [[File:6remove null.png|200px|center]] | ||
| + | | I filtered out all the null values that appear due to the previous pivot step. | ||
| + | |||
| + | |- | ||
| + | | | ||
| + | [[File:7join.png|200px|center]] | ||
| + | | I did an inner join on both sheets so that I can get all the responses and their corresponding meaning | ||
| + | |||
| + | |- | ||
| + | | | ||
| + | [[File:8clean.png|500px|center]] | ||
| + | | I used a whole bunch of merge statements to replace the responses for Position, StudyArea, ID, Campus. This allows for the values to have meaning instead of staying as numbered responses. | ||
| + | |||
| + | |} | ||
=Graphs and insights= | =Graphs and insights= | ||
Revision as of 18:36, 15 March 2020
IS428 Visual Analytics for Business Intelligence
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 interactive tableau chart can be found at here [1]
Data Preperation
Tableau Prep was used to process the data given in "Raw data 2018-03-07 SMU LCS data file - KLG.xlsx"
The overall steps look like:
Below will be a step by step guide of what I did to get the final output.
| Screenshot | Steps |
|---|---|
 |
I added both sheets into tableau prep |
 |
I removed all the responses where respondents responded that it is not applicable to them |
 |
I pivoted the values so that instead of having multiple responses to multiple questions in one row, each row will represent one response to one question |
 |
I renamed several columns so that the headers have more meaning. Then I pivoted it so that there will be one row per question and answer. |
 |
I filtered out all the null values that appear due to the previous pivot step. |
 |
I did an inner join on both sheets so that I can get all the responses and their corresponding meaning |
 |
I used a whole bunch of merge statements to replace the responses for Position, StudyArea, ID, Campus. This allows for the values to have meaning instead of staying as numbered responses. |
