Alteryx Academy

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Douglas Perez, @dougperez . Thank you, Douglas, for your submission!   A company recently hosted an internal Alteryx certification event to promote professional growth and upskilling across the organization. Each participant was assigned to a team, and throughout the event, employees earned various professional certifications.   Now that the event has concluded, it’s time to analyze the results and determine which team came out on top!   You’ve been provided with two datasets: A certifications dataset containing certification records, each with its status (Expires or Expired) and the date. A team mapping dataset linking each participant to their respective team.   Analyze the results and rank the teams based on the number of valid certifications earned by their members. Follow the rules below:   Only include certifications that are currently valid (status is Expires). Focus only on certifications with names that include Alteryx Designer or Server. Exclude any certifications that mention Cloud or Trifacta. Aggregate the results by team and rank them from highest to lowest based on the number of valid certifications.   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   Source: Dataset generated by ChatGPT.   Download Start File ... View more

The solution to last week's challenge can be found HERE.    Determine the items of clothing that have the highest average rating. In your analysis, include 1) only items of clothing that have at least 10 positive feedback reviews and 2) the five highest rated clothing items from each class.   The original data and its metadata can be found here.        ... View more

A solution to last week’s challenge can be found here.   The Eurovision Song contest or Eurovision is an annual song competition in Europe.    During a live show, contestants representing European countries, sing a song and receive points. The contestant with the most points wins. In 1974, the Swedish group ABBA became a household name in Europe by winning this contest with the song "Waterloo".   The dataset for this challenge provides information about the Eurovision from 1975 to 2019. The column “Edition” contains a date followed by one or two initials “f” or “fs”. For this challenge, use the values followed by “f”.   Use the dataset to: - Find out which country has won the contest from 1975 to 2019 - List by descending order the countries who have won the most time between these dates   Hint A country cannot give points to its representative. Make sure to take this rule into consideration. Mistakes happen in datasets. ... View more

A solution to last week's Challenge can be found here!    A big thanks to those of you that joined us last week at Inspire for the Weekly Challenge session!  It was so much fun solving with you all!    This week, we're identifying the most popular baby names that were registered between the years of 1880 and 2017.  Given the provided dataset, determine the most popular names for Males and Females for each available year.  The column "Field_1" contains three concatenated values: the name, the associated gender (Male or Female) and the number of occurrences that the name appeared in birth records.   The column "FileName" contains the name of the file in which the record is found; the data was read in from a zip file that contained text files for each year (1880-2017) of records.      ... View more

As we continue to theme our weekly challenges around Women History Month, know that we have something special for one of our participants: we will be giving away a book called: 'Good Night Stories for Rebel Girls'  Keep participating and have more chances to win!   This week's challenge background: Henrietta Lacks Henrietta Lacks has possibly one of the most famous contributions to science, yet remains one of most unacknowledged women of the last century. For many of us, her impact has been felt by ourselves, our family or our friends. Henrietta Lacks was born in Roanoke Virginia (US) and was diagnosed with cervical cancer late in her life. To help diagnose her, some of the of the tumor’s cells were harvested for further investigation and diagnosis in 1951. Researchers came to find that these cells were far more resilient than other cells used for research in the laboratory. While most cells divide a set number of times outside the human body and perish shortly thereafter, Lacks’s cells, given favorable conditions, split seemingly infinitely and were dubbed the ‘immortal’ cells. For researchers, this discovery was a boon because a large amount of their time was designated to keeping their sample cells for testing alive. Lacks’s cells multiplied quickly and hardly required any sort of nurturing. Because of this, Lacks’s cells (named the “HeLa cell” – shorthand for her name), have been the go forward cells used in testing and research - even today. It is estimated that over 11 tons of her cells have been produced, led to 11,000 medical patents and played a crucial role in learning about how viruses work, the human genome, and played a key role development of the polio vaccine. The National Institute of Health declared the HeLa cell to be ‘literally the foundation of modern medical science’. Despite the triumph of science with the use of the HeLa cells, there is a cloud of ethical complexity surrounding the cell. The cells were obtained without informed consent and were cloned and sold unbeknownst to the Lacks family. It wasn’t until 1973 the family learned that their family’s genetic materials were being used. In addition to this, the family had not been compensated for the commercialization of their family’s genetic code; something they surely could have benefited from as they family could not even afford health care. It was not until 2013 that the National Institute of Health, in conjunction with the Lacks family, began to require scientists to get permission from the government agency to have access to the genetic blueprint and use of the HeLa Cell. Despite the controversy, Henrietta Lacks will forever be remembered as the woman who ushered in the era of modern medical science.   This week’s challenge is themed around the behavior of the HeLa cell: You are a laboratory researcher who has gained access to the HeLa cell through the consent of the NIH. In return, you were given a 1,000 cell inoculation dose. To grow a sufficient sample, the cells must be placed in a solution and allowed to multiply. Once the cells reach a certain density in the solution, they will cease to multiply. The cells divide every 23 hours, and reach a maximum density of 400,000 cells per 1mL (milliliter). If you have a 30mL solution and place the 1,000 cells into the solution, what will be the time range be between when the max density will be reached? ... View more