Alter Your Analysis: Women’s World Cup Match Wins

Data

Alter Your Analysis: Women’s World Cup Match Wins

In this series, Liz Jensen tackles specific cases from the Alteryx Weekly Challenge initiative. She wades through the countless tools and options available in Alteryx and shares her problem-solving process along the way.

In this second installment of Alter Your Analysis, I am tackling Alteryx’s Weekly Challenge 169: “Using the values in the attached file womens_world_cup_data.txt, determine which team won the most matches.”

A key point: We’re trying to determine the most matches won, not the most finals (go Team USA!).

Breaking the Challenge into Tools

Looking at the text file that contained our data, I had a little legwork to do in order to determine who our winningest team was. As I mentioned in my last blog post, I like to approach each workflow in Alteryx by breaking it down into smaller steps. These smaller steps will determine which tools I use. Here’s what I needed to do to get my answer, and the tools I used to get there:

  1. Connect to the data (of course!). I used an INPUT tool here.
  2. I wanted to FILTER out any ties. We just cared about wins, so I kept only matches where Team I’s scores were NOT the same as Team J. Using just the False output, I was able to look at matches where there were Winners and Losers.
  3. Then I used a FORMULA tool to determine who my winning Team was—if Score I was greater than Score J, then return Team I. Otherwise, return Team J. This would be my winning team.
  4. After I had the winning team for each match, I needed to use a SUMMARIZE tool to count how many times a team won a match. This is where it got interesting. I not only had to count how many times a team won (Count the Winning Team), but I also had to group by the winning team. Essentially, I am using the Winning Team twice in this SUMMARIZE Otherwise, it will just output how many winning teams I had.
  5. Next, I used a SORT tool to put our higher counts up top.
  6. Finally, I used a SAMPLE tool to just return the top most-winning team. Looks like it’s England with 16 matches!

You can check out my workflow below:

While there is no prize for the shortest or prettiest workflow, as my Alteryx trainer Steph Kennedy pointed out, I am quite pleased that I was able to accomplish this challenge with only six tools. While not necessarily faster, more complicated workflows can be tedious to troubleshoot.

Thanks for reading, and congratulations to everyone in the Women’s World Cup but especially the USA, 2019 World Champions!

More About the Author

Liz Jensen

Analytics Consultant
Alter Your Analysis: Women’s World Cup Match Wins In this second installment of Alter Your Analysis, I am tackling Alteryx’s Weekly Challenge 169: “Using the values in the attached file ...
Alter Your Analysis: Highest Average Retail Rating While attending my first Alteryx training with InterWorks’ own Steph Kennedy, she said something that still sticks in my brain each ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072