Difference between revisions of "The Olympiad"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 14: Line 14:
 
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',Roboto,'Helvetica Neue',Arial,sans-serif"> [[The Olympiad: Team | <b>Team</b>]]
 
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',Roboto,'Helvetica Neue',Arial,sans-serif"> [[The Olympiad: Team | <b>Team</b>]]
 
|}
 
|}
 +
 +
<div style="margin-top:50px; margin-bottom:20px; font-weight: bold; line-height: 0.3em; letter-spacing:-0.08em;font-size:24px"><font color=#1d1d1d face="Century Gothic">INTRODUCTION</font></div>
 +
<p>The Olympic Games can be traced back to 776BC and were dedicated to the gods of Olympia. Today, the Olympic Games has become the world’s largest sports competition, with more than 200 nations participating every four years. Every four years, the Olympics gives unknown athletes to attain national and possibly, international fame. </p>
 +
 +
<div style="margin-top:40px; margin-bottom:20px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:24px"><font color=#1d1d1d face="Century Gothic">PROBLEM & MOTIVATION</font></div>
 +
<p>The Olympic Games provides an international platform for sportsmen from all walks of life and origins to display their skills and be rewarded for their persistence and dedication to the sport. However, the Olympic Games suffers the issue of Olympic Dynasties, where certain countries dominate the same events again and again The excessive dominance in some sports puts to question the fairness of the Olympics. Furthermore, the host country often has a home ground advantage, which again, threatens the fairness of the competition. </p>
 +
 +
<div style="margin-top:40px; margin-bottom:20px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:24px"><font color=#1d1d1d face="Century Gothic">Objectives</font></div>
 +
The goal of this project is to create a visualisation that <b>educates the public</b> about the:
 +
# Severity of Dominance of Continents in various sports
 +
# Severity of Dominance of Countries in various sports
 +
# Severity of Bias for the Host Country
 +
 +
<div style="margin-top:40px; margin-bottom:20px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:24px"><font color=#1d1d1d face="Century Gothic">Dataset</font></div>
 +
 +
{| class="wikitable" width="100%"
 +
|-
 +
! style="font-weight: bold;background-color: #1d1d1d;color:#ffffff;text-align:center;" | Athletes and Results
 +
|-
 +
| style="text-align:center;" | Medal results, and basic biological data of participants of the Athens 1896 to Rio 2016 Games.  [https://www.kaggle.com/heesoo37/120-years-of-olympic-history-athletes-and-results | Source]
 +
|-
 +
| style="text-align:center;" |
 +
{| class="wikitable" width="100%"
 +
|-
 +
! style="text-align:center;" | Variable Name
 +
!! style="text-align:center;" | Data Type
 +
!! style="text-align:center;" | Sample
 +
|-
 +
| ID || integer, primary key|| 1
 +
|-
 +
| Name || string|| Lebron James
 +
|-
 +
| Sex || string|| M
 +
|-
 +
| Age|| integer  || 24
 +
|-
 +
| Height || integer  || 180
 +
|-
 +
| Weight || integer  || 80
 +
|-
 +
| Team || string || United States
 +
|-
 +
| NOC || string || USA
 +
|-
 +
| Year || date|| 1992
 +
|-
 +
| Season || string || Summer
 +
|-
 +
| City || string || Barcelona
 +
|-
 +
| Sport || string || Basketball
 +
|-
 +
| Event || string || Basketball Men's Basketball
 +
|-
 +
| Medal || string || Gold
 +
|}
 +
|}
 +
 +
{| class="wikitable" width="100%"
 +
|-
 +
! style="font-weight: bold;background-color: #1d1d1d;color:#ffffff;text-align:center;" | NOC Code and Country
 +
|-
 +
| style="text-align:center;" |  National Olympic Committee 3 letter code for each country [https://www.kaggle.com/heesoo37/120-years-of-olympic-history-athletes-and-results | Source]
 +
|-
 +
| style="text-align:center;" |
 +
{| class="wikitable" width="100%"
 +
|-
 +
! style="text-align:center;" | Variable Name
 +
!! style="text-align:center;" | Data Type
 +
!! style="text-align:center;" | Sample
 +
|-
 +
| NOC Code || string || AHO
 +
|-
 +
| Country || string|| Curacao
 +
|-
 +
| Notes || string|| Netherlands Antilles
 +
|}
 +
|}
 +
 +
{| class="wikitable" width="100%"
 +
|-
 +
! style="font-weight: bold;background-color: #1d1d1d;color:#ffffff;text-align:center;" | World Countries and Continents Details
 +
|-
 +
| style="text-align:center;" |  World countries with their corresponding continents , official english names, official french names, Dial,ITU,Languages and so on. [https://www.kaggle.com/folaraz/world-countries-and-continents-details | Source]
 +
|-
 +
| style="text-align:center;" |
 +
{| class="wikitable" width="100%"
 +
|-
 +
! style="text-align:center;" | Variable Name
 +
!! style="text-align:center;" | Data Type
 +
!! style="text-align:center;" | Sample
 +
|-
 +
| Name || string || Afghanistan
 +
|-
 +
| Continent || string|| AS
 +
|}
 +
|}
 +
 +
<div style="margin-top:40px; margin-bottom:20px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:24px"><font color=#1d1d1d face="Century Gothic">Background Survey of Related Works</font></div>

Revision as of 09:03, 18 November 2018

The Olympiad.png
INTRODUCTION

The Olympic Games can be traced back to 776BC and were dedicated to the gods of Olympia. Today, the Olympic Games has become the world’s largest sports competition, with more than 200 nations participating every four years. Every four years, the Olympics gives unknown athletes to attain national and possibly, international fame.

PROBLEM & MOTIVATION

The Olympic Games provides an international platform for sportsmen from all walks of life and origins to display their skills and be rewarded for their persistence and dedication to the sport. However, the Olympic Games suffers the issue of Olympic Dynasties, where certain countries dominate the same events again and again The excessive dominance in some sports puts to question the fairness of the Olympics. Furthermore, the host country often has a home ground advantage, which again, threatens the fairness of the competition.

Objectives

The goal of this project is to create a visualisation that educates the public about the:

  1. Severity of Dominance of Continents in various sports
  2. Severity of Dominance of Countries in various sports
  3. Severity of Bias for the Host Country
Dataset
Athletes and Results
Medal results, and basic biological data of participants of the Athens 1896 to Rio 2016 Games. | Source
Variable Name Data Type Sample
ID integer, primary key 1
Name string Lebron James
Sex string M
Age integer 24
Height integer 180
Weight integer 80
Team string United States
NOC string USA
Year date 1992
Season string Summer
City string Barcelona
Sport string Basketball
Event string Basketball Men's Basketball
Medal string Gold
NOC Code and Country
National Olympic Committee 3 letter code for each country | Source
Variable Name Data Type Sample
NOC Code string AHO
Country string Curacao
Notes string Netherlands Antilles
World Countries and Continents Details
World countries with their corresponding continents , official english names, official french names, Dial,ITU,Languages and so on. | Source
Variable Name Data Type Sample
Name string Afghanistan
Continent string AS
Background Survey of Related Works
Retrieved from ‘https://wiki.smu.edu.sg/18191is428g1/index.php?title=The_Olympiad&oldid=3878’