Olympics Data Analysis and Insights

Project Overview:
Olympic Performance Analytics explores over a century of athlete data to uncover the evolution of sports, performance, and demographics in the Olympic Games.
Using data from the SportsStats Olympic Dataset, this project analyzes patterns in medal counts, gender participation, physical attributes (age, height, weight), and country-level performance.
The goal is to reveal long-term trends that shape global sports success and highlight how athletes and nations have evolved over time.

Project Workflow

Data Cleaning & Preparation (Python / DuckDB)

  • Cleaned and merged athlete and regional datasets, handling missing values and duplicates.

  • Standardized column names, converted data types, and filtered meaningful records for analysis.

  • Used DuckDB SQL for efficient querying and joined datasets to create a structured analytical model.

  • Explored descriptive statistics to understand medal distribution, gender ratios, and athlete profiles.

Data Exploration & Analysis (SQL / Python)

  • Investigated medal trends by country.

  • Compared male and female participation growth over time.

  • Calculated average age, height, and weight by sport and medal type to uncover sport-specific physical profiles.

Visualization & Insights (Matplotlib)

  • Created visualizations to show medal dominance, gender trends, and athlete evolution.

  • Developed charts for physical profiles across sports and relationships among key metrics.

Key Insights

  • 🥇 Dominance Patterns: The USA, Russia, and Germany consistently lead in medal counts, but smaller countries like Namibia and Kuwait show exceptional medal efficiency per athlete.

  • 👩‍🦰 Gender Trends: Female athlete participation has steadily grown since 1980, marking a major step toward equality in global sports.

  • ⚖️ Physical Profiles: Younger athletes excel in Rhythmic Gymnastics, while Equestrianism favor more mature competitors.

  • 🌍 Diversity of Success: Smaller nations demonstrate that focused excellence can rival large delegations, creating inspiring underdog stories.

You Can Also Explore the Project via:

Contact / Feedback

I would love to hear your thoughts on this project. Reach out via email at:

Hena.yaqubi@outlook.com