Alteryx Academy

A solution to last week’s challenge can be found here.  Source: www.californiaavocado.com/blog/avocado-fruit-or-vegetable   Love them or hate them, Avocados are a popular food that have been increasing in popularity. Did you know that they are technically a berry?   At any rate, this week's challenge is to find the regions with the largest increase (by percentage) of avocado consumption for [total volume] and each PLU code. PLU codes are the 4 digit codes which classify produce in retail stores. The final output should include both conventionally grown and organic results. ... View more

A solution to last week's challenge can be found here.  Source: Steelers.com   The 2020 NFL draft will occur later this week. Yay American Football! Let's look back at data from previous drafts to find out which teams used their draft picks most efficiently.   Each year the NFL holds a draft where aspiring collegiate players are selected to play for an NFL team. The draft takes place over 7 rounds with each team selecting players based on their performance in the previous season. Selections, also known as picks, can be traded amongst teams, resulting in some teams not selecting within given rounds and others having multiple picks.   In general, the earlier a pick is made in the draft the more valuable it is (i.e., you are likely to get a more valuable player with the first pick than the 10th pick). Sometimes, a highly valued prospect does not pan out and the valuable draft pick is wasted.   For this week’s challenge, create a list of the top three teams with the highest draft efficiency for each year of the data. ... View more

A solution to last week’s challenge can be found here.  Source: GIPHY   This challenge comes to us from @ramesh_neel - thank you for your contribution!   The input file has names of users connected by commas in a single field with random numbers to each name . Some of the names start with a lower case and some have middle name to them. [ names generated using a random name generator website ]   Create a set of email IDs (using @testemail.com as the domain) using a combination of first letter of the first name + last name of the user [even if they have a middle name ] and grouped into A-Z categories. Provide a count of the number of emails in each group.   Hint - In your output exclude any users without a valid name ( i.e, does not contain a number) ... View more

  Hi Community,   We posted the solution JSON file to Cloud Quest #45. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!     Let’s dive into this week's quest!   Download the provided JSON file containing your starting data and workflow files. Upload Start Cloud Quest 46.json file to your Alteryx One library. All necessary datasets are contained within Text Input tools in the workflow.   For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process.         Scenario:   For this week's quest, you are acting as a senior-level professional researching the data analysis job market. Identify the 5 best job opportunities for a senior-level (SE) professional seeking a full-time, 100% remote position.   You are provided with two datasets: • Job Market Data: Contains information about data analysis job salaries and characteristics. • Country Codes Data: Contains country codes and their corresponding full country names.   Requirements The ranking of "best opportunities" should be based on the average salary in USD for each job title. • Only consider jobs with salary in USD. • Only consider job titles that appear more than once in the dataset. • The final output should list the Top 5 Job Titles and the Country where these opportunities are primarily located. Job experience levels: • EN: Entry-level/Junior  • MI: Mid-level/Intermediate  • SE: Senior-level/Expert  • EX: Executive-level/Director Job location: • If Remote_ratio = 0, the job is onsite. • If Remote_ratio = 50, the job is hybrid. • If Remote_ratio = 100, the job is remote.   Hint: Read the filtering requirements carefully. Image: Generated by Google Gemini, Oct 23, 2025, OpenAI, https://gemini.google.com.   Earn Cloud Quest badges:   After completing your quest, head back to your Analytics Cloud library: Download your workflow solution file. In your reply, attach both your JSON solution file and a screenshot of your workflow. Keep submitting—every solution gets you closer to earning more Cloud Quest badges!   Here’s to a successful quest! - The Academy Team     Download Start File   ... View more

  Hello, Community Members!   A solution to last week’s challenge can be found here.   Financial analysts often need to consolidate data from various sources. This week's challenge focuses on using Alteryx functions in financial planning and analysis (FP&A) projects.   The first dataset includes sales information for various countries and business segments for the years 2022 and 2023, with the sales figures recorded in each country’s local currency. The second dataset provides the conversion rates from the countries’ currencies to euros.   Your first task is to create a final table that includes the segment, region, and total sales in euros for both 2022 and 2023. (Tip: Remove any columns where the sale price is null.) For the second part of the challenge, calculate the year-over-year variation per segment (2022–2023 in euros) and identify the segments that experienced negative variations across all three regions: Europe, Asia Pacific (APAC), and the USA.   Need a refresher? Review the following lessons in Academy to gear up: Summarizing Data Changing Data Layouts Happy solving!   The Academy Team ... View more