Difference between revisions of "IS428 Team wiki: Group12(CJS) Proposal"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 44: Line 44:
 
4. Identify whether there has been a change in the weightage for the individual parameters towards the final happiness index ranking from year to year. (Tentative)
 
4. Identify whether there has been a change in the weightage for the individual parameters towards the final happiness index ranking from year to year. (Tentative)
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">DATA DESCRIPTION</font></div>
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">DATA DESCRIPTION</font></div>
''coming soon''
+
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
! style="font-weight: bold;background: #138D75;color:#fbfcfd;width: 50%;" | Dataset/ Source
 +
! style="font-weight: bold;background: #138D75;color:#fbfcfd;" | Data Attributes
 +
! style="font-weight: bold;background: #138D75;color:#fbfcfd;" | Rationale of Usage
 +
|-
 +
|
 +
World Happiness Report Data 2006-2017<br>
 +
https://s3.amazonaws.com/happiness-report/2018/WHR2018Chapter2OnlineData.xls<br>
 +
table2.1
 +
||
 +
* County
 +
* Year
 +
* Life Ladder
 +
* Log GDP per capita
 +
* Social Support
 +
* Healthy life expectancy at birth
 +
* Freedom to make life choices
 +
* Generosity
 +
* Perceptions of corruption
 +
* Positive affect
 +
* Negative affect
 +
* Confidence in national government
 +
* Democratic Quality
 +
* Delivery Quality
 +
* Standard deviation of ladder by country-year
 +
* Stand deviation/ Mean of ladder by country-year
 +
* GINI index (World Bank estimate)
 +
* GINI index (World Bank estimate), average 2000-15
 +
* GINI of household income reported in Gallup, by wp5-year
 +
  ||
 +
See the overall performance of each individual country changes from year 2006 onwards
 +
|-
 +
| World Happiness Report Data 2017<br>
 +
https://s3.amazonaws.com/happiness-report/2018/WHR2018Chapter2OnlineData.xls<br>
 +
Figure2.2
 +
||
 +
* Country
 +
* Happiness score
 +
* Whisker-high
 +
* Whisker-low
 +
* Dystopia + residual
 +
* GDP Per capita
 +
* Social support
 +
* Healthy life expectancy
 +
* Freedom to make life choices
 +
* Generosity
 +
* Corruption
 +
||
 +
Show data of one particular  year(2017), its overall score and thus can get how the final happiness score is calculated
 +
|-
 +
|}
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">SURVEY OF RELATED WORK</font></div>
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">SURVEY OF RELATED WORK</font></div>
 
Our visualization are inspired by the following works:
 
Our visualization are inspired by the following works:
Line 78: Line 129:
 
|}
 
|}
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROPOSED STORYBOARD</font></div>
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROPOSED STORYBOARD</font></div>
''coming soon''
+
 
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
! style="font-weight: bold;background: #138D75;color:#fbfcfd;width: 50%;" | Visualization
 +
! style="font-weight: bold;background: #138D75;color:#fbfcfd;" | Description
 +
|-
 +
| <p><center>'''Main Visualisation: Line Graph''' </center></p>
 +
[[File:CJStory1.jpg|600px|center]]
 +
||
 +
Purpose:
 +
A general view that presents time series data of the happiness ranking between the different countries from the year 2008 to 2017.
 +
<br>Features to be included:
 +
* Filter for country selection that enables viewers to observe the change in trend over the years for specific countries.
 +
|-
 +
| <p><center>'''Main Visualisation: Chloropleth Map''' </center></p>
 +
[[File:CJStory1_1.jpg|600px|center]]
 +
||
 +
Purpose:
 +
To show the geographical distribution of the happiness index and the 6 sub-factors for selected years using a chloropleth map. This helps the user identify trends between regions. For example, users could see if Asian countries are “happier” than African countries.
 +
<br>Features to be included:
 +
* Different colour intensity would be used to represent the varying values of each factors.
 +
* Filter for user to observe data by individual years and happiness index factors.
 +
|-
 +
| <p><center>'''Main Visualisation: Bar chart''' </center></p>
 +
[[File:CJStory2.jpg|600px|center]]
 +
||
 +
Purpose:
 +
To identify any correlation between the 6 sub-factors and the happiness index. Users can see, for example, what the happiness index are for countries with just the highest GDP
 +
<br>Features to be included:
 +
* The bar length would be used to visualise the magnitude of the selected sub-factors while the number to the side of the bar chart would refer to the happiness index rank of the country.
 +
* There would be a slider below the chart that would allow users to scroll through and see the bar chart visualisations for the different years.
 +
* Filter for the 6 sub-factors.
 +
|-
 +
|-
 +
| <p><center>'''Main Visualisation: Parallel Coordinates with Boxplot''' </center></p>
 +
[[File:CJStory3.jpg|600px|center]]
 +
||
 +
Purpose
 +
To help identify trends between the 6 sub-factors among the different countries.
 +
<br>Features to be included:
 +
* Boxplot on each of the axis to enable the user to see the distribution for each of the sub-factors.
 +
* Brushing feature for users to select a range values in the chart.
 +
* Filter for people to select the year.
 +
|-
 +
|}
 +
 
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">REFERENCES</font></div>
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">REFERENCES</font></div>
 
''coming soon''
 
''coming soon''
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">KEY CHALLENGES</font></div>
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">KEY CHALLENGES</font></div>
 
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
Line 99: Line 194:
 
* Consultation with professor to get help.
 
* Consultation with professor to get help.
 
|-
 
|-
| Unfamiliar with R as a new language
+
| Unfamiliar with R as a new programming language
 
  ||  
 
  ||  
 
* Learn R individually.
 
* Learn R individually.
Line 105: Line 200:
 
|-
 
|-
 
|}
 
|}
 
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">VISUALIZATION SKETCH</font></div>
 
<div style="background: #138D75; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">VISUALIZATION SKETCH</font></div>
 
Please check out our visualization sketch to better understand the process.
 
Please check out our visualization sketch to better understand the process.

Revision as of 20:53, 14 October 2018

CJSlogo.png

HOME

 

PROPOSAL

 

POSTER

 

APPLICATION

 

RESEARCH PAPER


PROBLEM & MOTIVATION

Problem How happy are you today? How happy were you yesterday? How about last year? Well, this may sound bizarre but did you know happiness can be measured? In fact, since 2012, the United Nations Sustainable Development Solutions Network has been publishing a world happiness report which uses 6 parameters - GDP per capita, social support, healthy life expectancy, freedom to make life choices, generosity, and perception of corruption - to come up with the happiness index for different countries yearly. As a result, we were curious as to whether there is something more the large amount of data being used in this report could tell us.

Motivation The United Nations SDSN publishes reports that present the ranking of the individual countries for the year it is published in but in it, happiness index trends of different countries over the years are not clearly presented. We can realize the importance of such trends when we take the example of Singapore. In 2018, Singapore’s was ranked 34th out of 155 countries in terms of happiness. Though this may seem somewhat high, when we compare it with their 26th ranking in 2017 will we realise that Singapore is becoming a less “happier” country. Therefore, our team would like to observe the data relatively and identify whether such trends are common for other countries as well. Secondly, we are curious to see which of the 6 factors are more closely linked to a happier countries and observe what it would take for countries to be “happier”, by UN’s standards. A country ranked first in the world happiness index might not rank first in one of the 6 factors. Thus, we would like to identify the relationship between the happiness index and the 6 different factors that contribute to it. Also, through this, our team would like to find out whether there has been any inconsistency involved in the ranking over the years and possibly, we could reveal new information in regards to the world happiness index.

OBJECTIVES

1. Identify the overall trends of happiness ranking index of countries over the years between 2008 to 2017
2. Identify the rankings of the each of 6 parameters that make up the happiness index of countries from the years 2008 to 2017
3. Compare the 6 parameters between the selected countries and see how they fare in relation to their final happiness index ranking from the years 2008 to 2017
4. Identify whether there has been a change in the weightage for the individual parameters towards the final happiness index ranking from year to year. (Tentative)

DATA DESCRIPTION
Dataset/ Source Data Attributes Rationale of Usage

World Happiness Report Data 2006-2017
https://s3.amazonaws.com/happiness-report/2018/WHR2018Chapter2OnlineData.xls
table2.1

  • County
  • Year
  • Life Ladder
  • Log GDP per capita
  • Social Support
  • Healthy life expectancy at birth
  • Freedom to make life choices
  • Generosity
  • Perceptions of corruption
  • Positive affect
  • Negative affect
  • Confidence in national government
  • Democratic Quality
  • Delivery Quality
  • Standard deviation of ladder by country-year
  • Stand deviation/ Mean of ladder by country-year
  • GINI index (World Bank estimate)
  • GINI index (World Bank estimate), average 2000-15
  • GINI of household income reported in Gallup, by wp5-year

See the overall performance of each individual country changes from year 2006 onwards

World Happiness Report Data 2017

https://s3.amazonaws.com/happiness-report/2018/WHR2018Chapter2OnlineData.xls
Figure2.2

  • Country
  • Happiness score
  • Whisker-high
  • Whisker-low
  • Dystopia + residual
  • GDP Per capita
  • Social support
  • Healthy life expectancy
  • Freedom to make life choices
  • Generosity
  • Corruption

Show data of one particular year(2017), its overall score and thus can get how the final happiness score is calculated

SURVEY OF RELATED WORK

Our visualization are inspired by the following works:

Reference Visualization Work Our Team's Take-away

World Map

CJSref1.jpg

Source: http://shiny.rstudio.com/gallery/superzip-example.html

  • It will be a clear visualization to show the happiness index of the country using the world map itself. User only need to hover on the map of the country that they are interested in.
  • Our team aim to use a single hue of color with different intensity to show the happiness index of countries. As per the visualization, our team will also make use of the tool-tip to display 6 parameters of happiness index when the user hover on the specific country. Tentatively, Hexagon map with 6 axis representing 6 parameters will also displayed.

Interactive Ranking Bar Chart

CJSref2.jpg

Source: https://www.gapminder.org/tools/#$chart-type=barrank

  • As per the visualization, the ranking of country defined by the selected parameter is to be shown with the bar chart. In our work, the parameter will be from one of the 6 parameters.
  • Our team aim to substitute the number beside the bar with the happiness index rating so the user can see the comparison of the rating and the parameter straight away.

Parallel Coordinates Plot

CJSrefParallel.jpg

Source: https://bl.ocks.org/jasondavies/1341281

  • Thanks to prof guidance, parallel coordinates plot was introduced in the class. All the parameters which defined the lines are displayed concurrently in parallel coordinates.
  • In our visualization, 6 parameters will be 6 axis and there will be different lines for different countries. So, the user can compare all the parameters instantly.
PROPOSED STORYBOARD
Visualization Description

Main Visualisation: Line Graph

CJStory1.jpg

Purpose: A general view that presents time series data of the happiness ranking between the different countries from the year 2008 to 2017.
Features to be included:

  • Filter for country selection that enables viewers to observe the change in trend over the years for specific countries.

Main Visualisation: Chloropleth Map

CJStory1 1.jpg

Purpose: To show the geographical distribution of the happiness index and the 6 sub-factors for selected years using a chloropleth map. This helps the user identify trends between regions. For example, users could see if Asian countries are “happier” than African countries.
Features to be included:

  • Different colour intensity would be used to represent the varying values of each factors.
  • Filter for user to observe data by individual years and happiness index factors.

Main Visualisation: Bar chart

CJStory2.jpg

Purpose: To identify any correlation between the 6 sub-factors and the happiness index. Users can see, for example, what the happiness index are for countries with just the highest GDP
Features to be included:

  • The bar length would be used to visualise the magnitude of the selected sub-factors while the number to the side of the bar chart would refer to the happiness index rank of the country.
  • There would be a slider below the chart that would allow users to scroll through and see the bar chart visualisations for the different years.
  • Filter for the 6 sub-factors.

Main Visualisation: Parallel Coordinates with Boxplot

CJStory3.jpg

Purpose To help identify trends between the 6 sub-factors among the different countries.
Features to be included:

  • Boxplot on each of the axis to enable the user to see the distribution for each of the sub-factors.
  • Brushing feature for users to select a range values in the chart.
  • Filter for people to select the year.
REFERENCES

coming soon

KEY CHALLENGES
Key Technical Challenges Proposed Solution

No centralized data. Data are all divided year by year.

  • Gather all data and join all sets together.
  • Clean and transform the data.
Unfamiliar with Visualization Tools
  • Research on how to use there tools properly.
  • Consultation with professor to get help.
Unfamiliar with R as a new programming language
  • Learn R individually.
  • Incorporate Transformed html page with Javascript & JQuery to give smooth and user-friendly interface.
VISUALIZATION SKETCH

Please check out our visualization sketch to better understand the process.

CJSthinkingProcess.png

For section 1(left side of the above image), users would be greeted with a general view of the data from 2008 to 2017. through the time series data and the geographical distribution.This section aim to fulfil objective 1. User can hover the map and see the individual parameter of the happiness index of the country in the specific year. User need to select the year for Chloropleth map.
Visualization presented:

  1. Line Graph
  2. Chloropleth map

Section 2(top right of the image) presents a more drilled down view as trends specifically related to the sub factors that make up the final happiness index can be seen here after the user selects the parameter and year. Tentatively, user only need to select parameter and the chart will change dynamically according to the year. This section aim to fulfil objective 2.
Visualizations presented:

  1. Bar Chart

For the section 3(bottom right of the image), the column or the y-axis are parameters and different lines represent different countries.This section aim to fulfil objective 3.
Visualizations presented:

  1. Parallel Coordinates
MILESTONES AND TASK DESCRIPTIONS

Milestones are indicated with the star.

CJSProjTimeline.png
COMMENTS

Please provide us with any comments to improve our visualization better.