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

[myastarling]

Here's my solution!

[JBevan89]

A good challenge.  I do not understand the Yellow icon that others have used, from looking at their Spoilers.  Is it a macro?

[Erin]

Spoiler

[lisahitch95]

Spoiler

I was first confused because the first task filters for approved, the second task does not. But after I figured that out, it all made sense!

[alineruizcampos]

Spoiler

[pilsworth-bulien-com]

My solution:

Spoiler

 

[Carlithian]

Spoiler

[mgaronson]

Spoiler

 Dataset is challenging - multiple companies with same Tax ID. Used Company Name as in solution. Multiple line items, same company - ex: INFOSYS LIMITED submitted under NAICS code 11 (3x), 51 (1x), 54 (4x), Null (1x). Also, mulitple spellings for INFOSYS in Richardson, TX. Q2 wording suggesting a sum, solution used a count. Q2 thought Denials should be included.

[arihant_jain]

Use of Filters and Summarize

Task1:
Step1: Filter out the Fiscal Year 2024 and NotNull Industry

Step2: Summarize on Petitioner Name and Add the total number of initial and continual approvals.

Step3: Sort in descending order and sample the first 10 records.

Task2: 

Step1: Filter out the Fiscal Year 2024 and NotNull Industry

Step2: Summarize on Industry and count the total number of petitioners. 

Step3: Sort in descending order and sample the first 10 records.

[AK_ananthakrishnan]

HI guys, Spoiler alert