Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #357: College Majors in High Demand

AYXAcademy
Alteryx
Alteryx

image_357.png

A solution to last week's challenge can be found here.

 

To solve this week's challenge, use Designer Cloud or Designer Desktop.

This challenge comes to us from @randall_king 

 

Haven't heard about Designer Cloud yet? Watch a demo.

In this weekly challenge, you need to clean and format data; sort data; and create a calculated field.

 

Your high school-aged child is planning on attending college after graduation. They do not know what they should choose as a major, so being the great parent you are, you want to steer them in the right direction.

Based on this dataset, determine which majors have an employment rate equal to or higher than 80%. If you suggest these areas of study to your child, you may have the best chance of making sure they don't move back into your house after college graduation!


For this challenge you should:

1. Split the data into columns on the comma delimiter.
2. Convert the first row of data into a header.
3. Assign appropriate data types to numeric columns.
4. Create a column that calculates the percent (rounded up to the nearest whole number) of students who are employed. Use the Employed and Total columns for your calculation.
5. Sort the data in descending order.
6. Filter the majors with an employment percentage equal to or higher than 80%.

 

Data Source: www.kaggle.com/datasets/tunguz/college-majors

 

ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1675698342483.png

 

FrederikE
13 - Pulsar
Spoiler
FrederikE_0-1675698481530.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1675698501566.png

 

Flo_P
9 - Comet
Spoiler
Straightforward
Flo_P_0-1675698737893.png

 

WesCannon
Alteryx
Alteryx

Completed using Designer Cloud (Trifacta Experience)! Recipe included.

 

Spoiler
WesCannon_0-1675699297243.png

 

Watermark
12 - Quasar
12 - Quasar

I missed the part of the direction that you round 'up'.   That cost a few min getting it to equal 35 results.

Spoiler
MT Solution 357.jpg

 

braveraj
11 - Bolide

Now the question is what percent of people are working in the specialized field of study? I'm definitely not.

Spoiler
braveraj_0-1675699746930.png

 

François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1675700295484.png

 

binuacs
21 - Polaris
Spoiler
binuacs_0-1675700333490.png