Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
For that last week of International Women's month, we will looking at data around women holding government positions. Remember - you this will be the last opportunity to enter into our contest to win the book: "Good Night Stories for Rebel Girls". Simply upload a solution to this challenge and have a chance to win!
This week's challenge has us asking: "What are the top 3 countries that had the greatest percent increase in women holding government seats between 1997-2017 for each income group?"
To get to the answer, here some rules on how the data should be treated:
1) We are only looking at data from 1997 to 2017 2) Remove countries not reporting data from 1997-2017 3) If a year is left blank, assume that the percent is the same as the year previous to it 4) The country must have a designated region and income group for analysis - if not, remove it 5) If a country had a drop in percent of seats held by women more than two times, remove it from the list of top performing countries. 6) Of the remaining countries, calculate the total percent change difference between 2017 and 1997 7) Rank the top 3 countries for largest percent change for each income group (expect 12 results)
... View more
Hi Maveryx team, Happy New Year!
A solution to last week’s challenge can be found here.
I hope you all had a wonderful holiday season. Are you ready to dive into a new year of weekly challenges? In December, we tackled some complex spatial problems, macros, and advanced tools. To start the year, we will go a little bit easier on you. Who is up for feeling like a lottery winner?
You have a dataset that provides details of the winners of a lottery from November 3, 1996, to October 27, 2018. In this lottery, players select 6 numbers, and the objective is to match all 6 numbers to win.
Your tasks:
During this period, how many times was there just one winner (matched 6 out of 6 numbers) who claimed the entire accumulated jackpot?
Identify the date and the highest jackpot amount ever won by a single winner who matched 6 out of 6 numbers.
Hint: The dataset is from a lottery in Brazil, and the numeric punctuation is different from what is used in the United States. Portuguese uses a period to separate thousands (for example, 2.367.900 = 2,367,900) and it uses a comma to mark the decimal place (for example, 1,5 = 1.5). Be sure to convert the winning amount for a US-based audience.
Good luck, Maveryx!
Source: Adapted and translated from https://www.kaggle.com/code/lidialucena/mega-sena.
... View more
Hi Maveryx,
We posted the solution JSON file to Cloud Quest #12. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
Let’s dive into this week's quest!
Download and extract the provided JSON file containing your starting data and workflow files.
Upload the provided Cloud Quest 13 - Start File.json file into your Analytics Cloud library.
All necessary datasets are contained within Text Input tools in the workflow.
For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.
Scenario:
You are a big fan of Formula 1, and you want to run some simple statistics.
Your input data contains information about teams and their drivers from 2019 to 2021. Using this dataset, answer the following questions:
What is the average age of all drivers in the field?
Calculate the number podiums each team accumulated in 2019, 2020, and 2021. Which team accumulated the most total podiums, and how many did they accumulate?
Which team had the biggest point differential between their best and worst drivers in 2021?
Which country produced the most drivers, and how many drivers are from that country? (According to their Place of Birth)
Hint: Did you know you can create new columns based on a summarize function within one Cross Tab tool?
A combination of the Summarize, Cross Tab, Sample, 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:
Getting Started with Designer Cloud
Building Connections in Designer Cloud
Building Your Workflow in Designer Cloud
Once you have completed your quest, go back to your Analytics Cloud library.
Download your workflow solution file.
Include your JSON file and a screenshot of your workflow as attachments to your comment.
Here’s to a successful quest!
... View more
The link to last week’s challenge (exercise #54) is HERE.
2013 Alteryx Grand Prix Lap 1 of 3:
As the Alteryx User groups start the process of selecting their competitors for the 2017 Alteryx Grand Prix I thought it would be fun to bring back an old Grand Prix as the weekly challenge. Note the workflow is in a vertical orientation. Vertical was the only orientation Alteryx had in 2013. Now, we can toggle between vertical and horizontal configurations by clicking on the white space of the canvas, going to the configuration window, and choosing a layout direction.
Want to have even more fun, go to the about box under the help menu and double click the little Colorado flag for an Easter egg that will render the tools the way they looked in 2013.
Have fun solving and remember the competitors were racing each other and the clock! See how fast you can solve this. OH, and there was NO Imputation tool in 2013...
... View more
So many different solutions to last week's Challenge have been posted here!
This week's Challenge riffs off a process typically used in spatial analysis with raster inputs: interpolation. In this Challenge, you are provided with two inputs: a polygon representing the island of Maui (hey, there's still snow in the forecast here in CO...can you blame me for picking a beachy location?) and a table of values representing the elevation measurements for 500 m x 500 m grid cells (much like a Digital Elevation Model). However, some grid cells contain a value of 0. We'll use some spatial tools to interpolate, or estimate, the values of the cells containing 0 from a "nearest neighborhood" or surrounding cell values.
First, build a 500 m x 500 m grid around the island of Maui. Then, interpolate the missing value using the average of the known measurements from the surrounding cells, or "neighborhood". Use a neighborhood of the 8 nearest surrounding cells in a unique cardinal direction (see example below; a neighborhood of a cell containing a 0 is outlined in blue. In this example, the new interpolated value of the center cell would be 61.5). Should a missing value be located on the edge, use only the nearest cells in a unique cardinal direction, even if 8 values are not used for the calculation.
Hint: Grid cell Grd37_68 is column 37, row 68. The Grid tool starts with column 0.
... View more