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.
Have you ever wondered if all the countries in the world celebrate the New Year? In many countries, New Year's Eve is celebrated at evening parties, where many people dance, eat, drink, and watch or light fireworks. Some countries celebrate New Year on a different day/month, and some don't celebrate the holiday.
The following dataset provides information about holidays around the world.
Based on the information provided:
- Which countries have 2 days of holiday for New Year?
- What are the countries that don't have New Year's Day as a Holiday?
Source: https://www.kaggle.com/arthurio/world-holidays-2019
... 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 can be found here.
The Eurovision Song contest or Eurovision is an annual song competition in Europe.
During a live show, contestants representing European countries, sing a song and receive points. The contestant with the most points wins. In 1974, the Swedish group ABBA became a household name in Europe by winning this contest with the song "Waterloo".
The dataset for this challenge provides information about the Eurovision from 1975 to 2019. The column “Edition” contains a date followed by one or two initials “f” or “fs”. For this challenge, use the values followed by “f”.
Use the dataset to: - Find out which country has won the contest from 1975 to 2019 - List by descending order the countries who have won the most time between these dates
Hint A country cannot give points to its representative. Make sure to take this rule into consideration. Mistakes happen in datasets.
... 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
A solution to last week’s challenge can be found here.
This challenge comes to us from @The_Rad_Valentina Thank you for your contribution, Valentina!
Ever wondered how the prices of various products are determined in your thrift store? Well, it all depends on their condition and other factors. Thankfully, your local store has a database that handles this, but there is a slight hiccup—the database contains a single column (Payload) with all this data. To address this, you have been tasked with creating a report that showcases the following details:
Different condition types of the products
Record number associated with each condition
Material numbers corresponding to the products
Pricing rate for different condition types
Dates when these pricing rates were valid (valid from and valid to)
The challenge lies in parsing the information from the Payload column to create a comprehensive report listing each price on a separate line.
Hint: Some Price records have more than one condition type. For example:
This is an example of the report:
... View more