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...
The link to last week’s exercise (exercise #45) is HERE
I love to share real world use cases as exercises. This week’s exercise comes from a customer that had data coming from in a legacy system and needed to transform the date field for a new system. It is a straightforward exercise but shows how easily Alteryx can apply business logic to most any data transformation problem.
Use case: The Input contains dates formatted as year, month and day. In this case, the first character determines if the year should begin with 19 or 20. If the first character is 0 then the year starts with 19, and when the first character is 1 the year starts with 20. The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.
Objective: Please convert these strings into date formatted field.
... View more
The link to last week’s challenge (challenge #27) is HERE
Use Case: A company has to process financial data for their visualization tool. Today this is a manual process in Excel.
Objective: Build a process in Alteryx that automates the formatting of the daily data feed.
Note: This data comes in daily and is always in the exact same format.
... View more
A solution to last week’s challenge can be found here. Source: https://www.dailymail.co.uk/news/article-4965690/Humpback-whale-breaches-Sydney-Harbour-sunset.html
Every year whales around the world migrate from their feeding grounds to their breeding grounds. Some species travel an outstanding 12,000 miles round trip!
Use the data sets below to analyze migration movements for different whale species.
The file Whale_Migration_Data contains a list of whales whose migration patterns have been tracked from 2001-2003, and the total kilometers each whale swam on each day of their migration.
The file Whale_Pods contains a list of whale ids and pod ids, which indicates the pod each whale belongs to.
The file Whale_Species contains information about the whale species of each pod.
Find the total number of kilometers each pod swam for migration for each year, then find the average number of kilometers each whale in that pod swam (total kilometers / number of whales in the pod). Then, find the pod with the highest average kilometers swam per whale for each species for each year.
... View more
A solution to last week’s challenge can be found here.
Congratulations, class of 2026!
For many new college students, now is the time to pay tuition for college, and sometimes their college decision is based on financial data.
This dataset contains information about private and public colleges in the US, where these institutions often offer different tuition for
in-state and out-of-state students.
Using the provided data: - Create a list of 4-year colleges by state that includes the total payment (tuition plus room and board) in 2020 for private colleges and public colleges for in-state and out-of-state students. - Find the top 10 schools that give the most significant discounts for in-state students.
... View more
A solution to last week’s challenge can be found here.
Are you wondering which artists produced the top songs? Do you want some insights? This challenge is for you.
The following dataset contains information about the top 500 songs. Using the dataset, find the top 50 artists with the most albums and the highest average rating. Include the following columns in your list :
- Artist(s) - Number of albums (Descending) - Average rating based on all albums (Descending) - Album title(s) - Average number of reviews based on all albums (Descending) - Genre(s) - Year the first album was released - Year the last album was released
Note: If in your solution you have null records for the Release Year, do not include them.
This challenge was updated to propose 2 start files and 2 solutions.
... View more