The FIFA World Cup is an international soccer tournament held every four years. It features teams from around the world, who compete for the title of world champion. The World Cup has a rich history, dating back to the inaugural tournament in 1930. Over the years, the tournament has seen many memorable moments and legendary players.

So today I will be conducting an analysis of the FIFA World Cup from 1930 to 2022.

This Dataset was gotten from Kaggle.

This dataset came in four different files i.e. four different tables and as you can see from the pictures below it shows the four tables....
*fifa_world_cup_attendance
*fifa_world_cup_award
*fifa_world_cup_finals
*top_four_world_cup_teams

Now lets look at the dataset from each table:
a) The first pics shows the dataset for the fifa_world_cup_attendance
b) The second pics shows the dataset for the fifa_world_cup_award
c) The third pics shows the dataset for the fifa_world_cup_finals
d) The fourth pics shows the dataset for the top_four_world_cup_teams

Working on the tables separately can be stressful and time consuming, so I joined the first three table (since those are the tables I will be working with) using the INNER JOIN function. I also created a virtual table using "view" to help simplify the my analysis.
Please note: the table is way wider than this. You can't see it but all three tables were successfully joined. Trust me
This is what I got from joining all three tables.

Now let the analysis begin

I can't say for other data analyst but I love to analyze my data from field to field i.e. analyzing each column from the beginning to the end.

So, Here we go...…

a) The first pics shows the country that have hosted the world cup more than once.
b) The second pics shows the countries from pics (a) and the years they hosted the world cup.

I am not done yet, just getting started.....

Lets look at the golden ball winners.....

a) The first pics shows the number of players that have won the golden ball more than once. And as you can see only one player has done that.. the GOAT himself Lionel Messi.
Note: the "not awarded" which appeared 11 times means that no golden ball was awarded in the first 11 world cup tournament (1930 - 1978).

b) The second pics shows the full list of players that have won the golden ball since the award began. (1982 - 2022)

Now Lets look at the golden boot and the golden glove winners

a) The first pics shows the list of all golden boot winners and also number of goals scored by each player. I ordered the goals in a descending order i.e. from largest to smallest. And as you can see from the result "Just Fontaine" is the player with the highest number of goals in a single world cup tournament.

b) The second pics shows the list of golden glove winners and the number of clean sheet kept by this goal keepers. Looking at the query you would notice the "where golden_glove <> not awarded" this means that from 1930 - 1994 there was no golden glove award. The only started giving the golden glove award from 1998.

I am almost done

Now Lets look at the total attendance from each world cup and also the game or games with the highest number of attendance.

a) The first pics shows the total number of attendance from each world cup tournament. Not a single attendance from a game but total attendance from all games played in the tournament.

b) The second pics shows the list of game(s) with the highest attendance.

One More....

Lets look at the champions and also the runners-up of all world cup tournament.

a) The first pics shows the countries and the number of times the have won the the world cup. And you can see Brazil still holds that position as the country with the highest number of world cup.

b) The second pics shows the countries and the number of times they have been runners-up. And you can see countries like Argentina, Germany and the Netherlands have lost the final 3 times.

AND FINALLLY...…..

The Fourth(4) Table.

Like I said earlier I joined 3 tables instead of the 4 listed above.

WHY? coz this table really didn't fit for my analysis. It is an independent dataset . Joining it with the others will modify my analysis and affect my insights from the dataset.

BUT.

This is what the table looks like. And as you can this table shows the teams and the number of times they have been in the top four (4) i.e. reaching the semi-finals. It shows the number of times a country has won the cup (first-place), runner-up(second-place), third place and the fourth place. The asterisk on the year means the country hosted the world cup that year.


And That is all I have for you today.

Thank you for you time.

More sample Data Analysis Projects coming soon...…

Peace.

Can we talk, bro?