Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
A solution to last week's challenge can be found here.
Have you ever reviewed a test and marked the wrong answer, only to realize that you overlooked the correct answer when evaluating your options? Humans are fairly unreliable when reading in data, especially when it isn't in a friendly format. Computers on the other hand...
For this week's challenge, create a workflow that identifies and highlights the largest value from a table of values. It should highlight only one value.
... View more
A solution to last week’s challenge can be found here.
This Halloween challenge was kindly contributed by Kenda Sanderson (@Kenda). We extend our gratitude to Kenda for her significant contributions to our Community!
Are you of the opinion that modern scary movies are better than their predecessors, or are you a devoted fan of classic directors like Polanski and Hitchcock?
In this challenge, you will immerse yourself in the realm of horror films to discover whether their ratings and earnings have improved over the years or if the classics remain unbeatable. The provided IMDb (Internet Movie Database) dataset encompasses a compilation of horror movies released over the last 100 years.
For this challenge, you should focus exclusively on horror genre movies, and exclude any films that are also considered comedies.
Your tasks:
Calculate a weighted movie rating for each decade, with the number of votes serving as the weight. All movies possess a rating, so they can all be included in this task, even if their revenue data is unavailable.
Calculate the average earnings for each decade, considering only movies with reported revenue values.
Create a line graph to visualize the changes in ratings and revenue over time.
Helpful hint:
When you calculate the weighted movie rating, you can think of it like a SUMPRODUCT function in Excel.
Source: https://www.kaggle.com/datasets/shreyanshverma27/imdb-horror-chilling-movie-dataset
... 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
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
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