Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with...
The Alteryx education program providing software licenses, teaching tools, and learning pathways to empower learners to question, understand and solve...
Need to level-up your knowledge but don’t have time for a long read? Tune in to our podcasts to cover analytics culture, data science, and everything in...
A solution to last week’s challenge can be found here.
Every 4th of July since 1972, the Nathan's Hot Dog Eating Contest has been held in Coney Island, a neighborhood of New York City. Nathan's promoters claim that on July 4, 1916, four immigrants held a hot dog eating contest at Nathan's Famous stand on Coney Island to settle an argument about who was the most patriotic.
After this weekly challenge, you might want to eat a hot dog or perhaps not, but either way, you will have fun finding out who eats the greatest number of hot dogs.
Using the dataset provided, answer the following questions:
1) Who was the winner among the male and female contestants for each year? 2) How many hot dogs did the winners eat? 3) What year had the least number of hot dogs eaten by a man and a woman?
Thank you for your comments. The start file has been updated.
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge was submitted by Patrick Digan (@patrick_digan) an Alteryx ACE and also an active Community member who has contributed to many challenges before. Thank you, Patrick!
This week’s challenge is inspired by a special day that just passed: Pi Day! Not the delicious treat, but the number with an infinite sequence of non-repeating decimals: 3.14, which is celebrated on March 14.
In honor of pi, this week your task is to find all 13 numbers less than or equal to 100,000 that are equal to the n th power of the sum of their digits. For example, 81 is a 2-digit number, so n=2, and (8+1) 2 = 81; therefore, it falls under the category we are looking for.
For the input, use the Generate Rows tool to generate numbers from 0 to 100,000.
Bonus question: If you want to take your skills to the next level, you are invited to find all 17 numbers that are equal to any n th power of the sum of its digits. For example, 4,913 works for this. While it will fail for the first task because (4 + 9 + 1 + 3) 4 = 83,521, the number 4,913 works well for the bonus question since (4 + 9 + 1 + 3) 3 = 4,913.
Need a refresher? Review these lessons in Academy to gear up:
Summarizing Data
Creating Regular Expressions
Good luck!
... View more
Last week's solution has been posted here.
This week's challenge explores the problem of Slowly Changing Dimensions, which some of you may be familiar with as you update existing or historical data with changes to those attributes. In this challenge, we'll be updating our log of Jedi rankings to reflect changes in Jedi levels, promotions, and retirements (yes, even the Jedi Knighthood has an HR department).
The challenge's Start file contains an input of the "Current Log", which includes data on an individual's level, when they started at that level, and when they completed that level. Records with an end date indicate either a promotion or a separation for that individual. The input "Today's Updates" includes the changes that take effect today: Bob has joined the Dark Side, Kaitlin and Richard have been promoted up the Jedi Ranks and Joe has joined the Jedi Knighthood. Your task: create a workflow that produces an updated list of the current Jedi ranks.
Use the Force...er...Alteryx!
... View more
Hi Maveryx!
The Academy Team is thrilled to announce the launch of an exciting new initiative: Alteryx Cloud Quests! We know how much our community loves Weekly Challenges, focused on solving real-world data problems in Alteryx Designer. This new program is designed to uplevel your workflow skills to the Alteryx Analytics Cloud, offering a unique opportunity to explore, learn, and innovate data analytics in the cloud.
What’s In It for You?
Starting February 7, 2024, we will publish a new Cloud Quest every 2 weeks on Wednesdays. Each quest is an opportunity to dive deep into the world of cloud-based analytics.
The initial quests will explore the vast potential of Designer Cloud, and as the program evolves, we will expand into other products such as Auto Insights, Location Intelligence, and Machine Learning.
Show off your skills by publishing your solutions on the quest thread. Let the world see your innovative solutions that highlight your expertise! As your solution will be designed in the Alteryx Analytics Cloud, instead of submitting workflow files as responses, capture your solution in a screenshot and share it in a comment on the designated thread.
Yes, There Will Be Badges!
We designed a new series of badges that you can earn by completing Cloud Quests. Journey from the clouds in the lowest level of the atmosphere to the outer reaches of the universe. You will earn your first badge after completing one quest!
Why Should You Solve the Cloud Quests?
By answering the quests, you will keep up with the latest features in cloud computing and analytics. You will also connect with fellow Alteryx users, exchange ideas, and grow together.
We can't wait to see how you tackle these quests and transform the way you think about cloud-based solutions. Get ready to embark on a journey of discovery and innovation with Alteryx Cloud Quests!
Bookmark this page, and get ready to start solving the first quests!
... View more
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