Alteryx Academy

The solution to last week's Challenge can be found here!   You'll want to get this week's Challenge done quickly, especially if you want to find out if your current location is in the path of today's total solar eclipse!     The given input file contains data on the path of the moon's shadow of the solar eclipse that will pass over North America on Aug. 21, 2017 (source: https://eclipse.gsfc.nasa.gov/SEpath/SEpath2001/SE2017Aug21Tpath.html). To experience totality, or the darkness of the moon's shadow, you need to be within the boundaries of the eclipse's path. Use the data below to plot the Northern, Central and Southern limits of the of the eclipse's path. Then, determine if your current location is within the path of totality. If not, what is the minimum distance from your location to being within the boundaries of totality?   *HINT: Convert geographic degrees and minutes into decimal degrees using the formula DEGREES + (MINUTES/60) **HINT: Longitudes in North America are negative values. ***HINT: It's helpful to limit the path of totality to the boundaries of North America (optional). Download a shapefile of the United States here: https://www.census.gov/geo/maps-data/data/cbf/cbf_nation.html. Happy Eclipse Day!             ... 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

We hope you enjoyed last week's challenge . The solution has been posted here. For the second challenge lets look at removing characters and splitting data into columns based on delimiters.   Many products will export textual data with delimiters such as quotes. This is done so that strings can contain delimiters or control characters within them. Having more than one type of delimiter can be hard for ETL programs to interpret.  In the input text file, there are two different delimiters (double quotes, single quotes) and they surround different data types.   Use Alteryx to strip out the delimiters as superfluous and format the data as represented in the output.   You may notice that we have started classifying the exercises into beginner, Intermediate and advanced.  This classification is used by Alteryx internally to sequence exercises as users advance.    Update 11/23/2015: The solution has been uploaded. ... View more

A solution to last week’s challenge can be found here.  Source: https://en.wikipedia.org/wiki/Formula_One   Formula 1 racing is one of the most popular sports in the world and the 2011 season is considered one of the most dramatic in history! If you aren't familiar with this category of racing, know that F1 cars are the most sophisticated race cars in the world and they are created by legendary automobile manufacturers.   Each season, teams travel to different locations around the world to compete in races. At the end of the season, awards are presented to the top driver and top team based on a point scoring system. The scoring system awards points to both drivers and teams at the conclusion of each race (the scoring is presented in the Points table). Since the races take place at different race tracks, each race has a unique number of laps. Additionally, races are constrained to a 2 hour window. This means not all races will complete the scheduled number of laps.   For this week's challenge we have provided a sample of lap data from the 2011 F1 Season covering races 4 - 17. You'll find each driver's times for every lap completed in each race. Use the Race Data to figure out who finished in the points for each race and find the top three racers across this 13 race sample. ... View more

Congratulations on completing Exercise 2!    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