Learn

A solution to last week’s challenge can be found here.   All over the world, women are taking an active role in politics and public policies decision-making.   In this challenge, use two datasets to discover what are the five top countries in South America that have the most female political representation in national parliaments in 2019. Then create a chart of your choice to showcase your findings and showcase the Female Political Representation in National Parliaments in South American Countries by 2019.   The first dataset contains information about the percentage of women's proportion of seats in national parliaments. The second dataset provides a list of the continents, country and regions. ... View more

A solution to last week’s challenge can be found here.    Sports franchises are not only valuable, but they often become integral to the identity of the cities they represent. These “big league” teams usually inhabit only the largest cities to ensure there are plenty of fans nearby to buy tickets and jerseys! The NFL, NBA, MLB, MLS, and NHL have different demographics and they don’t always inhabit the same cities.   For this week’s challenge, use the 5 datasets provided to find the cities that do not have a team from all 5 leagues.   Your output should list the teams and their leagues for those cities. Note that some of the city information is missing a state, but you can grab those missing values from another dataset that has the same city! ... View more

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

For those of you following along, thank you, you can find the solution to last week’s challenge ( challenge #23) is HERE.    This week’s challenge will use the predictive time series tool called ARIMA.  If you don’t have the predictive tools you can find the installer at http://downloads.alteryx.com/downloads.html look for the link to “Predictive tools only”.   The predictive tools in Alteryx execute the analytics in an open source application called ‘R’, the advantage of using Alteryx vs. R is that Alteryx provides a straight-forward user interface and eliminates the need to program directly in the R language.  If you want to read more about what is happening under the hood, here is a link to the Wiki on ARIMA. https://en.wikipedia.org/wiki/Autoregressive_integrated_moving_average   The use case:  A retailer would like to forecast how many units of a particular product will be purchased from their locations based on a historical trend.   The source data contains weekly data for 2012 and 2013 details how many units have been moved. Some of the data, however, is populated with NULL values. For the NULL values, please assign the monthly average. If the monthly average is also NULL, assign the annual average.   Objective:  Forecast the number of units that will be sold in the six weeks following the available data. Have fun! ... View more

The link to last week’s challenge (challenge #22) is HERE.    Restructuring poorly formatted data is one of the most common Alteryx use cases.  For this challenge we will attempt to straighten out some Very poorly formatted data that is representative of an actual customer request.   The use case: A CPG company is having difficulty managing its data for analytics. The data they receive via an excel spreadsheet contains empty rows and misaligned fields.   The objective:  reformat the data in order to enable the analytics team to spend less time staging the data and more time doing analytics.   Update: As of 9/26/19, the start and solution file to this challenge have been updated.  Your solution will not match those posted by our Community members prior to this date.  ... View more