Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #364: Career-Minded Barbie

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.image_364.png

 

To solve this week’s challenge, use Designer Desktop, Designer Cloud, Designer Experience, or Designer Cloud, Trifacta Classic.

 

Over the years, Barbie, the doll made by Mattel, has had a lot of different jobs! She has been super busy. Did you know she ran for President of the United States 10 times? Quite impressive!

 

This dataset complies a list of Barbies that were released from 1959 through 2020. It includes the career name and type of career for that Barbie.

 

For this challenge, first determine which career Barbie had more than twice between the years 2017 and 2019.

Next, calculate by job type how many different types of jobs Barbie held over the years from 1959 through 2020, including the percentage of each.

 

Data Source: https://data.world/judkacag/barbies-careers-1959-2020 

MilindG
Quasar
Révélation
MilindG_0-1679928769518.png

 

Christina_H
Magnétar

Nice and easy this week

Révélation
Christina_H_1-1679928768768.png

 

Flo_P
Comète
Révélation
Alteryx, It's fantastic!
Flo_P_0-1679928962315.png

 

benjimoser
Comète

My Solution

Révélation
benjimoser_0-1679929092245.png

 

nSpire
Boule de feu
Révélation
nSpire_0-1679929240784.pngnSpire_2-1679929284242.png

 


 

PhilipMannering
16 - Nebula
16 - Nebula

Solution Attached.

 

Révélation
PhilipMannering_0-1679929850728.png

Python Tool...

Révélation
PhilipMannering_0-1679930640306.png

 

 

gaoa
Bolide
Révélation
gaoa_0-1679929895719.png 
Clifford_Coon
Bolide

My Solution:

Révélation
Annotation 2023-03-27 111142.jpg

ggruccio
ACE Emeritus
ACE Emeritus

Solution assumes the NULL years are between 1959 and 2020

 

Révélation
ggruccio_0-1679930184336.png