Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #4: FIFA™ Women's World Cup Analysis

AYXAcademy
Alteryx
Alteryx

Hi Maveryx,

 

We are launching an updated process to submit Cloud Quest solutions!

 

Starting today and moving forward we will provide a JSON workflow start file for each quest. The workflow contains starting data preloaded into a Text Input tool (or tools).

 

Upload this JSON file into your Alteryx Analytics Cloud Library, then you can open the file and start solving the quest in Designer Cloud!

 

Similarly, once you are finished, you can export your JSON solution file to attach to your reply on Community.

  • Remember to attach your solution file to your reply on Community to get credit towards your Cloud Quest badge count. 
  • Please continue to upload a screenshot of your solution workflow so other Maveryx can check out your creativity!

 

Review the following instructions to learn how to import and export Alteryx Designer Cloud workflows.

 

Import the Cloud Quest Start File

  • Download the provided JSON start file and upload it into your Analytics Cloud library.
  • Open the workflow in Designer Cloud.
  • Start solving!

Get Started.png

Export Your Solution

  • Once you have completed your quest, go back to your Analytics Cloud library.
  • Download your workflow solution file.
  • Upload your JSON file as an attachment to your comment.

Upload your Solution.png

 

Now, with that out of the way...

 

Let’s dive into this week's quest!

 

You are a data analyst at a sports statistics firm. Your department is focused on analyzing historical data from major international sporting events, and your current project is the FIFA Women’s World Cup™.

 

You have been provided with a dataset named Womens World Cup dataset. This file contains detailed Women's World Cup match records, including teams, match outcomes, and dates from 2016 through 2019.

 

Your goal is to use Alteryx Designer Cloud to process this dataset and determine which team won the most matches in years 2016-2018. The outcome should consist of two columns: one for the team and the other for the number of wins.

 

Hint: Use the IF/THEN expression in the Formula tool to identify the winners. Also, ensure to exclude any matches where there was a tie.

 

Spoiler
A combination of the Sample, Filter, Summarize, and Formula tools should solve your problem, but not necessarily in this sequence.

If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:

 

 
Here’s to a successful quest!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

34 REPLIES 34
ScottMcV
Alteryx
Alteryx
Spoiler
Definitely like the JSON upload and download.

CloudQuest4.png
RobertW
Alteryx
Alteryx
Spoiler
 
Screenshot 2024-03-21 at 9.44.14 AM.png

OllieClarke
15 - Aurora
15 - Aurora

Noice

Spoiler
image.png
FlorianC
Alteryx
Alteryx

Instructions specified that the analysis should only consider games that occurred between August 2016 and November 2018.

 

Spoiler
Designer Cloud workflowDesigner Cloud workflow

 

 

Florian Carrier
Strategic Solution Consultant
Alteryx
Treyson
13 - Pulsar
13 - Pulsar

Honestly had no idea there was an import/export function available to us. I think the library tab needs to be explored further. Maybe a way to group my files I create? Similar to a folder structure maybe?

Treyson Marks
Managing Partner
DCG Analytics
MikeRoof
Alteryx
Alteryx

👋Here's a solution that uses a join, I wanted to make sure it still works if multiple teams have the same number of wins. (I should note I added an extra win for Germany to make sure this worked if two teams were tied for most wins)

Spoiler
Screen Shot 2024-03-25 at 11.24.57 AM.png

 

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

AkimasaKajitani
17 - Castor
17 - Castor

My solution!!

 

Spoiler
スクリーンショット 2024-03-28 213054.png

Actually, I was misunderstanding Cloud Quest week.

alexnajm
16 - Nebula
16 - Nebula

It keeps saying "Failed to download file" when I say to get the JSON to upload - has anyone experienced this? Works for all my other Designer Cloud flows 

Screenshot 2024-03-28 133448.png

 

Otherwise straightforward challenge - looks like one we've done before 😉

Spoiler
Quest #4 Screenshot.png 

 

Bren_Spill
11 - Bolide

Solution attached