Learn

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

  Hi Maveryx,   A solution to last week’s challenge can be found here. This challenge comes to us from @AkimasaKajitani . Thank you for your contribution, Aki!   Meteorite showers are a captivating natural phenomenon, though it can be challenging to see them depending on your location. Fortunately, residents and visitors in the Las Vegas area enjoy an advantageous position, being in proximity to expansive desert skies that offer excellent conditions for meteorite watching.   For this challenge, your mission is to plan a budget-friendly meteorite impact site tour near Las Vegas, ensuring enthusiasts visit locations where they have the best opportunity to witness this celestial spectacle.   Here are the tasks you must complete. Calculate all distances in kilometers.   Find a meteorite impact site that is closest to a hotel that costs less than $200 per night. Designate this location as the "First Stop." Identify the nearest meteorite impact site in relation to the First Stop. Label this site as the "Second Stop" and determine the distance between the first and second stops. Locate the nearest meteorite impact site in relation to the Second Stop. Name this site “Third Stop” and determine the distance between the second and third stops. Calculate the total distance traveled from the hotel to the third stop. Data Summary: You have two datasets. The text dataset contains the latitude and longitude of some hotels in Las Vegas with their cost per night. The second dataset, meteorite-landings.csv, contains the latitude and longitude of over 45,000 meteorites that have struck our planet.   Source: https://www.kaggle.com/datasets/nasa/meteorite-landings ... View more

  Hello Community Members, A solution to last week’s challenge can be found here.    This challenge was submitted by Yash Thakkar. We appreciate your contribution @yash_thakkar!    Some months mark pivotal moments for students and job seekers worldwide, especially when exploring the H-1B job market. The H-1B visa program allows US employers to temporarily hire foreign workers in specialty occupations requiring a combination of highly specialized knowledge and a bachelor's degree or higher in a relevant field, or its equivalent.   The dataset provided includes fiscal year 2024 data on employers who have submitted petitions to employ H-1B workers.   Your tasks are: Identify the top 10 companies that submitted the most H-1B petitions in 2024. Determine the top 10 industries with the highest demand (number of total petitions submitted) for H-1B workers in 2024. Hints: Exclude companies with missing industry data (Industry (NAICS) Code). Focus only on approved petitions as follows: Initial Approval (first-time H-1B employment) Continuing Approval (extensions or changes for existing H-1B employees) Happy solving!   Sources: https://www.uscis.gov/tools/reports-and-studies/h-1b-employer-data-hub https://www.uscis.gov/tools/reports-and-studies/h-1b-employer-data-hub/understanding-our-h-1b-employer-data-hub   The Academy Team ... View more