Learn

Submit your AI use case today and win engineering support! ... View more

The link to last week’s challenge (challenge #28) is HERE   Hi everyone, what an awesome time we had at the Alteryx Inspire 2016 Conference in San Diego last week.  It was so nice to meet many of the Community members in person.  If you attended the conference and went to the Grand Prix event, this week’s challenge is the first of the four laps.  We will cover all of laps as weekly challenges in the next weeks.   See if you have what it takes to compete, keep in mind the contestants only had about 10 minutes per lap maximum so maybe time yourself.   Use Case:  You are the commissioner for your fantasy baseball team. You recently completed your draft and you want to run some simple statistics about each fantasy team.   You have 3 inputs 1) Fantasy pick summary from your draft 2) Hitter stats on all field players (whether selected in your draft or not) 3) Pitchers stats on all pitchers (whether selected in your draft or not)   Objective:  In order to run some stats on your draft, you first need to prep your data. Please combine all 3 files so that you have a single output that contains stats on each player drafted in your draft, ordered by "Overall_Pick."   Drivers start your engines! ... 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

  Hi Community members,   A solution to last week’s challenge can be found here.   This two-part challenge was submitted by Guilherme Dias, @3I_ATLAS. Thank you, Guilherme, for your great submission!   Electric vehicle (EV) production data offers powerful insights into innovation, market trends, and manufacturer behavior. As researchers dig into the data, your task is to help uncover major production shifts and unique behaviors in EV model lifecycles. For part 1 of this challenge, your analysis should only include data from 2010 to 2024. Exclude data from the year 2025, as it contains only partial records. Here are the three tasks you need to accomplish:   Identify the year with the largest increase and the largest decrease in total EV production compared to its previous year. Find the top 3 EV models that had the longest production pause (in years) before resuming production again. Only consider models that had a production gap followed by a confirmed comeback. In the most recent full year of data, determine which manufacturer introduced the most units of never-before-seen models. Ensure that your logic dynamically adjusts to the latest year, without hardcoded values. You are provided with one dataset: Electric Vehicle Data – provides the model year, manufacturer (brand) and car model.   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Stay tuned for part two of this challenge! Good Luck! The Academy Team   Source: https://catalog.data.gov/dataset/electric-vehicle-population-data   Download Start File   Download Solution File ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Michael Keiffer, @mkeiffer . Thank you, Michael, for your submission!   In this week’s challenge your task is to match each hourly worker’s time-in and time-out entries with the correct pay period end dates. Workers are paid on a biweekly schedule, and the list of valid pay period end dates is provided in a separate file.   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   Download Start File Download Solution File  ... View more