Alteryx Academy

A solution to last week’s challenge can be found here!   Taynalysis: Analyzing Taylor Swift Lyrics   Whether you love her or hate her, Taylor Swift is one of the most popular musicians and songwriters of our time and her lyrics have been the source of both criticism and praise. Her lyrics have also been the subject of a wide spectrum of analyses. Get in on the taynalysis by finding the top 10 words she uses in each album and then find out if her transformation from being a country singer to a pop star has affected the repetiveness of her albums.   Can't get enough of Taylor's lyrics? Take this Weekly Challenge up a notch by adding your own levels of analysis and reporting. Check out these analyses for some swifspiration: Text Analysis and Data Visualiztion with Taylor Swift Songs Using Machine Learning to Analyze Taylor Swift's Lyrics How Has Taylor Swift's Word Choice Changed Over Time?                         *Note: As of 3-3-20 we uploaded a new start file. We realized the way we handled some grouping options and contractions created the discrepancy some people were experiencing. ... View more

A solution to last week’s challenge can be found here. image source: https://en.wikipedia.org/wiki/States_of_Brazil   Did you know that Brazil is the largest country in South America? “Super legal!” you say to yourself em Português. Brazil is also an incredibly diverse country with many unique geographic regions. That’s why it’s a good idea to bring a map.   Unfortunately, the map I found is from 1920 and doesn’t show all 27 states (26 and the Federal District). Your task is to use the supplied data to update the map from the 22 existing states to include all 27.   Additionally, the capital moved from Rio de Janeiro to Brasilia in 1960, so the updated state of Rio de Janeiro should regain the land occupied by the Federal District in the 1920 map.   Boa Sorte! ... View more

Here is this week’s challenge , I would like to thank everyone for playing along and for your feedback. The link to the solution for last challenge  #10 is HERE.    The use case:   A manufacturing company receives customer complaint data on a daily basis from their call centers about the medical parts they distribute to their customers. The company monitors these comments to understand which parts and part groups have the highest complaint rate. This helps the company prioritize which parts to focus on from a development standpoint.   In this exercise, take the customer complaint data and identify which bucket the complaint falls within. The complaint can fall into multiple buckets and needs to be flagged as these complaints take highest priority. Create an aggregate view of which buckets or bucket pairings have the highest # of complaints.   This is only a subset of data so all records will not be assigned to buckets and can be ignored.   Update: As of 9/26/19, this challenge start file and solution were modified.  Your solution will not match those posted by other Community members prior to this date.  ... View more

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

The solution to last week's challenge is HERE.   This week we will be offering our third ever challenge on converting strings to dates. Sometimes these may be simple, but every once in awhile, we come across those source systems that drop things in a format that are better understood by machine than by a human. In this week's challenge, convert the string to a date using the following rules:   1) The Input contains dates formatted as year, month, day where the first character details if the year begins with 19 or 20. 2) It is 19 when the first character is 0 and 20 when the character is 1. 3) The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.   Example: 1040202 should become 2004-02-02.   ... View more