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!
Using the data provided in the start file, create an ordered list of the provided unofficial holidays.
GIPHY
Get ready for Answer the Phone like Buddy the Elf Day on December 18!
... View more
A solution to last week's challenge can be found here!
Nothing makes you feel quite as nostalgic as hearing a song you haven't heard in a while. That's probably why Billboard magazine has been publishing their "Hot 100" list since 1958. If you aren't familiar, the "Hot 100" list ranks the top 100 singles in the US each year. It can be pretty fun to read through, but let's take a look at who dominated the decades.
This challenge's dataset includes rankings from 1965-2015. Determine which artist(s) created the most top 100 hits in each decade. Then, try the same but with top 10 rankings.
... View more
A solution to last week's challenge can be found here!
This week's challenge comes to us from @BuQu - thanks so much for the contribution!
Using the provided input, count the number of times each word appears in the text. Then, sort the words in descending order and show the percentage of that word's use against the total word count.
Hint: Make sure there are no truncated fields in your input.
Bonus: Use the download tool to get text directly from the website instead of using the text file.
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
In April, we celebrate Earth Month, a time dedicated to raising awareness and taking action for environmental conservation and sustainability.
This weekly challenge delves into temperatures, highlighting their crucial role in our planet's health. The dataset presents comprehensive information on global temperature records, covering various countries worldwide. It includes average temperature records in Celsius for major cities from 1743 to 2013.
To solve this challenge, we will be concentrating on the data from 1950 onwards.
Your tasks are as follows:
Determine which cities have average temperatures greater than or equal to 25 degrees.
Among the cities identified in the previous task, identify the country with the highest number of such cities.
Examining all countries within the dataset, pinpoint the year with the highest average temperature and the year with the lowest average temperature across the globe.
Need a refresher? Review these lessons in Academy to gear up:
Sorting Data
Separating Data into Columns and Rows
Summarizing Data
Source: https://www.kaggle.com/datasets/maso0dahmed/global-temperature-records-1850-2022
Good luck!
... View more
A solution to last week's challenge has been posted here!
This week's challenge was submitted by @pawel_zych - thank you for your contribution!
This is a Supply Chain Management challenge. Your task is to generate the Negotiation file for Category Managers that they can use while negotiating new prices with the Suppliers. Match each PN with prior Supplier Names and APV. Create one column that indicates a case where there was more than one Supplier in the historical data.
... View more