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 group of friends are playing their favorite game. Not being a bunch of data analysts and understanding the importance of inputting data in an easy to work with way, they devised an incredibly inefficient way to keep score of their game! In the game, there is 5 rounds of play and 5 players (a,b,c,d,e - first letter of their names). For each lowercase letter under their initial, 1 point is awarded. For each uppercase letter, 1 point is subtracted from their overall score. As the only right and fair arbiter, they call you in to use Alteryx to figure out each players score for each round and their respective totals. Who won?
... View more
A solution to last week's challenge can be found here.
This week's challenge focuses on a group of relatives and their birthdays. Of the six family members, we have one person's date of birth and a series of clues to calculate the others. Provide the DOB for all family members and the day of the week s/he was born.
... View more
A solution to last week's Challenge has been posted HERE!
This year's (2017-2018) flu season has been reported to be the most severe in the past decade. In particular, influenza-related hospitalizations are on the rise across a wider range of age groups than normal. For this week's Challenge, we'll use data from the Center for Disease Control (CDC) concerning California's data on influenza-related hospitalizations. Create a table that shows the cumulative number of hospitalizations per age group for each flu season.
Looking for additional analyses to do? How about a week-by-week comparison of hospitalizations? Or perhaps a forecast of the number of expected hospitalizations for a particular age group? Or maybe a visual representation of the data is up your alley!
Stay healthy out there!
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge was submitted by our ACE and an active member in the Alteryx Community, Ippei Nakagawa (@gawa) . Thank you Gawa for your contribution and we look forward to the next ones that you may bring to the table!
Across the United States, an annular solar eclipse was observed on October 14, 2023, and a total solar eclipse will be observed on April 8, 2024. In this challenge, you will determine which lucky cities in the USA observed an annular solar eclipse in 2023 and which ones will observe the total solar eclipse in 2024, as well as one lucky city that will observe both! The provided datasets include solar eclipse information from 2023 and 2024 including the name of the city; latitude and longitude of the city; how long the eclipse will last; and the eclipse’s category (P: partial, T: total, A: annual).
Your tasks:
Create a combined list of the cities that observed the annular eclipse in 2023 and which cities will observe the total eclipse in 2024.
Create a map to visualize each eclipse’s path throughout the year for 2023 and 2024.
Determine the lucky city that will get to see both eclipses!
Hint: The provided datasets are JSON files. To facilitate the data extraction, use the Parse JSON tool in the Developer tab of Designer.
Need a refresher? Review these lessons in Academy to gear up:
Changing Data Layouts
Parsing JSON
Creating Spatial Objects
Sources: https://svs.gsfc.nasa.gov/ https://svs.gsfc.nasa.gov/vis/a000000/a005000/a005073/2023_city_times.json
https://svs.gsfc.nasa.gov/vis/a000000/a005000/a005073/2024_city_times.json
Good luck!
... View more
A solution to last week's challenge can be found here.
Using the provided dataset, calculate the average hotel stay and count the number of hotel reservation IDs for all hotel reservations that were not canceled and at least one day in length.
Source: GIPHY
The solution file for this challenge was updated on June 24. 2022.
... View more