Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
The solution to last week's challenge can be found HERE!
Just a note: Santalytics will take over Weekly Challenge the 3 weeks following this challenge. Let me say, it's gonna be exciting (an we secretly have been priming you with some of the more recent challenges)! Stay tuned next week to participate!
This week's challenge is taking advantage of the waning days of November and will bring out one last fall-themed challenge. This particular challenge was conceived, constructed and submitted by the distinguished @NicoleJohnson! Thanks Nicole!
Challenge:
You are promoting a new phone app called PIXL near the T-Mobile campus that tracks the Latitude/Longitude of the photos you take so that you can combine the pictures you've taken with a map of your route. You've given the app to some people in the area so they can test it out, and are tracking various phone data for analysis. Things were going well until about 12:50, when you ordered your favorite drink - a Pumpkin Spice Latte, extra pumpkin, of course - and were just about to sit down at your desk to enjoy your beverage, when you were suddenly pulled away to deal with an emergency logo situation... By the time you made it back 20 minutes later to where you'd left your latte on your desk, your treasured PSL was gone!!! Now you knew people were running all over the area testing out your new app, so you thought perhaps you might be able to use the data you were collecting from the testers to see if anyone in the area had seen your PSL thief...
Using the PIXL Data & image links below, see if you can identify the Pumpkin Spice Latte stealing culprit!!
HINTS: - Data file is structured with some concatenated information: DateTime (in 24-hour format), Phone Number, Latitude & Longitude where picture was taken, and some other qualifiers & delimiters.
- Data will need to be parsed first to find the relevant fields for analysis. - Assume that the thief probably couldn't have been farther than .25 miles from the location of the robbery during the time frame in question. - There will likely be more than one potential thief in the area once you've filtered your results for time & location proximity, so you'll also want to see the images from their PIXL app data in order to narrow down your search!
... View more
Thank you for participating in the Grand Prix challenges last week!
Next week's challenge will be posted during @NicoleJohnson's Inspire Europe Weekly Challenge (10:30AM on Wednesday 10/10)! Finally, those on GMT challengers will finally have first crack at the challenge. Unless @patrick_digan wakes up at 5:30AM Eastern.
Onto this week's challenge!
There are 1000 lockers in a high school with 1000 students. The problem begins with the first student opening all 1000 lockers; the second student closes lockers 2,4,6,8,10 and so on to locker 1000; the third student changes the state (opens lockers closed, closes lockers open) on lockers 3,6,9,12,15 and so on; the fourth student changes the state of lockers 4,8,12,16 and so on. This goes on until every student has had a turn.
When all 1,000 students have finished, which locker doors are open?
... 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
A solution to last week's challenge can be found here. Image Source: https://commons.wikimedia.org/wiki/Category:Paralympic_Games
Let’s dig into the data for the Summer Paralympic Games 2020!
This dataset includes a column “RecordID” that corresponds to the names of the athletes, a column for “NOC” for the countries and a “Discipline” column.
For this challenge, your job is to: - List the participating countries and how many athletes for each country - List of the 5 countries with the most athletes - List the first 5 countries (alphabetic order) with the least athletes (they are more than 5) - List all the countries and disciplines by alphabetic order and, add the athlete count and athlete ID
Have a good week!
... View more
A solution to last week's challenge can be found here!
The Tour de France is one of the most grueling competitions on the planet. Each year, incredibly fit athletes push the limits of human endurance to traverse some 3000+ kilometers (2000 miles) over about a three-week period ON A BIKE. Just finishing the race is an incredible achievement. But what do birds think about all this?
In this challenge, use Designer and data from the 2017 Tour de France to determine how long the race was, as the crow flies. That’s right, calculate how far the race would be for a bird flying all stages of the race.
This solution treated race days that started and ended in the same city as 0 km covered. Travel outside of racing was not included either (i.e. if the destination of one leg did not match the next leg’s origin, that distance was not included.
... View more