Alteryx Academy

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

  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   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

The solution to last week's challenge can be found HERE.    Determine the items of clothing that have the highest average rating. In your analysis, include 1) only items of clothing that have at least 10 positive feedback reviews and 2) the five highest rated clothing items from each class.   The original data and its metadata can be found here.        ... View more

Last week's solution can be found here!   This week's challenge is around assigning the right income tax rate to each salary. Your goal is to count the number of people associated with each tax rate.   How many feel at tax time.   In our starting workflow, you'll find three datasets: 1) A grid of 100 employees from 26 companies. Before everyone gets worried, yes, I randomly generate this salary data and it is not representative of the population! Do note that each salary has a 'I' or 'J" representing whether this salary will be filed jointly or individually 2) A list of the company names 3) A tax table with the income rates. Notice that there is not a range in the tax table. You must infer the range based on when the next tax rate starts.   Easy Path: 1) Solve this problem as is.   Hard Path: 1) Do not use: Join, Crosstab, Transpose, Multi-field Formula, or Multi-Row Formula ... View more

A group of friends are playing their favorite game. Not being a bunch of data analysts and understanding the importance of inputting data in an easy to work with way, they devised an incredibly inefficient way to keep score of their game! In the game, there is 5 rounds of play and 5 players (a,b,c,d,e - first letter of their names). For each lowercase letter under their initial, 1 point is awarded. For each uppercase letter, 1 point is subtracted from their overall score. As the only right and fair arbiter, they call you in to use Alteryx to figure out each players score for each round and their respective totals. Who won? ... View more