Alteryx Academy

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

The link to last week’s challenge (challenge #40) is HERE   This week’s exercise looks at using Alteryx to calculate the number of weekdays during each pay period.  Employees get paid twice monthly so the number of weekend days within a period can vary.   Objective:  For each month and pay period, calculate the # of weekdays that make up the pay period (i.e. exclude weekend days from the calculation). ... View more

Far more than just a window to your data, the Browse Tool has a catalog of features to best view, investigate, and copy/save data at any checkpoint you place it.  That introspection to your data anywhere in your blending gives valuable feedback that often speeds workflow development and makes it easier to learn tools by readily visualizing their transforms. Be equipped, and browse through the catalog of useful applications below! ... View more

Aggregate Consumer Purchases: For this week’s exercise we will look at customer purchase behavior to decide if we should offer a “Meal Deal” that would add a side and drink to a purchase of pizza or a burger. The incoming data is larger than usual for these exercises so I have packaged the workflow as an Alteryx Package. The link to the solution for last challenge #7 is HERE.   This week’s Objective: In order to decide if we should start including a new "Meal Deal" on our menu we want to study the potential impact on recent transactions. Please identify the number and percentage of orders since July 1, 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.   Summary of Data: Point of Sale data includes the ticket level information, and the lookup table categorizes items into higher level food categories.   Hint: Don't forget to join to the lookup table and filter by date.   As always we look forward to your feedback and suggestions!   UPDATE 01/18/2016: The solution has been uploaded.   UPDATE 12/28/2016: The challenge, text and solution have been updated. ... View more

The link to last week’s challenge (exercise #54) is HERE.   2013 Alteryx Grand Prix Lap 1 of 3:   As the Alteryx User groups start the process of selecting their competitors for the 2017 Alteryx Grand Prix I thought it would be fun to bring back an old Grand Prix as the weekly challenge.  Note the workflow is in a vertical orientation.  Vertical was the only orientation Alteryx had in 2013.  Now, we can toggle between vertical and horizontal configurations by clicking on the white space of the canvas, going to the configuration window, and choosing a layout direction.   Want to have even more fun, go to the about box under the help menu and double click the little Colorado flag for an Easter egg that will render the tools the way they looked in 2013.   Have fun solving and remember the competitors were racing each other and the clock!  See how fast you can solve this.  OH, and there was NO Imputation tool in 2013... ... View more