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.
For this challenge, you will be hosting the perfect Christmas night! You've invited friends over to eat cookies, listen to music, and watch a movie!
This is a two-part challenge: First you must choose each item (type of cookie, music and movie) based on a specific criterias that are in the container boxes below (you have opinionated friends), then you must use your 3 selections to find the key to the treasure box. The treasure box holds a special gift from your Weekly Challenge team!
(Hint: Label your final selection column as "Answer")
Cookie Criteria: Choose the cookie recipe that makes the most cookies!
1. You have 1000 grams of butter and 1000 g of sugar.
2. The cookies recipes require the ingredients as listed.
3. You are not limited by any of the other ingredients.
Music Criteria: Choose a Christmas playlist for your guests while you eat cookies!
1. Assume each song is 3 minutes and that your total music playtime will be 45 minutes - this determines how many songs you have on the list!
2. Every song must be a -9 or lower in loudness (ex. -15 would be a very quiet song)
3. Eric wants all the minor songs and Matthew wants songs in F major.
4.Thalita loves Dean Martin!
5. Put the songs in order of loudness, so the music builds as a transition to the movie.
The title of the last song is your "answer"!
Movie Criteria: Choose a crowd-pleaser movie
1. You only want a movie that was released in the theater
2. Nicole doesn't want to watch an animated movie.
3. Ryan is feeling nostalgic and wants to watch something from the 80's or 90's.
4. It must be the top rated movie of the year it debuted.
5. The movie with the longest run time in the Comedy genre is your "answer"!
After all that hard work to create the Best Christmas Evening Ever, use your three answers to find the key to the treasure box!
1. Use the provided lookup table to "find and replace" your answers to produce three sets of scrambled letters and numbers (hint: label column as "Answer").
2. Concatenate the key and add to the provided formula tool.
3. Once you run the key through the formula tool, you may open the treasure box and put the link in the tool configuration!
Resources:
Christmas music: https://data.world/promptcloud/spotify-musical-features-of-160-holiday-songs
Top Movies: https://www.spreadsheetshoppe.com/25-best-christmas-movies/ and IMBD
... View more
A solution to last week's challenge can be found here. Source: https://en.wikipedia.org/wiki/Belmont_Stakes
This week's challenge was submitted by @mst3k - Thank you for your submission!
Later this week, the Belmont Stakes will be held in New York. If you are unfamiliar, this is a famous horse race which serves as the third race in the Triple Crown (the Kentucky Derby and Preakness are the other two legs). While there will not be a triple crown winner this year (since different horses won the previous two legs), we can still have some fun analyzing some race possibilities!
A race is being held between 4 horses. Create an output of every possible combination of race finishes. No horse should be able to finish in more than 1 place, but be warned there are two *different* mustangs named Sally in this race! Extra Credit: If there are 5 horses instead of 4, how many possible outcomes are there? Can that number be generalized if there are n number of horses?
... View more
A solution to last week's challenge can be found here.
If you're familiar with the Formula tool in Designer, you know that there aren't many things you can't do with it. But just because you can do something doesn't mean that you should. There are some tasks that can get a little repetitive when you have to do them over and over again. In those instances it can be more efficient to think about ways to make the process a little more dynamic. This also serves you well as you begin automating processes because it can keep workflows from breaking when datasets change.
For this week's challenge, we want to perform a simple calculation: divide each month's Tax value by its Cost value to find the Percentage. Since there are almost always multiple ways to accomplish the same task, go for a double dip and find two solutions to arrive at the final output.
... View more
We hope you enjoyed last week's challenge. For the fifth challenge let’s look at building an analytic application.
An HR department has a defined hierarchy for job identification across the organization. Depending on the job, the position within the hierarchy can change.
The goal is to create an analytical application that allows a HR rep to enter a position # (in this example, 33333) and return all records where the position is found within the hierarchy system.
We have listed this as an intermediate challenge since parameterizing a workflow and converting it to an application is slightly more advanced however the workflow to answer the question should be beginner level. As always, we love to hear your comments. We hope you are having fun with the challenges!
UPDATE 12/14/2015: The Solution has been uploaded.
... View more
A solution to last week's challenge can be found here.
This week's challenge was submitted by @Maskell_Rascal & @mceleavey - Thanks for your submission!
For this week's challenge, we have provided a list of transactions including the [Client_Number], [Date], & [Finance Amount]. Since not every customer makes a purchase everyday, they only appear on dates that they have made a purchase. We would like to include current customers in the dataset with a "finance amount" of 0 for the missing dates after their first purchase. They should not have entries for dates prior to their first purchase. Assume first purchase dates are the earliest entry in the dataset.
... View more