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 for last week's challenge has been posted here in both video and workflow forms!
This week's Challenge lets you get crafty! Create an app to allow a user to search a list of craft canned beers by state of origin or beer style. Configure the app's interface to utilize radio buttons to expose the selection elements for each selection option: a Text Box for searching by state, and a Drop-Down for beer styles. Feel free to customize the app as you see fit!
... View more
The link to last week’s challenge (challenge #26) is HERE
This week’s challenge is a spatial use case to preprocess a spatial object for mapping. The input file is a single complex polygon that represents a coverage area.
Use Case: A wireless telecommunications company wants to remove holes and splatter from their coverage area for simplified map display. Splatter can be define as unnecessary pieces of the whole polygon.
Objective: Remove all splatter less than 2 square miles and holes from the coverage area.
This exercise can generate varying answers based on the configuration of the spatial tools used for the process. As a result the challenge does not contain an output.
Have fun!
... View more
Happy Monday! Last week's solution can be found HERE!
In this week's challenge, a communications company is doing an analysis of fiber runs in the network. The current wiring needs to be extended a certain distance in each direction in a straight line. Take the provided lines and extend them 5 miles on each end. For more intermediate users, create a macro so the user can input the desired extension length for each run.
The output should include: 1. Name of the fiber 2. The original spatial line object 3. The new spatial line object 4. New length of line
... View more
Here is this week’s challenge, I would like to thank everyone for playing along and for your feedback. The link to the solution for last challenge #10 is HERE.
The use case:
A manufacturing company receives customer complaint data on a daily basis from their call centers about the medical parts they distribute to their customers. The company monitors these comments to understand which parts and part groups have the highest complaint rate. This helps the company prioritize which parts to focus on from a development standpoint.
In this exercise, take the customer complaint data and identify which bucket the complaint falls within. The complaint can fall into multiple buckets and needs to be flagged as these complaints take highest priority. Create an aggregate view of which buckets or bucket pairings have the highest # of complaints.
This is only a subset of data so all records will not be assigned to buckets and can be ignored.
Update: As of 9/26/19, this challenge start file and solution were modified. Your solution will not match those posted by other Community members prior to this date.
... View more
Here is this week’s challenge, I would like to thank everyone for playing along and for your feedback. The link to the solution for last challenge #09 is HERE. For this challenge let’s look at the date and time functions in Alteryx.
The use case: A distribution center receives a package. At the point of receipt, the package is scanned and a timestamp is captured for arrival date/time. The company is trying to reduce the amount of time the package is at its facility and as a result is trying to analyze how long packages remain at the facility.
The objective for this challenge is to calculate the delta between arrival date/time and the Time_Now field (this field has the date/time of the creation of this challenge and will be changing as time goes on). Create a unique field for Days, Hours, Minutes and Seconds.
We have listed this as an intermediate exercise and I expect it will go very quickly for many of you. Let us know what you think, we are looking forward to hearing your feedback.
UPDATE 2/1/2016
You can find the solution below.
... View more