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.
At any given time, there are a number of volcanoes erupting somewhere on the Earth. Many of these eruptions are in remote locations but some are located near more heavily populated areas. Keeping track of the eruption history and status allows for better emergency preparedness.
You have two datasets available:
1. The Holocene Volcanoes dataset contains a list of all volcanoes that have erupted within the past 10,000 years. 2. The 2023 Eruptions dataset contains data on eruptions that either commenced or are ongoing in the year 2023.
To solve this challenge, you need to accomplish two specific tasks:
Task 1: Create a combined table to flag volcanoes that are currently erupting and those with a Volcanic Explosivity Index (VEI) of 3 or higher (>=3). Additionally, identify eruptions in 2023 that have lasted for more than 10 years.
Task 2: Create points and use the Report Map tool to create a visually informative map that displays all volcanoes, both currently erupting and those that have ceased activity, with the following legend:
- Orange triangles: Volcanoes currently erupting (continuing) - Green circles: Eruptions that have stopped. - Red flag: Volcanoes with a Volcanic Explosivity Index (VEI) of 3 or higher.
Sources : https://volcano.si.edu/
https://volcano.si.edu/database/list_volcano_holocene_excel.cfm
https://volcano.si.edu/faq/index.cfm?question=eruptionsbyyear&checkyear=2023
... View more
A solution to last week's challenge can be found here. Source: https://nymag.com/strategist/article/best-mothers-day-flowers.html
This week's challenge was submitted by @sara_burk - Thanks for your submission!
Flora is the owner of Flora's Flower Décor and More. Each year, she systematically plans out her delivery schedule for Mother's Day deliveries and what the most efficient delivery route will be. Considerations: 1) Flora always creates her delivery schedule on the day before Mother's Day. This year Mother's Day falls on May 9th. Any order placed on or after May 8th will be available for in-store pick up only. 2) In order to qualify for delivery, the order cost must reach $50. 3) Flora only has time to deliver flowers to the closest 30 customers to the floral shop. The rest of the customers will have to pick up their flowers from the store. Flora will start at the flower shop, and consecutively go to the next closest location (based on distance, Miles). Create a macro that will help Flora optimize her route and then map the outcome. How many miles will Flora drive?
... View more
A solution to last week's challenge can be found here.
This challenge comes to us from @randall_king. Thank you for your contribution, Randy!
Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.
Your Human Resources department received a CSV file with the names of all new employees hired for all stores in the last month. They want to create these new employees’ email addresses. The company uses the initials from an employee’s first name and last name to create these emails. For example, Ana Muniz would be assigned AM@organizationname.com. If more than one person shares the same initials, add a number after the second initial. For example, Alan Murphy would be assigned AM1@organizationname.com.
For this challenge, you can provide an intermediate or advanced solution.
For the intermediate solution, use the CSV file to generate the emails using the fixed company domain, organizationname.com. Your output file should contain the following columns:
First Name
Last Name
Email Address
For the advanced solution, create an app where users can input a specific domain name through an interface similar to the one in the following image , and provide the same output as the intermediate solution.
... 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
A solution to last week’s challenge can be found here.
Now that you have created a map of the marathon route in Part 1 of challenge #341, add details to your map: - Create a start point in green. - Designate the route in red. - Create a legend in the lower-left corner for the start point and the route.
Use an 11 x 6-inch card size.
Add the following numerical information in the upper-right corner: - Marathon distance - Route time - Average speed
Hint: Respect the formatting of the caption objects.
Check out our newly rebranded course, Spatial Analytics.
... View more