Alteryx Academy

A solution to last week's challenge can be found here.  Source: https://www.requestyourcar.com/blog/details/what-is-corporate-fleet-vehicle/   Many businesses require a fleet of vehicles to conduct their business. Eventually, all of those vehicles need to be refueled so many of these companies choose to issue credit cards that are assigned to a particular vehicle in the fleet. While this is convenient, it can result in unscrupulous behavior...   For this week's challenge, use the provided datasets to create a workflow that flags potentially illegitimate transactions for review. ... View more

The link to last week’s challenge (challenge #26) is HERE This week’s challenge is a spatial use case to preprocess a spatial object for mapping.  The input file is a single complex polygon that represents a coverage area.   Use Case: A wireless telecommunications company wants to remove holes and splatter from their coverage area for simplified map display.   Splatter can be define as unnecessary pieces of the whole polygon.   Objective: Remove all splatter less than 2 square miles and holes from the coverage area.   This exercise can generate varying answers based on the configuration of the spatial tools used for the process. As a result the challenge does not contain an output.    Have fun! ... View more

The link to last week’s challenge ( challenge #25) is HERE   This week’s challenge is a use case faced by one of our customers that can leverage the geo-spatial tools available in Alteryx.  If you have the spatial data available you can output your results as drive-distance, in the event that you do not have the drive-distance data available, please use the straight-line distance.  The basic tools and setup of the data needed will be identical.  Output results will be provided for both methods.  In the event that you use drive-distance and your results vary slightly from the sample output, it may be due to variance in the data set used for the exercise.   Use Case:  in order to audit their employee expense reports, a service company would like to calculate how far (in miles) their technician is traveling from their hotels, to the worksite, then to their destination hotel on a daily basis.   The Data:  The source is collected in a way that record 1 contains the spatial object for the beginning hotel for day 1, record 2 is the spatial object for the worksite for day 1, and record 3 is the spatial object for the ending hotel for day 1.  This pattern repeats for three successive days.   Find the distance on a daily basis the technician is either driving or straight line distance if you don’t have the spatial data available.   Enjoy! ... View more

Congratulations on completing Exercise 1!    When you are ready to submit your solution, click "Reply" to this post and upload your workflow.   You may also download and review the attached solution. ... View more

Hi everyone!   A solution to last week’s challenge can be found here.   In this weekly challenge, you will find a dataset containing the New York Times articles from January 1, 2020 to December 31, 2020.   Your first task is to identify which day of the week has the highest number of sports articles published.   Your second task is to identify how many times the word "Football" or "football" is in the headline or keywords on the day of the week that has the highest number of sports articles published.   As a final result, you have to write a statement similar to this: The word football appears ____ times in sports articles published on _____.   BONUS! Forecast in what future month articles will surpass the 20 million comments milestone using the high end of the 70% confidence interval. (HINT: Consider a cumulative sum for all posts since 2020)   For the bonus, you will need to Download and Install Predictive tools [https://help.alteryx.com/20213/designer/download-and-use-predictive-tools]. Also, don’t worry if your output it’s slightly different from the output here. What is important is to understand the results.   Good luck!! ... View more