Athlete Distributions

Inspiration

The COVID-19 pandemic has led many people to distance themselves from populated places, such as airports. Which countries' Olympic athletes would risk themselves for a chance to compete in the Beijing 2022 Olympic Winter Games? Is there any correlation with gender and type of sport?

What it does

The Power BI projects show the distributions of countries from which all 2022 Beijing Olympic athletes are from on a map. It can also show these distributions based on specific genders and sports.

How we built it

The athletes.csv dataset was scrubbed using a Python notebook in Google Collab to be prepped for visualization. Power BI was used to visualize the athletes.csv and medals_total.csv datasets with maps and graphs.

Challenges we ran into

It took time to realize the precise issues with the invalid and missing data. It turned out that there were entire rows that were formatted incorrectly. However, I managed to replace the incorrect data based on other, limited data about each individual athlete through Python.

Accomplishments that we're proud of

This is my first time applying my skills completely from scratch outside of my academics.

What we learned

Through this project, I've learned about using GitHub, Google Collab, Power BI, and Kaggle datasets. I've also learned some new techniques in Python.

What's next for Athlete Distributions

The final product would include the distributions of previous Olympic games so that we may observe changes over time.

Built With

• googlecollab
• jupyter
• kaggle
• powerbi
• python