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 solution to last week's Challenge can be found HERE!
It's that time of year again....the leaves are starting to change color, the smell of pumpkin spice is in the air, and the amount of daylight for @JoeM's post-work bike rides is getting smaller and smaller. Just how much daylight did we lose this month? Take this week's Challenge to find out! Using the Input data provided, calculate the amount of daylight for each day in September, as well as the day-to-day differences in daylight and the total difference from September 1 to September 30.
*If you'd like to use a dataset for your location, you can download data on sunrise/sunset times from this site: https://www.timeanddate.com/sun/usa/ for US-based users.
... View more
A solution to last week's challenge can be found here. Image Source: https://commons.wikimedia.org/wiki/Category:Paralympic_Games
Let’s dig into the data for the Summer Paralympic Games 2020!
This dataset includes a column “RecordID” that corresponds to the names of the athletes, a column for “NOC” for the countries and a “Discipline” column.
For this challenge, your job is to: - List the participating countries and how many athletes for each country - List of the 5 countries with the most athletes - List the first 5 countries (alphabetic order) with the least athletes (they are more than 5) - List all the countries and disciplines by alphabetic order and, add the athlete count and athlete ID
Have a good week!
... View more
A solution to last week’s challenge can be found here.
This challenge comes to us from @AkimasaKajitani . Thank you for your contribution, Aki!
Meteorite showers are a captivating natural phenomenon, though it can be challenging to see them depending on your location. Fortunately, residents and visitors in the Las Vegas area enjoy an advantageous position, being in proximity to expansive desert skies that offer excellent conditions for meteorite watching.
For this challenge, your mission is to plan a budget-friendly meteorite impact site tour near Las Vegas, ensuring enthusiasts visit locations where they have the best opportunity to witness this celestial spectacle.
Here are the tasks you must complete. Calculate all distances in kilometers.
Find a meteorite impact site that is closest to a hotel that costs less than $200 per night. Designate this location as the "First Stop."
Identify the nearest meteorite impact site in relation to the First Stop. Label this site as the "Second Stop" and determine the distance between the first and second stops.
Locate the nearest meteorite impact site in relation to the Second Stop. Name this site “Third Stop” and determine the distance between the second and third stops.
Calculate the total distance traveled from the hotel to the third stop.
Data Summary:
You have two datasets. The text dataset contains the latitude and longitude of some hotels in Las Vegas with their cost per night. The second dataset, meteorite-landings.csv, contains the latitude and longitude of over 45,000 meteorites that have struck our planet.
Source: https://www.kaggle.com/datasets/nasa/meteorite-landings
... View more
A solution to last week's challenge can be found here.
This dataset contains a list of holiday dates that are observed by each country from Feb. to Dec. 2020.
Your Challenge is to figure out for that period: - Which country has the most holidays and how many? - Some holidays are only observed by one country. Which country has the most unique days off and how many? - Which day is the most shared in the world as a holiday and which countries are sharing this holiday?
... 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