Learn

The link to the solution for last challenge #35 is HERE.    Use Case:  An analytical consulting company downloads medical journal publication data from the web and would like to extract all of the authors for the listed entries.   The text input contains details about each article where FAU indicates the author name for the article – in most case there are multiple authors. The details of each article are contained in lines that begin with PMID and end with an empty line.   Objective: Parse out each article PMID and list each author in sequential columns as seen in the Results.yxmd file. ... View more

  Hi Community Members,   A solution to last week’s challenge can be found here.    This challenge was submitted by Ashley Talai (@aatalai). Thank you, Ashley, for this week’s challenge, as we celebrate Pi Day!   Every year in the United States, March 14, or 3/14, is Pi (π) Day! Pi is a mathematical constant represented by the Greek letter pi (π) that is the ratio of a circle’s circumference to its diameter, approximately equal to 3.14159. Among many methods available to estimate pi, one is called the Monte Carlo simulation. This method helps solve problems by simulating randomness. The Monte Carlo simulation for pi is a probabilistic method used to estimate its value using random sampling. The technique leverages the relationship between a square and an inscribed quarter circle, calculating pi based on the proportion of randomly generated points that fall inside a circle. The datasets for this challenge contain randomly generated coordinates for X and Y within a square. The scope is limited to 100 rows for each dataset. X and Y are uniformly distributed between 0 and 1.   Your task for this challenge is to estimate pi and the percentage of variance from actual pi. To do so, you need to: Combine the X and Y coordinates. Determine whether a point is inside or outside the circle. Calculate the total number of simulations. Calculate the total number of simulations inside the circle. Finally, calculate the estimation of pi and the percentage of variance from actual pi. HINT: If you find yourself stuck, check out our hints in the workflow file as to how to estimate pi.   If you would like more information regarding the Monte Carlo simulation, check out this article: Estimating Pi with Monte Carlo in Excel.   Need a refresher? Review the following lessons in Academy to gear up: Joining Data Diving into Expressions   Good luck! The Academy Team   Download Start File   Download Solution File   Source:  https://en.wikipedia.org/wiki/Pi#:~:text=The%20number%20%CF%80%20(%2Fpa%C9%AA,diameter%2C%20approximately%20equal%20to%203.14159.   ... View more

  Hello Community members,   A solution to last week’s challenge can be found here.    This week’s challenge was submitted by Talia Sanders (@tsand22) . Thank you, Talia, for this great challenge!   In Part 1 of this challenge, you calculated the cost of school supplies for one child in each grade of elementary school (from kindergarten [K] to sixth grade).   In this week’s challenge, you will analyze data related to school enrollment by grade level in the state of Indiana, and use the cost of school supplies results from Part 1 to answer two questions: What is the total cost of school supplies for all students for each grade (kindergarten to grade 6)? To achieve this, calculate the total number of students in each grade, and then the total cost of school supplies by grade. What is the total cost of school supplies for all students in kindergarten to grade 6? Hints: Some schools serve multiple grade levels (for example, K to 8 or 5 to 12). Be sure to include any schools that have students in grades K to 6. Include all types of schools (traditional, private, charter, etc.). There are two datasets provided for this challenge: Enrollment Data Text Input: Data for school enrollment in the state of Indiana, such as school name, number of students in each grade, and total number of students in each school. Full Cost of School Supplies Text Input: Cost of school supplies for each grade (K to 6).   Need a refresher? Review the following lessons in Academy to gear up: Filtering Data Joining Data   Ready to take this challenge? Good luck!   The Academy Team   Download Start File   Download Solution File     Data Source: https://www.in.gov/doe/it/data-center-and-reports/ File: School Enrollment by Grade Level - (Updated - SY 2023-2024)   Update with challenge 472 link ... View more

  Hi Community members,   A solution to last week’s challenge can be found here.    This challenge was submitted by Valentina Radchanka (@The_Rad_Valentina). Thank you, Valentina, for this interesting challenge!   Alteryx Server is a great platform that allows developers to share and automate workflows with business users. To access workflows on Server, business users typically need permission to interact with the Gallery, which is a central hub for running and managing workflows. By default, when a user navigates to the Gallery for the first time, they are automatically assigned a Default role. This allows them to run publicly available workflows, such as an Access Request Form. Here is how the Access Request process works:   A user submits the Access Request Form, specifying their email and preferences for: Workflow scheduling (whether they can schedule jobs) Creating collections (whether they can organize workflows into collections) API access (whether they need programmatic access to workflows) The request goes through an approval process to ensure that only authorized users receive the requested permissions. Once approved, another workflow is triggered to automate access changes, eliminating the need for manual intervention by the Server Administrator (Curator). This challenge includes two datasets: Server user data Text Input: Information about users in Server. Single user request data Text Input: Information submitted by a single user via the Access Request Form.   Your task is to generate a “payload” (a structured JSON-like data format) that the Alteryx Server API can use to grant the appropriate access permissions to the user. Your final output should look like this:     Hint: The Formula tool is your best friend! 😁   Need a refresher? Review the following lesson in Academy to gear up: Diving Into Expressions   Ready to take on this challenge? Good luck!   The Academy Team   Download Start File     Source: Server API Tool ( https://marketplace.alteryx.com/en-US/apps/418052/server-api-tool) ... View more

Hopefully everyone had fun with the Grand Prix challenges and a few of you are ready to jump in the ring next year for the 2017 Grand Prix at Inspire in Las Vegas.  The solution for the final lap (challenge #32) is HERE.   Let’s dial it back this week and look another real world example of using Alteryx to reshape data into a usable format for analysis.     Use Case:  A radio station is trying to analyze data they receive from Nielsen disclosing the number of listeners the station has on a weekly basis by program.  The challenge is that the data is formatted in a way that makes it challenging to use for analytics.   Objective:  Reshape the data detailing the listening stats for the 30 programs listed in the data. ... View more