FIFA 2022: Visualizing the Group Stage Data
Hi hivers
->>>CLICK HERE TO ACCESS THE DASHBOARD
After a much-needed hiatus, I'm back to blogging, and what better way to get started than with the big event everyone is talking about? You're right, of course! The FIFA World Cup 2022 hosted in Qatar. With the first kick of the quarterfinals scheduled to take place in less than 24 hours, the tournament has reached a stage where the stakes are high and it's win it all or nothing!
I have been working to improve my data analytics abilities over the course of a few months, one of which is data visualization using Microsoft Power BI. After the group stages were finished, all I wanted to do was analyze and visualize the data using Power BI. Let me quickly recap how I came to create this completely interactive dashboard.
.png)
->>>CLICK HERE TO ACCESS THE DASHBOARD
Starting off:
-Data Scraping: I had to web scrape the fifa 2022 website's data. I entered it via copy and paste into an Excel spreadsheet.
-Data Cleaning: I started by preparing the data for the matches, groups, and flags etc. I got rid of duplicates, blanks and null entries.
-Create the Tabs: The Fixtures tab allows you to view information about the dates, locations, and participants in various matches. While the Standings include information on the teams, including their number of wins, losses, draws, goals scored, and goals conceded. Here, you can compare these statistics to the total while still getting a sense of how each team contributed to each statistic individually.
Please disregard the blank in the group and flags area; I have attempted every means I am aware of to fix it, but it appears adamant, so I have left it alone because it does nothing to the project.
If Messi or Ronaldo wins the world cup, I'll go ahead and provide a more in-depth analysis on the tournament that will feature player statistics and teams, as well as the ongoing knockout games. And we get to fully explore the data to bring out incredible pieces of information about the competition.
I thus hope you have as much fun playing with the data as I did. Share your thoughts and comments in the section below! What are your predictions for the quarter-final fixtures? GO ahead and share and be on the look out for more blogs coming your way!
->>>CLICK HERE TO ACCESS THE DASHBOARD
Cheers!
Posted using SportsTalkSocial
All eyes on Argentina vs Netherlands tomorrow night, can't wait for the quarter finals matches to be played.
Only a few minutes away.. With Brazil out, I'm really hoping Argentina wins Netherlands
The quarter finals begins in less than 10 hours and it’s all eyes on Brazil and Argentina. I think Brazil will go through but I’m not quite sure about Argentina.
It’s going to be fun to look at the data you’ve provided.
Sorry, but CRO got the better of Brazil in the end.. Guess we keep our fingers crossed as regards ARG! And yeah, i'd be real motivated to explore the data if Messi or Ronaldo gets crowned World Champion
Yeah they did and I’m actually quiet surprised. I was convinced Brazil would qualify. I don’t even want to think if Argentina can make it. This World Cup is insanely good.
Yup buddy! Another upset yet again! Morroco making Africa proud! This tournament will go down in history as one of the greats! Drama choke!
Morocco really doing us proud. I don’t know but I this point you just feel when they score first it’s over for you.😅
I hope they make it to the finals.
This is so good to know! I'd love to check more posts of this. Thanks @mengene.
Thanks for checking it out.. I hope to get more posts out if possible!