Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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
12 - Quasar
Spoiler
MilindG_0-1679928769518.png

 

Christina_H
14 - Magnetar

Nice and easy this week

Spoiler
Christina_H_1-1679928768768.png

 

Flo_P
8 - Asteroid
Spoiler
Alteryx, It's fantastic!
Flo_P_0-1679928962315.png

 

benjimoser
9 - Comet

My Solution

Spoiler
benjimoser_0-1679929092245.png

 

nSpire
8 - Asteroid
Spoiler
nSpire_0-1679929240784.pngnSpire_2-1679929284242.png

 


 

PhilipMannering
16 - Nebula
16 - Nebula

Solution Attached.

 

Spoiler
PhilipMannering_0-1679929850728.png

Python Tool...

Spoiler
PhilipMannering_0-1679930640306.png

 

 

gaoa
11 - Bolide
Spoiler
gaoa_0-1679929895719.png 
Clifford_Coon
11 - Bolide

My Solution:

Spoiler
Annotation 2023-03-27 111142.jpg

ggruccio
ACE Emeritus
ACE Emeritus

Solution assumes the NULL years are between 1959 and 2020

 

Spoiler
ggruccio_0-1679930184336.png