The Olympiad

From Visual Analytics for Business Intelligence
Revision as of 09:03, 18 November 2018 by Yuxi.chew.2016 (talk | contribs)
Jump to navigation Jump to search
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