Alteryx Academy

A solution to last week’s challenge can be found here.   Congratulations, class of 2026!   For many new college students, now is the time to pay tuition for college, and sometimes their college decision is based on financial data. This dataset contains information about private and public colleges in the US, where these institutions often offer different tuition for  in-state and out-of-state students.   Using the provided data: - Create a list of 4-year colleges by state that includes the total payment (tuition plus room and board) in 2020 for private colleges and public colleges for in-state and out-of-state students. - Find the top 10 schools that give the most significant discounts for in-state students. ... View more

  Hi Community,   We posted the solution JSON file to Cloud Quest #43. 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 Start Cloud Quest 44.json to your Alteryx One library. Reconnect Quest44Input.csv and Quest44Output.csv to their respective Input Data tools in your starting 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: Rolling averages, also known as moving averages, smooth out short-term fluctuations in data so you can better see long-term trends. A 3-month rolling average shows more recent shifts, while a 6-month rolling average provides a broader view of the data.   For this week’s Quest, your goal is to: Create 3 and 6 month running averages for the values contained in columns: c.LK98, p.LK98, c.1K, p.1K, c.NLP3, and p.NLP3. Append the averages to the original table ensuring results remain grouped by RM Category, Year, and Month.   For Example:   Month Value Running 3 mo. Average 1 218 218 2 200 212  3 272 233   Hint: Flex your abilities with the Multi-Row Formula tool! For values that do not exist, replace with zero. Image: https://en.wikipedia.org/wiki/Moving_average#/media/File:Lissage_sinus_bruite_moyenne_glissante.svg     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

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Geetika Tadlimbekar, @stataltgee. Thank you, Geetika, for your submission!   The Golden Rectangle is often considered one of the most aesthetically pleasing shapes in art and architecture. This proportion appears in famous works such as the Mona Lisa and the Parthenon. In this challenge, your goal is to analyze a dataset of rectangles and identify those that most closely match the Golden Ratio.   Tasks Calculate the ratio (longer side divided by shorter side) for each rectangle in the dataset. Identify the top 4 rectangles whose ratios are closest to the Golden Ratio (approximately 1.618).   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Download Start File ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by James Bevan, @JBevan89 . Thank you, James for your submission!   For this week’s challenge, we will be working with the TMDB Movie Metadata dataset from Kaggle, a rich collection of information about modern films, including revenues, budgets, and production details.   Your role as a data analyst is to dig into the data and uncover insights by answering the following questions: Which 10 movies had the highest budget? Which 10 movies generated the highest profit? (Profit = Revenue – Budget) How many different languages are spoken across all movies in the dataset?   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Source: https://www.kaggle.com/datasets/tmdb/tmdb-movie-metadata/data   Download Start File Download Solution File ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Erin Miller, @Erin . Thank you, Erin, for your submission!   You are a data analyst reviewing independent medical review outcomes. Your objective is to identify patterns that influence whether a health plan's decision is upheld or overturned.   Use the dataset to analyze trends and answer the following questions.   For each diagnosis category, calculate the percentage of cases where the health plan’s decision was upheld and where it was overturned. Exclude any records with missing diagnosis categories. For each gender (male or female), identify the age range most commonly associated with overturned decisions. Determine which diagnosis and treatment categories have the highest number of overturned decisions. Create a graph/chart showing how the percentage of overturned decisions has changed over time, broken down by year. Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team Source: https://www.kaggle.com/datasets/prasad22/ca-independent-medical-review   Download Start File Download Solution File  ... View more