alteryx Community

# 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.

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

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.

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?

8 - Asteroid

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

Spoiler

9 - Comet

My Solution

Spoiler

16 - Nebula
Spoiler
one number was rounded just slightly differently

16 - Nebula

Solution attached,

Spoiler

11 - Bolide
Spoiler

17 - Castor
Spoiler

9 - Comet
Spoiler

8 - Asteroid

Love a good sports use-case!

Spoiler

17 - Castor

My solution.

Spoiler