Difference between revisions of "ISSS608 2016-17 T1 Assign2 Frandy Eddy"
| Line 1: | Line 1: | ||
= Abstract = | = Abstract = | ||
| − | Survey of faculty members from two Spanish universities on teaching uses of Wikipedia | + | Wikipedia is. Survey of faculty members from two Spanish universities on teaching uses of Wikipedia |
* | * | ||
* | * | ||
| Line 13: | Line 13: | ||
| − | + | = Theme of Interest = | |
| − | + | It is interesting to analyse the survey results on teaching uses of Wikipedia and see if I can get any insights from the data. I am also keen to explore the relationships between the various attributes of the respondent and their assessment. The data can be obtained from [https://archive.ics.uci.edu/ml/datasets/wiki4HE]. From the data, there are some questions that we would like to investigate further. | |
| − | It is interesting to analyse the survey results on teaching uses of Wikipedia and see if I can get any insights from the data. I am also keen to explore the relationships between the various attributes of the respondent and their assessment. The data can be obtained from [https://archive.ics.uci.edu/ml/datasets/wiki4HE]. | ||
| − | |||
| − | |||
| − | From the data | ||
* What | * What | ||
* What | * What | ||
| Line 25: | Line 21: | ||
== Data Preparation == | == Data Preparation == | ||
| + | Before we start to do the analysis, we need to clean the data so that it can be used for analysis. | ||
| + | * It is found that there are some "?" values for some attributes. As we don't know the exact value for these attributes, we will leave it as blank by replacing the "?" values with "" (blank) value. | ||
| + | * An additional ID column is assigned to each respondent to help in the data visualization. | ||
| + | * To be able to visualize the survey results in Tableau, we need to reshape the data so that each question has one row. | ||
| + | * Another column is created to specify the full questions to help the reader to understand the question. | ||
| + | * I also used the "Edit Alias" function in Tableau to rename the attributes according to the information given. | ||
| Line 30: | Line 32: | ||
Tableau 10.0 is used for visualization of the data. | Tableau 10.0 is used for visualization of the data. | ||
JMP Pro 12 and Microsoft Excel are used for data preparation. | JMP Pro 12 and Microsoft Excel are used for data preparation. | ||
| + | |||
= Results = | = Results = | ||
Revision as of 04:00, 26 September 2016
Contents
Abstract
Wikipedia is. Survey of faculty members from two Spanish universities on teaching uses of Wikipedia
Problem and Motivation
Problem:
- What are the
- What are the
Theme of Interest
It is interesting to analyse the survey results on teaching uses of Wikipedia and see if I can get any insights from the data. I am also keen to explore the relationships between the various attributes of the respondent and their assessment. The data can be obtained from [1]. From the data, there are some questions that we would like to investigate further.
- What
- What
- What
- Is
Data Preparation
Before we start to do the analysis, we need to clean the data so that it can be used for analysis.
- It is found that there are some "?" values for some attributes. As we don't know the exact value for these attributes, we will leave it as blank by replacing the "?" values with "" (blank) value.
- An additional ID column is assigned to each respondent to help in the data visualization.
- To be able to visualize the survey results in Tableau, we need to reshape the data so that each question has one row.
- Another column is created to specify the full questions to help the reader to understand the question.
- I also used the "Edit Alias" function in Tableau to rename the attributes according to the information given.
Tools Utilized
Tableau 10.0 is used for visualization of the data. JMP Pro 12 and Microsoft Excel are used for data preparation.
Results
Here are some of the results based on the questions that we have defined.
A
A
A
A
Link to Tableau Public :
Dashboard 1[2]
Dashboard 2[3]
Dashboard 3[4]
References
http://www.datarevelations.com/using-tableau-to-visualize-survey-data-part-1.html
http://www.datarevelations.com/using-tableau-to-visualize-survey-data-part-2.html
