Skip to content

PostgreSQL, SQL, & Tableau project that analyzes 120 years of Olympic games results

Notifications You must be signed in to change notification settings

stephenaigner/Olympics-Results-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 

Repository files navigation

Olympics-Results-Analysis

Description:

This project was an analysis on 120 years of Olympic games results (1896 - 2016). The data was sourced from a public site: Data Source. I created a database and tables with PostgreSQL, imported the CSV files, and then performed various queries for analyisis (See Below). Then I developed a Tableau dashboard Linked Here to visualize key metrics:

  • Total medals count and percentages per country
  • Top winning athletes
  • Total medals and corresponding percentages for different age groups
  • Distribution of each sport's average height, weight, and age
  • Filters for year, sport, country, season and sex

Tableau Dashboard:

Screen Shot 2023-11-15 at 1 19 27 PM Screen Shot 2023-11-15 at 1 20 29 PM Screen Shot 2023-11-15 at 1 20 51 PM

Sample SQL Outputs (See attached file for more):

Top 10 athletes with the most medals:

Screen Shot 2023-11-15 at 1 49 37 PM

Medals won by age group:

Screen Shot 2023-11-15 at 1 51 36 PM

Top 10 countries with the most medals:

Screen Shot 2023-11-15 at 1 52 31 PM

Top 10 years with the most medals won by a single country:

Screen Shot 2023-11-15 at 1 53 29 PM

USA top 10 years with the most medals:

Screen Shot 2023-11-15 at 1 55 08 PM

USA top 10 events with the most medals:

Screen Shot 2023-11-15 at 1 56 27 PM

About

PostgreSQL, SQL, & Tableau project that analyzes 120 years of Olympic games results

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published