Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA solution to last week’s challenge can be found here.
To solve this week’s challenge, use Designer Desktop.
This challenge comes to us from @Pawel_Paleczny Thank you for your contribution.
The FIFA World Cup is currently taking place in Qatar. Pavel would like to perform analyses on the event.
The first dataset contains information about the stadiums: stadium name, city, capacity, latitude, and longitude.
The second dataset contains information about the events: match number, round, dates, location, which teams are playing, and the group or phase.
For this challenge:
1. Assuming that each match will have a full audience, find the top 10 teams that could have the largest audience in the group stage.
2. Find the three cities with the most World Cup matches.
Fun quick challenge!
Just got back from the World Cup - what a tournament!