The aim is to organise membership roaster and generate comprehensive reports for the company, helping manage international sports events by accurately handling nominations from different departments and meeting business needs.
- Data Cleaning is done through standardizing the dataset and performing some data fromatting steps.
- Data Analysis involves summarizing the data using excel functions and pivot table.
- Generated Report using various pivot table and then created dashboard out of it.
What is the most played sports by people?
Among gender, who are contributing more in sports?
Which sports location type is most prefered by people?
Which sports is giving more salary?
Which country is contrbuting more in sports?
What is the gender-wise contribution in each country?
- Among all the games Beach Volleyball, Cycling Road, Canoe Slalom, Cycling Track and Triathlon are the most played games by sportsmans.
- when considering location type - people are mostly liking outdoor sports location to play.
- Out of 11 countries Australia, France and USA Sportsman are participating the most or we can say are more active in sports.
- when comparing gnder we can see that bot male and females are equally active in sports.
- Here in the graph we have the list of top 10 sports where people are getting more salary.
- while exploring country wise: gender chart, from the top 3 countries - In Australia , Females are more active, In France , Males are more active and In USA both males and female are equally active in playing sports.