Learning Resources

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Desktop.   This challenge comes to us from @atcodedog05 Thank you for your contribution!   Are you a fan of the sitcom The Office and the character Michael? This week is Part 2 of the "Goodbye, Michael" challenge. Part 1 can be found here.    The dataset contains information about the seasons, episodes, scenes, and lines of the series. In the episode “Michael’s Last Dundies,” there is a goodbye song that is sung to Michael by his employees. Find and extract the 18 lines of the song from the dataset and who sings each line. In the dataset, the song starts after Michael says, "Oh my God, something's happening," and ends with him saying, "Yeah, okay. Well this is gonna hurt like a mother."   Data Source: www.kaggle.com/datasets/nasirkhalid24/the-office-us-complete-dialoguetranscript   ... View more

We hope you enjoyed last week's challenge. The solution has been posted here. For the second challenge lets look at removing characters and splitting data into columns based on delimiters.   Many products will export textual data with delimiters such as quotes. This is done so that strings can contain delimiters or control characters within them. Having more than one type of delimiter can be hard for ETL programs to interpret.  In the input text file, there are two different delimiters (double quotes, single quotes) and they surround different data types.   Use Alteryx to strip out the delimiters as superfluous and format the data as represented in the output.   You may notice that we have started classifying the exercises into beginner, Intermediate and advanced.  This classification is used by Alteryx internally to sequence exercises as users advance.    Update 11/23/2015: The solution has been uploaded. ... View more

  Hi Maveryx,   A solution to last week’s challenge can be found here.   This challenge was submitted by Ippei Nakagawa, one of our most creative contributors to challenges. Thanks, @gawa , for your invaluable contributions, and again it was a pleasure meeting you in person during Inspire2024!   Though perfect people may be a myth, perfect numbers are real! A perfect number is a positive integer that is equal to the sum of its divisors (excluding itself).   Your challenge is to examine the provided dataset, which is a list of integers ranging from 1 to 10,000, and determine the perfect numbers hidden within. For example, the smallest perfect number is 6, which is the sum of its divisors: 1, 2, and 3.   Need a refresher? Review this lesson in Academy to gear up: Summarizing Data   Good luck!   ... View more

A solution to last week's challenge can be found here. Image Source: https://commons.wikimedia.org/wiki/Category:Paralympic_Games   Let’s dig into the data for the Summer Paralympic Games 2020!   This dataset includes a column “RecordID” that corresponds to the names of the athletes, a column for “NOC” for the countries and a “Discipline” column.   For this challenge, your job is to: - List the participating countries and how many athletes for each country - List of the 5 countries with the most athletes - List the first 5 countries (alphabetic order) with the least athletes (they are more than 5) - List all the countries and disciplines by alphabetic order and, add the athlete count and athlete ID   Have a good week! ... View more

A solution to last week's challenge can be found here.    A furniture store located in New York schedules their deliveries for customers based on the transit time to the order’s specified location. The first dataset contains a list of customers, the date of their order, and the state they live in. The second dataset is a list of transit times from the furniture store. This store does not deliver on weekends, so orders that arrive on the weekend will need to be delivered on the following business day.   Create a workflow to assign each order an appropriate delivery day and incorporate the date into a message describing when the order will be delivered. ... View more