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:
Which team has the best winning percentage at World Cup tournaments?
Which team scores the most goals on average?
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:
Which team has the best penalty shootout performance?