Alteryx Academy

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

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 Maveryx,   Welcome to your very first Cloud Quest! This initiative is a thrilling journey into the world of the Alteryx Analytics Cloud, and we are kicking things off with a focus on Alteryx Designer Cloud. These new quests are not only tests of your skills but also opportunities to delve deeper into the practical uses of Designer Cloud in handling real-world data issues.   In the world of data processing, text files often include quotes, which are commonly used to manage strings. This can pose a unique challenge for extract, transform, and load (ETL) programs due to the presence of multiple character types.   In this quest, you have a CSV file containing two rows of concatenated data that include double quotes, single quotes, and commas, which enclose different data types. Use Designer Cloud to separate the data into three different columns: Poem, Poem ID, and Poem Read Date. Refer to the image below to see how your solution should look.       Hint: A combination of Formula, Text to Columns, and Select tools should be suffice to solve your problem! If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance: Getting Started with Designer Cloud Building Connection in Designer Cloud Building Your Workflow in Designer Cloud   Once you have completed this quest, capture a screenshot of your finalized workflow in Designer Cloud and attach the image of your solution to a comment on this post.   Here’s to a successful quest!   SOLUTION   ... 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) 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

Hello Community Members,   A solution to last week’s challenge can be found here.    This week’s challenge is all about an Era... of Costumes!   Unless you avoid listening to all popular music, you have likely heard of the musician Taylor Swift and her sensational world tour: The Eras Tour. This challenge celebrates the final concert of Taylor Swift’s record-breaking tour, which took place yesterday in Vancouver, Canada.   For those unfamiliar, The Eras Tour is a 3.5-hour concert featuring music from different eras (albums) of Taylor’s career. She performs 44 songs, divided into 9 acts, and changes costumes multiple times throughout the show.   Some of the featured acts are Lover, Fearless, Folklore, Speak Now, Red, Reputation, 1989, and Midnights. Each act comes with several costume options! The combinations of these costumes vary across the 149 shows represented in the provided Eras Challenge.xlsx dataset and dataset with images and URLs of the costumes worn (Costume_catalog.yxdb).   Your tasks for this challenge:   Identify which costume combination Taylor wore more than once, covering all nine acts. Create a costume catalog with images for the list generated in Task 1.   Need a refresher? Review the following lessons in Academy to gear up: Changing Data Layouts Creating a Layout Adding Text   Happy solving!   Data Source: Taylor Swift Style Blog https://docs.google.com/spreadsheets/d/1caBoaDi1id6k4s1sP1bTbo846inOXzN13p0C5OrFY2E/edit#gid=393964062   Image Source: https://taylorswiftstyle.com https://pagesix.com   The Academy Team ... View more