Alteryx Academy

A solution to last week’s challenge can be found here.   Welcome to the Good Ladies weekly challenge!   Five women heist a jewelry store and steal a precious gem in the shape of a ball of yarn.   In the dataset, the 5 women responsible for the heist have been negligent and left clues behind. You are the detective on the case who is looking for these clues in a dataset.    1. Fingerprints on the glass surrounding the gem show fingerprints belonging to someone with the letters "Fled" in their first name or last name.   2. IT Department at the police is able to find that the back door lock password was changed to "ugfsjsh".   3. The vault holding the gem was blown open with "dynamic" dynamite. Found in the ruble is a business card piece. You can make out the first few letters of the word "Bogi"   4. The security guard's witness statement states that he has been vigilant about watching the store. There was only one instance last week when he was distracted by a woman with brunette hair who worked at a wireless store. He remembered later that she'd dropped a handkerchief that had the initials B.K. on it.   5. A slogan was left behind that said, "Those that synergize together can accomplish much and receive the TORPHY." First, you will have to parse the data. ... View more

A solution to last week's challenge can be found here. This dataset contains a list of holiday dates that are observed by each country from Feb. to Dec. 2020. Your Challenge is to figure out for that period: - Which country has the most holidays and how many? - Some holidays are only observed by one country. Which country has the most unique days off and how many? - Which day is the most shared in the world as a holiday and which countries are sharing this holiday? ... View more

    Hi Community,   We posted the solution JSON file to Cloud Quest #32. 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 Cloud Quest 32 Start.json to your Analytics Cloud 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 Update.       Scenario:   As a social media manager, you would like to capture and count hashtags (#) that appear in posts on your platform.   Your goal is to build a workflow that catalogues each hashtag used, identifies which user ID posted the hashtag, and counts how many times those hashtags appear.   Represent this information in a cross-tab view grouped by hashtag.   Hint: Use the RegEx tool to tokenize the extracted hashtags. Dataset sourced from Weekly Challenge #56.   Once you have completed your quest: Return to your Analytics Cloud library and download your workflow solution file. Include your JSON file and a screenshot of your workflow as attachments to your comment.   Here’s to a successful quest! - The Academy Team   Download Start File ... View more

  Hi Community,   We posted the solution JSON file to Cloud Quest #33. 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 ZIP file containing your starting data and workflow files. Upload the Start Cloud Quest 34.json file to your Analytics Cloud library. Reconnect the Invoice Data.csv file to the Input Data tool in your starting working. For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update. This week’s challenge comes from @bdelarosa—thanks for the awesome contribution!       Scenario:   For this Cloud Quest, your task is to organize the provided input data so it clearly shows: Current inventory levels for each product at each location Past sales history for each product at each location The average number of units sold per product per location Total incoming quantities for each product at each location (based on purchase orders) The earliest expected arrival date for each product on order Be sure to display all inventory records, even if there haven’t been any sales or purchase orders for that product. Hint: Use the Join Multiple tool to bring the datasets together—this will streamline your summaries process.   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.    This week’s challenge was submitted by Kapil Rautela @kapil_rautela1990 . Thank you, Kapil, for submitting this fun challenge! We are going to explore the intriguing Pell numbers. In mathematics, the Pell numbers are an infinite sequence of integers that follows a simple yet fascinating rule: each number is the sum of twice the previous number, plus the Pell number before that. This means that the sequence starts with 0 and 1, and each subsequent number is generated by this formula: P(n)=2×P(n−1)+P(n−2) For example, the first few terms of the Pell sequence look like this: P(0) = 0 P(1) = 1 P(2) = 2 P(3) = 5 P(4) = 12 Your challenge is to find the first 30 numbers in this sequence.   Ready to see how the numbers grow? It is a fun and rewarding journey, and you will quickly discover how this simple formula creates such a unique pattern.   Good luck!   The Academy Team   Download Start File   Download Solution File ... View more