Alteryx Academy

A solution to last week’s challenge can be found here. "Pumpkins Halloween 2013" by Mod Mischief is licensed under CC BY-SA 2.0   Pumpkins abound, and squirrels are happy. It’s that time of the year! Halloween is in just a few days, and you need to get candy for trick-or-treaters.   This Halloween dataset contains 85 types of candy. Take a closer look at the columns: - sugar percentage - The percentile of sugar it falls under within the data set. - price percentage - The unit price percentile compared to the rest of the set. - favorite percentage - The overall win percentage according to 269,000 matchups. Your house is going to be a hit if your candy basket includes the following: - The 5 candies with the lowest “sugar percentage”. An average trick or treater consumes 7,000 calories worth of candy, so you want to offer some healthy options. - The 5 candies with the highest “favorite percentage”. Your neighbors know you are a people pleaser! - The 5 candies with the lowest “price percentage”. The giant tarantula inflatables you bought weren’t cheap, so you need to save some money on the treats.   And no peanut or almond candies. The teal pumpkins at your front door communicate that your candy basked is allergy-friendly. (Did you know that’s a “thing”?)   Hint Make sure to filter out all candies that are not allergy friendly first.   Among the 85 types of candy from the dataset, what are the 15 candies to have in your basket? ... View more

A solution to last week's challenge can be found here.   The Billboard (magazine) is a weekly American music and entertainment magazine that provides music charts. The Hot 100 lists the 100 most popular songs of the week in the US.   This dataset contains information about the Top 100 most popular songs between 2015 and 2021. Find out the top 5 artists and songs who stayed on the chart the longest (weekly) for each in 2017, 2018, 2019, 2020. Then create a table in the format of your choice to display your results.   Hint: The column "Weeks on Chart" shows how many weeks the song was on the charts since its launch. ... View more

A solution to last week’s challenge can be found here.   This challenge comes to us from @Qiu  who was inspired after reading the following article: https://medium.com/analytics-vidhya/using-spatial-and-activities-data-with-python-to-understand-how-messi-and-ronaldo-do-their-magic-eae008531509. Thank you for your contribution!   This week and next week, you will use datasets to analyze how Lionel Messi and Cristiano Ronaldo do their magic.   To complete Part 1 of this challenge: - Use the Players dataset to filter information about Messi and Ronaldo. You must include the first name, last name, role name, short name, and ID (wyid or playerid). - Use the events_Spain_Goal dataset to retrieve information for the same 2 players. You must include the eventName, matchID, playerID, position_0_x, position_0_y, subEventID, subEventName, and tags_0_id. - Join your 2 findings in 1 dataset. It will be used in Part 2 of the challenge. ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Douglas Perez, @dougperez . Thank you, Douglas, for your submission!   A company recently hosted an internal Alteryx certification event to promote professional growth and upskilling across the organization. Each participant was assigned to a team, and throughout the event, employees earned various professional certifications.   Now that the event has concluded, it’s time to analyze the results and determine which team came out on top!   You’ve been provided with two datasets: A certifications dataset containing certification records, each with its status (Expires or Expired) and the date. A team mapping dataset linking each participant to their respective team.   Analyze the results and rank the teams based on the number of valid certifications earned by their members. Follow the rules below:   Only include certifications that are currently valid (status is Expires). Focus only on certifications with names that include Alteryx Designer or Server. Exclude any certifications that mention Cloud or Trifacta. Aggregate the results by team and rank them from highest to lowest based on the number of valid certifications.   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Source: Dataset generated by ChatGPT.   Download Start File Download Solution File  ... View more

The link to last week’s challenge (challenge #40) is HERE   This week’s exercise looks at using Alteryx to calculate the number of weekdays during each pay period.  Employees get paid twice monthly so the number of weekend days within a period can vary.   Objective:  For each month and pay period, calculate the # of weekdays that make up the pay period (i.e. exclude weekend days from the calculation). ... View more