Challenge #453: Unlock H-1B Visa Program Trends in 2024

[stataltgee]

fun challenge 😁

[Zhengyi]

nice challenge.

[Daniel_Homola]

Easy!

[KarlHood]

Solved

[RebekaMazuchova]

:)

[iihhii]

My solution 

Spoiler

 

[Jonathon-Sheppard]

My solution.

The questions weren't exactly that clear. Task 2 mentions we should find the top 10 industries with the highest demand - with 'demand' being defined as number of total petitions submitted. I calculated the total number of submissions per record, but couldn't figure out why my results were different to the output data. 

When I looked, it seems as though the summarise tool in the solution file summed the number of times each industry appeared on a record, neglecting the number of applications on each record...? 

[AronasZilys]

Spoiler

[BS_THE_ANALYST]

Very interesting! I may do a similar thing for Australia if it's available 👀

Spoiler

Time Taken: 04:45

 

[afalade]

Solved