A brief History of the World Cup Data: 1930-2018
A brief History of the World Cup Data: 1930-2018
This project is based on a code along project from DataCamp (With a few minor tweaks). The metrics in focus provide very basic insight into Tournament data for the Men's World Cup's overtime.
- This repository is based on the Code along by DataCamp on Exploring World Cup Data in Power BI.
Why undertake a code long? For me, this was an opportunity to really put my skills and knowledge to the test, with the limited time alloted to undertaking the code along. It is easy to take comfort in the theoretical work learnt thus far, the reality is that, the work place or work demands require adaptability. The tweak in the usage of the animated bar chart as opposed to a map, I hope showcases this.
The Data
A subset of the data from the Fjelstul World Cup Database. A comprehensive database about world cup tournaments (1930-2018).
- The database contains 27 datasets, but for the analysis only five will be used. i.e.
- Goals
- Matches
- Team appearances
- Teams
- tournaments
A brief History of the World Cup Data: 1930-2018 Overview
Tournament Analysis
Key questions
- Which country scored the most goals?
- Which country reached the most finals
- Which year did the teams score the most goals?
- Is there an advantage to the host country?
To address the question - Which country scored the most goals?
- Select the By Tournament page
- On the top right hand pf the mreport page, select the year of intereset from the Tournament name slicer.
- The clustered bar chart displays the top 10 nations and their respective goal tallies for that world cup year.
- The animated bar chart race, visually displays goal occurence as the tournament progresses as well as final tally of most goals scored for that particular world cup year.
To address the question - Which country reached the most finals?
- Select the Overview page.
- The 13 top teams to grace the finals are displayed. Most appeareances - the combined Germany team(8), least appearances - England,(1), Spain(1), Hungary(1), Sweden(1), Uruguay(1).
To address the question - Which year did the teams score the most goals?
- The 1998 World cup had a total of 171 goals scored.
To address the question - Is there an advantage to the host country?
- A host country has won the World Cup 28.57% of the time. Not an advantage it seems.