WC 2002 dataset https://drive.google.com/file/d/1W60MXd03tA24nb8hdHKWcx4UfB3DlNwe/view?usp=sharing
WC 2006 dataset https://drive.google.com/file/d/1K9OoKZ6nx6pyCznd8loAk_wFOq3-HEiQ/view?usp=sharing
WC 2010 dataset https://drive.google.com/file/d/1CyhuUOO2Or0t9oE_Rg1UAGtodbGYCXiJ/view?usp=sharing
WC 2014 dataset https://drive.google.com/file/d/12p37Jq4jzH-hu27dESkbTOiBCMrhknrR/view?usp=sharing
WC 2018 dataset https://drive.google.com/file/d/18FATfFM6xyFl2tRqGXZYZ_W2iRQSCFDu/view?usp=sharing
Downloading the dataset from the dataset online. CSV file and export it into the PowerBI. Tranferring the file into the Power Query Editor for transformation and verifying the data types and columns. Adjusting the columns and data data types where necessary. Appemding all the similar tables together inorder to have a complete table of the world cup dataset from 2002-2018. After transformation, I closed and applied and created a rolling calender using DAX function from the data view.
I navigated to the model view and crested relationships with the data linking the facts tables to the dimension table.
Having modelled the data, I created measures with DAX and created my Dashboard. Joining several tiles together, measures and using slicers to navigate and filter through the dashboard.
The FIFA World Cup, often simply called the World Cup, is an international association football competition contested by the senior men's national teams of the members of the Fédération Internationale de Football Association (FIFA), the sport's global governing body. The championship has been awarded every four years since the inaugural tournament in 1930, except in 1942 and 1946 when it was not held because of the Second World War. The current champion is France, which won its second title at the 2018 tournament in Russia.
The 21 World Cup tournaments have been won by eight national teams. Brazil have won five times, and they are the only team to have played in every tournament. The other World Cup winners are Germany and Italy, with four titles each; Argentina, France, and inaugural winner Uruguay, with two titles each; and England and Spain, with one title each. You have been employed as a Data Analyst Super Sport Gaming Coy. You were asked to perform a detailed five years analysis on FIFA world cup.
This project involves generating insight from 5 years dataset of the FIFA world cup tournament participated by 59 countries from different continents of the world. The following questions was asked to generate clear insight;
- How many countries have played in the world cup (5 Years)?
- Get the total games played; win, loss, Goals for/against.
- The country with the highest and lowest appearance in the last five years?
- The country with the highest and lowest games played.
- The country with the highest and lowest games won.
- The country with the highest and lowest games lost.
- The country with the highest and lowest goals for?
- The country with the highest and lowest goals against?
- The country with the highest and lowest goals difference?
- The country with the highest and lowest points?
In the given dataset, 59 countries played the FIFA world cup. 640 games were played, win and loss games were 247 games respectively and total goals were 793. The countries with the highest and lowest games played were; Germany played 13 games while Angola and 13 other countries played total games of 3 each. The countries with the highest and lowest games won were Germany and Angola with total games won in 5years as 22 and 0 respectively. The countries with the highest and lowest games lost were South Korea and Angola, 9 and 1 respectively. The countries with the highest and lowest number of goals were Germany with 64 goals and Angola with 1 goal. Brazil has the highest number of goals against with a total number of 27 and Angola has the lowest goals-against against 2. Germany has the highest points of 69 while China PR has the lowest point of 0.
The total goal scored in the 5 years FIFA world cup dataset was 793 goals, of which; the highest and lowest goals was scored in 2014 and 2010 total goals of 171 and 145 respectively. However, in 2018, 2002, and 2006 goals scored were 169, 161, and 147 respectively.
France got the most points in 2018 with a total of 19 points, most goals were scored in the same year with 14 goals, 6 games were won and 1 draw out of the 7 games played. In the last 5 years, France had downward and upward trends between 2002 and 2018. The downward trend in 2002 and 2010, out of the 3 games played in 2002, loss 2 and draw 1 while in 2010, they played 3 games loss 2 and draw 1. In other words, they did not win any game in 2002 and 2010.
The upward trend was in 2006, 2014, and 2018. In 2014, they played 5 games, won 3, lost 1, and also had a draw. While in 2006 and 2018 they played in 7 games, won 4 and 3 draws in 2006, and also won 6 games and a draw in 2018.
Nigeria’s performance in the last 5 years; in 2002 and 2010 they played 3 games, won none of the matches, lost 2, and also had a draw. In 2014, they played 4 games, won 1, lost 2, and also had a draw. In 2018, they played 3 games. Won none, loss 2 and 2 draw. In 2006, Nigeria did not participate in the FIFA world cup.
Between 2002 and 2018 Brazil won the cup in 2002; they won all the 7 games played with a total of 21 points, a total of 18 goals. However, the 5 teams that lost most were; China PR, Croatia, Ecuador, and France. In 2006 Germany won the FIFA world cup, they won 5 games out of the 7 games played, lost 1 and also had a draw. They scored 14 goals with a total of 16 points. However, the 3 teams that lost most that are; underperformed teams were Costa Rica, Serbia & Montenegro, and Togo. In 2010, Netherland won the FIFA world cup. In all the 7 games played, they won 6 and lost 1 game with a total of 18 points. They scored 12 goals. Algeria, North Korea, and Cameroon had the most loss matches. In 2010, Netherland won the FIFA world cup. In all the 7 games played, they won 6 and lost 1 game with a total of 18 points. They scored 12 goals. Algeria, North Korea, and Cameroon had the most loss matches. In 2014, Germany won the FIFA world cup for the second time after 2006. Out of the 7 games played, they won 6 and also had a draw with a total of 19 points. They scored 18 goals, higher than the total number of goals scored in 2006. Australia, Cameroon, and Honduras had the most loss matches. Finally, in 2018 France won the FIFA world cup. Out of the 7 games played, they won 6 games and lost 1 of the game with a total of 19 points and 16 goals scored. Egypt, England, and Panama had the most loss matches.
Go to the Go To File to see the finish file while downloading the data in the link in the data sourcing is the raw file Displays the finish dashboard in pdf format and phix