Alteryx Academy

 Thanks for your participation so far. If you would like to see the solution to last week's challenge, check it out HERE. This week we will be using the download tool to pull some public employment data from the Bureau of Labor Statistics.  Once downloaded the data needs to parsed into the required format to prepare it for use.  I have also provided a snapshot of the input data if you have firewall issues accessing the data from the URL, you won't need it if you use the download tool.   If your results differ slightly in row content, the data may have changed at the URL…   Use Case:  The input data from the Bureau of Labor Statistics (http://www.bls.gov/web/empsit/compaes.txt) needs to be downloaded and formatted for analytics.  The data set details employee statistics that are adjusted seasonally.   Objective: Download the data from the URL then parse it to match the output shown in the sample output. ... View more

Last week's solution can be found HERE!   Create a macro that generates a table with the date and the day of the week for all dates from a given starting date to today. The user should be able to select the start date. Bonus 1: Add a selection that will allow the macro user to select whether or not to include weekends. Bonus 2: Create a duplicate macro that's encrypted so that no changes can be made. Leave the first macro on your canvas unencrypted so other challenge-takers can observe how your macro was built. ... View more

  Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by [First and Last Name], [@Community User Name]. Thank you, [First Name] for your submission!   In this week’s challenge, you apply your skills with formulas, macros, and analytic apps to simulate a basic probability experiment: flipping a coin. This challenge helps you practice building iterative logic and user-driven apps in Alteryx Designer.   Here are the steps you need to follow to build the flip-coin app:   Create an Iterative Macro (`Coin Flip Macro.yxmc`) that repeats the coin flip simulation for a specified number of times. This macro should: Initialize with a Text Input containing iterations, head count and tail count. Update the counts on each iteration. Use a condition to stop once the iteration count reaches the user-specified total. Once the macro is created, build the analytic app that does the following: Prompts the user with a Text Box question: "How Many Coin Flips?" Passes this input into the macro to determine the number of simulations it runs. Displays how many times "Heads" and "Tails" occurred.   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Download Start File ... View more

Last week's solution can be found here.   This week's solution is working to permute some data!  This challenge is derived from an question asked by @iellingsonbg, and was solved by the illustrious @MarqueeCrew. @MarqueeCrew then messaged us letting us know a great challenge was available that we should tackle! If you ever have a great challenge of your own or see another problem around the Community worth tackling, let us know!   As for the challenge itself, we are presented the options (tools). What we would like to do is determine all the combinations these tools can exist in an 'on/off' state. For three options we can see the following combinations. Note that the end result data is not formatted this way, but simple formatted here for ease of understanding. Browse Input Output Off Off Off Off Off On Off On Off Off On On On Off Off On Off On On On Off On On On   If you want to take a more difficult route, try to setup your workflow where it would be dynamic to handle more than three tool options and more toggle options than on/off! ... View more

A solution to last week’s challenge can be found here.   Because having a reliable electricity source is important to many people, we tend to notice when the power goes out! While we might expect service outages during severe weather events and other natural disasters, sometimes the culprit is... fluffier and cuter, or slithers.   Using the provided dataset, find out: • How many outage events can we attribute to animals? List the culprits with the count of events in descending order.   Hint Use the animals listed in the "Operative" field and information from the "Article Title" field to replace values of "Animal" with the actual animals.   Note All animal types present in this dataset are included in the "Operative" column. ... View more