Alteryx Academy

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 ... View more

  Hi Maveryx,   A solution to last week’s challenge can be found here.    Are you a big fan of Formula 1?    This challenge is an exciting part of the Alteryx Formula 1 Fanalytics event.    Rev your engines and get ready to race to the finish. Your goal is to analyze driver lap time data and pinpoint the best driver in rainy conditions, making them the top choice for any wet race conditions.     Bonus: Tune in to a recording of the “Alteryx + McLaren: Formula To Success with AI & Analytics” webinar to hear from McLaren Racing CEO, Zak Brown, and Alteryx CIO Trevor Schulze on how McLaren and Alteryx ride the data wave using AI and analytics to conquer change.    Source: All data provided for this challenge is entirely fictional. ... View more

A solution to last week’s challenge can be found here.  To solve this week’s challenge, use Designer Desktop or Designer Cloud Trifacta Classic.    If you are currently selling your home, you may not be happy to learn that capital gains (profit from the sale of the home) are taxable in the United States. One way to reduce the amount of capital gains taxes you pay is to use deductions.     For this challenge, we will use two possible deductions, the Exclusion of Gain (you may qualify to exclude up to $250,000 of the capital gain from your income as a single filer, or up to $500,000 of that gain if you file a joint return with your spouse); and Capital Improvements (when home sale profits exceed the exclusion of gain threshold, consider deducting any capital improvements you made to the home while you owned it).    Your challenge is to answer two questions:  Identify which home sellers will have to pay taxes on the profit made from the sale of their home.  Determine how much those sellers have to pay.  Use the information below to calculate and determine who should pay taxes.  Source: https://www.homelight.com/blog/tax-write-offs-for-sellers/#:~:text=Page%209%20of%20IRS%20Publication,retaining%20wall%20or%20swimming%20pool  DISCLAIMER: This challenge is meant for educational purposes only and is not intended to be construed as financial, tax, or legal advice.  ... View more

A solution to last week's challenge can be found here!   We are thrilled to present another Challenge from our “Think like a CSE” series, brought to you by our fearless team of Customer Support Engineers. Each month, the Customer Support team will ask Community members to “think like a CSE” to try to resolve a case that was inspired by real-life issues encountered by Alteryx users like you!    This month we present the case of ranking ratings in descending order.  Below, we’ve provided the information that was initially available to the Customer Support Engineer who resolved the case. It’s up to you to use this information to put a solution together for yourself.   The Case: A User is trying to create a column of rank for an input dataset. Like the Rank function in SQL, we want to return the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question. Please see the images below for an example. Ranking data     Your Goal:  Create a Rank column like the Rank function in SQL. ... View more

A solution to last week’s challenge can be found here.   Are you wondering which artists produced the top songs? Do you want some insights? This challenge is for you.   The following dataset contains information about the top 500 songs. Using the dataset, find the top 50 artists with the most albums and the highest average rating. Include the following columns in your list :   - Artist(s) - Number of albums (Descending) - Average rating based on all albums (Descending) - Album title(s) - Average number of reviews based on all albums (Descending) - Genre(s) - Year the first album was released - Year the last album was released Note: If in your solution you have null records for the Release Year, do not include them.   This challenge was updated to propose 2 start files and 2 solutions.   ... View more