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...
Hi Maveryx,
A solution to last week’s challenge can be found here.
This week, we are diving deep into the realms of Math and Spatial tools by tackling the creation of Sierpinski’s triangle fractal. This challenge, designed by Roland van Leeuwen @RWvanLeeuwen, is an Expert-level task. If you are preparing for certification and plan to attempt an exam during Inspire, it is an excellent opportunity to hone your skills. Thank you, Roland, for crafting this challenge!
What is a Sierpinski triangle?
A Sierpinski triangle is a fractal shape composed of smaller triangles, each a scaled-down replica of the whole. It is created by repeatedly dividing an equilateral triangle into smaller triangles and removing the middle triangle at each iteration. This process results in a geometric pattern that exhibits self-similarity at different scales, forming a visually striking and intricate triangle-based fractal.
(This definition is sourced from https://en.wikipedia.org/wiki/Sierpi%C5%84ski_triangle.)
The provided input consists of the of latitude, longitude, and corners a, b, and c. (The corners are used to determine each point of the triangle.) Your output triangle will look like this:
For this challenge, we are providing additional guidance to simplify the tasks and help you build your Sierpinski’s triangle.
To construct a fractal triangle, follow these steps:
Find the corners (points a, b, and c), and any random point within the triangle as a starting point.
Select one of the corners of the triangle and form a line from the point to the corner.
The center point of the line created is the one we will iterate with.
Using the center point of the created line, pick another random corner, draw a line, and find its center.
Repeat steps 2 to 4 for 100 iterations.
Map all points as green diamonds and the first random centroid as black.
By repeating these steps, a fractal should appear in the shape of Sierpinski's triangle!
If you need a refresher on how to build an iterative macro or create spatial objects, review these lessons in Academy to gear up:
Creating Spatial Objects
Creating an Iterative Macro
Good luck!
... View more
A solution to last week's challenge can be found here!
This week's challenge was submitted by @kelly_gilbert - thank you for your contribution!
Challengers, get ready to have some fun with this one! And, with various levels of difficulty built into this challenge, there's something for everyone!
Your challenge this week is to build a Bingo Card! This challenge uses events/observations from a baseball game, but you can customize this input for anything from traditional numbers to things you might see at Thanksgiving Dinner. Enjoy!
Source: GIPHY
... View more
Hello, my fellow solvers,
A solution to last week’s challenge can be found here.
It's October, which means another fresh month to dive into the world of learning and problem-solving with Alteryx!
This month is special because we are running a series of four challenges that we selected from a list we've received as a part of our Weekly Challenge User Group October Takeover event. For our first challenge, we chose one received from @gawa, a member of the Tokyo User Group. Thanks, Ippei Nakagawa, for this fantastic contribution!
Most of you are likely familiar with Pokémon, or at the very least, you have come across Pikachu's iconic yellow face at some point! Pokémon are characterized by their unique attributes and moves, grouped in 18 distinct variations known as types. Each Pokémon can be associated with either one or two types. For example, Charmander embodies a singular Type (Fire), whereas Bulbasaur boasts a dual type (Grass and Poison).
For this challenge, you have a comprehensive dataset that contains Pokémon details, including their names, primary type (Type 1), secondary type (Type 2), and additional traits such as speed, generation, and more. Your task is to analyze the types of Pokémon combinations, Type 1 and Type 2, and determine which combinations do not exist in this dataset. For instance, there are no Pokémon in the dataset that have a combination of the Bug and Dark types.
Note: Your output must only include unique combinations, so Type 1: Grass and Type 2: Poison is the same as Type 1: Poison and Type 2: Grass.
Source: https://gist.github.com/armgilles/194bcff35001e7eb53a2a8b441e8b2c6#file-pokemon-csv
... View more
A solution to last week’s challenge can be found here.
Welcome to the Good Ladies weekly challenge!
Five women heist a jewelry store and steal a precious gem in the shape of a ball of yarn.
In the dataset, the 5 women responsible for the heist have been negligent and left clues behind. You are the detective on the case who is looking for these clues in a dataset.
1. Fingerprints on the glass surrounding the gem show fingerprints belonging to someone with the letters "Fled" in their first name or last name.
2. IT Department at the police is able to find that the back door lock password was changed to "ugfsjsh".
3. The vault holding the gem was blown open with "dynamic" dynamite. Found in the ruble is a business card piece. You can make out the first few letters of the word "Bogi"
4. The security guard's witness statement states that he has been vigilant about watching the store. There was only one instance last week when he was distracted by a woman with brunette hair who worked at a wireless store. He remembered later that she'd dropped a handkerchief that had the initials B.K. on it.
5. A slogan was left behind that said, "Those that synergize together can accomplish much and receive the TORPHY."
First, you will have to parse the data.
... View more
The link to the solution for last challenge #34 is HERE. For this challenge let’s practice some data cleansing.
Use Case: There is a series of data cleansing processes we need to do on our data. Please solve each per the instructions.
Objective:
Remove leading zeroes
Trim leading zeroes and/or descriptive text at the end
If the data value ends with ID, remove the ID
If more than 8 chars, remove anything after 8. If only 6, add “SC” to the front.
... View more