The Objective

To participate in this challenge, your task is to choose a country to root for in the 2022 FIFA World Cup (it doesn't have to be your own!) and use data visualization to tell a single-page story of their history with the World Cup, their road to Qatar, and their expectations for this year's tournament Link to the challenge

The Data

This dataset contains 6 tables in CSV format

The Analysis

The analysis wasn't important for this dashboard. But for a simple presentation, the given tables needed to be changed. So in Power Query there was some work to do, see picture

The Visuals

I've chosen only 3 visuals, with added storytelling. I tried to get focus on the text. So I hope the first things you see are the bold white text blocks, the photo and the map and after that the column chart needs to give some more information As you can see in the building image, there are a lot of small text boxes to the visuals. For instance the ones with the country codes like NLD. I've tried to keep them all of the same size with the same outline vs the columns

The Key Insights

In this dashboards, key insights were not my goal. I wanted to show the road as simple as possible, I hope it is easy enough to understand. But in the end it shows that we only lost the first match in the qualifying period

The Design

I tried to deliver an infographic but that isn't easy. I found this photo of Louis van Gaal that gave me a positive feeling, together with the quote and the map of the Netherlands I started to build this dashboard Orange had to be dominant and as you can see I wanted to split the page into several parts. I started with a kind of horizontal flag but that wasn't it. In the end I placed white lines around the different parts to get more rest

Comments

Link to LinkedIn post

As usual, a lot of entries don't meet the project brief. I always try to answer the challenge questions. In this case, the questions are:

• their history with the World Cup, -->bottum right (only Louis van Gaal)
• their road to Qatar, --> the column chart
• their expectations for this year's tournament --> the quote on top of the dashboard