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...
Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge was submitted by @AkimasaKajitani . Thanks Aki for this great contribution!
You and your friends enjoy high-energy songs. Since your friends know you are skilled at using Alteryx, they have asked you to create a 60-minute playlist using the Optimization tool. This playlist should contain the most popular and energetic songs, each included only once.
Each record in the provided dataset contains the variable (song ID), song name, popularity, level of energy (ranging from 0 to 1, with 0 being less energetic and 1 being more energetic), and song duration. Additionally, you are given the formatted for the B anchor of the Optimization tool. This represents the maximum duration of 3600 seconds, or 60 minutes (rhs).
Your task is to create a maximum 60-minute playlist that maximizes song popularity from the top 100 high-energy songs. Each song should only be included once. Additionally, output the total popularity value of (Objective ).
Summary of Data:
You are provided with a file containing a song popularity dataset with energy values for each song and its duration. Additionally, you are given the formatted input for the B anchor or the Optimization tool.
Hints:
Ensure you select Maximize Objective in the Optimization tool settings and spend most of your time structuring the data for the Specify the Model as Matrices option. You will not need to change any other settings in the tool (other than Maximize Objective).
Field names matter! Check out this article, which features data format.
song_popularity = coefficient
lb and ub values are a binary datatype of 0,1
Need a refresher? Review these resources to gear up:
Tool Mastery | Optimization
Article: Beginners Guide To Alteryx Optimization
Help Documentation: Optimization Tool
Source: The dataset was modified to align with the learning objectives of the challenge. https://www.kaggle.com/datasets/maharshipandya/-spotify-tracks-dataset
Good luck!
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
Ellen Wiegand, a Senior Sales Engineer at Alteryx, brought us this brilliant challenge idea. We are truly grateful for your contribution, Ellen!
Considering the importance of renewable energy and to celebrate Earth Day, let's work on a challenge regarding sustainable energy! We have a dataset that provides detailed information about wind towers in the United States and its territories. The text input file contains the latitude and longitude coordinates for Alteryx headquarters in Irvine, California.
Looking only at wind towers with an Attribute Confidence of 3 and Projects with more than one wind tower, complete the following tasks. (Note: The Column Descriptors tool container in the workflow file contains the definitions of the values in the input dataset.)
What is the name of the project closest to the Irvine office (CA)?
How far away from the office is it?
Hint: The provided dataset is a flat file. To facilitate the data extraction, use the JSON Parse tool in the Developer tab of Designer.
Need a refresher? Review these lessons in Academy to gear up:
Parsing JSON
Creating Spatial Objects
Changing Data Layouts
Sources:
https://evwhs.digitalglobe.com
http://www.google.com/earth/download/ge/
http://datagateway.nrcs.usda.gov/
Good luck!
... View more
The solution to last week's challenge can be found HERE.
This week, let's take a break from all of those business uses cases and have some fun! In this challenge, create a field that indicates whether two values in each row are anagrams for each other. An anagram is a word formed by re-arranging the letters of another word. In our case, all anagrams are one word and are not split to multiple. No letter can be used more than once, and all letters must be used.
... View more
The solution to last week's challenge is HERE.
This week we will be offering our third ever challenge on converting strings to dates. Sometimes these may be simple, but every once in awhile, we come across those source systems that drop things in a format that are better understood by machine than by a human. In this week's challenge, convert the string to a date using the following rules:
1) The Input contains dates formatted as year, month, day where the first character details if the year begins with 19 or 20.
2) It is 19 when the first character is 0 and 20 when the character is 1.
3) The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.
Example: 1040202 should become 2004-02-02.
... View more
A solution to last week’s challenge can be found here.
How many pickups does Uber make in New York City?
This is what we are going to investigate in this challenge.
The dataset provides information about uber pickups in New York for the first 6 months of January 2015.
It gives you, among other things, the date of the pickup, the borough, and the number of pickups by borough.
For this challenge, determine the total number of pickups each day, by borough, for the month of January 2015.
To solve this week’s challenge, you can use Designer Cloud or Designer Desktop. Haven’t heard about Designer Cloud yet? Watch a demo.
Data Source: www.kaggle.com/datasets/yannisp/uber-pickups-enriched
... View more