Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #376: Unlock Insights from FIFA Women’s World Cup Data!

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here.

 

Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.

 

Social tile_Fanalytics-soccer-Megan Rapinoe-on demand_1200x1200-1.jpg

Are you ready to showcase your analytical skills and uncover valuable insights from the exciting world of international women’s football (or soccer as it is called in the United States)? This Weekly Challenge will put your data manipulation and analysis prowess to the test. 

 

We will be using data gathered from over 4,000 women’s football match results from around the world.

 

Your challenge is to create a league table, for only the FIFA World Cup tournaments, that pulls together a number of statistics for each team: Games Played (GP), Wins, Draws, Losses, Goals For (GF), Goals Against (GA), Win %, and Average Goals scored per game. From this table, you will be able to answer three intriguing questions:

 

  1. Which team has the best winning percentage at World Cup tournaments?

  2. Which team scores the most goals on average?

  3. Which team has the worst defense; that is, the most goals conceded?

Using the shootouts.csv dataset, we would also like you to answer this question on penalty shootouts:

 

  1. Which team has the best penalty shootout performance?

 

 

Source: Kaggle Women's International Football Results

LynnPätzold
8 - Asteroid

Happy to see some women's representation in the challenges :)

Spoiler
Unbenannt.PNG

benjimoser
9 - Comet

My Solution

Spoiler
benjimoser_0-1687184260918.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
one number was rounded just slightly differently 
Kenda_0-1687184249603.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached,

Spoiler
PhilipMannering_1-1687184612880.png

 

 

ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1687185216035.png

 


 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1687185015656.png

 

nSpire
9 - Comet
Spoiler
nSpire_0-1687185932574.png

 

ejhaley
8 - Asteroid
8 - Asteroid

Love a good sports use-case!

Spoiler
ejhaley_1-1687186122134.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1687186353326.png