Happy Halloween loyal weekly exercise participants, here is an exercise I hope does not scare you too much. Hopefully is a treat and not a trick. The link to last week’s challenge is HERE.
Use case: An Alteryx subscriber needs to build a process to validate VIN numbers to test for data quality issues across the fleet data. The algorithm is provided at the below wiki link.
http://en.wikipedia.org/wiki/Vehicle_identification_number
Objective: Please take the VIN numbers from the Input and create a new column for the check digit. Compare the check digit with the calculated check digit value. If the two values do not match (and there was no error in the calculation), then there is a mistake in the VIN. Out of the six VINs, how many vehicles have invalid codes?
... View more
Here is this week’s challenge, I would like to thank everyone for playing along and for your feedback. The link to the solution for last challenge #09 is HERE. For this challenge let’s look at the date and time functions in Alteryx.
The use case: A distribution center receives a package. At the point of receipt, the package is scanned and a timestamp is captured for arrival date/time. The company is trying to reduce the amount of time the package is at its facility and as a result is trying to analyze how long packages remain at the facility.
The objective for this challenge is to calculate the delta between arrival date/time and the Time_Now field (this field has the date/time of the creation of this challenge and will be changing as time goes on). Create a unique field for Days, Hours, Minutes and Seconds.
We have listed this as an intermediate exercise and I expect it will go very quickly for many of you. Let us know what you think, we are looking forward to hearing your feedback.
UPDATE 2/1/2016
You can find the solution below.
... View more
Hello Community Members,
A solution to last week’s challenge can be found here.
This challenge was submitted by our valued Community contributor, Jifeng Qiu. @Qiu, we appreciate your continued creativity in submitting engaging challenges.
May the Force be with us once more!
You have access to a survey about Star Wars, with responses collected from fans before the release of the seventh episode in the franchise, Star Wars: The Force Awakens.
Before diving into the challenge questions, you need to complete a few steps to clean and prepare the data for analysis.
HINT: For each task, you will be required to work on a unique question, outlined as follows:
Which of the following Star Wars films have you seen? Please select all that apply.
Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.
Please state whether you view the following characters favorably, unfavorably, or are unfamiliar with him/her.
However, the data is not straightforward. Each question may have multiple answers, and the fields related to the same question follow a pattern: the question itself, followed by unnamed fields that appear immediately after.
Once the data is prepared, you are ready to complete the following tasks:
Determine which Star Wars episode among the six films was the most viewed by survey respondents.
Create a graph to evaluate the correlation between how often films were viewed (from Task 1) and the rankings provided by respondents.
Identify the top two favorite characters (rated "Very Favorably") and the top two most disliked characters (rated "Very Unfavorably") based on unique respondents in the survey data.
Need a refresher? Review the following lessons in Academy to gear up:
Changing Data Layouts
Summarizing Data
Happy solving!
Data source: https://www.kaggle.com/code/samaxtech/cleaning-analyzing-star-wars-survey-data/input
The Academy Team
... View more
Hi Maveryx,
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!
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
