Views provided by UsageCounts
Abstract The H1B is an employment-based visa category for temporary foreign workers in the United States. Every year, the US immigration department receives over 200,000 petitions and selects 85,000 applications through a random process and the U.S. employer must submit a petition for an H1B visa to the US immigration department. This is the most common visa status applied to international students once they complete college or higher education and begin working in a full-time position. The project provides essential information on job titles, preferred regions of settlement, foreign applicants and employers' trends for H1B visa application. According to locations, employers, job titles and salary range make up most of the H1B petitions, so different visualization utilizing tools will be used in order to analyze and interpreted in relation to the trends of the H1B visa to provide a recommendation to the applicant. This report is the base of the project for Visualization of Complex Data class at the George Washington University, some examples in this project has an analysis for the different relevant variables (Case Status, Employer Name, SOC name, Job Title, Prevailing Wage, Worksite, and Latitude and Longitude information) from Kaggle and Office of Foreign Labor Certification(OFLC) in order to see the H1B visa changes in the past several decades. Keywords: H1B visa, Data Analysis, Visualization of Complex Data, HTML, JavaScript, CSS, Tableau, D3.js Dataset The dataset contains 10 columns and covers a total of 3 million records spanning from 2011-2016. The relevant columns in the dataset include case status, employer name, SOC name, jobe title, full time position, prevailing wage, year, worksite, and latitude and longitude information. Link to dataset : https://www.kaggle.com/nsharan/h-1b-visa Link to dataset(FY2017): https://www.foreignlaborcert.doleta.gov/performancedata.cfm Running the code Open Index.html Data Processing Doing some data preprocessing to transform the raw data into an understandable format. Find and combine any other external datasets to enrich the analysis such as dataset of FY2017. To make appropriated Visualizations, variables should be Developed and compiled into visualization programs. Draw a geo map and scatter plot to compare the fastest growth in fixed value and in percentages. Extract some aspects and analyze the changes in employers’ preference as well as forecasts for the future trends. Visualizations Combo chart: this chart shows the overall volume of receipts and approvals rate. Scatter plot: scatter plot shows the beneficiary country of birth. Geo map: this map shows All States of H1B petitions filed. Line chart: this chart shows top10 states of H1B petitions filed. Pie chart: this chart shows comparison of Education level and occupations for petitions FY2011 vs FY2017. Tree map: tree map shows overall top employers who submit the greatest number of applications. Side-by-side bar chart: this chart shows overall comparison of Data Scientist and Data Analyst. Highlight table: this table shows mean wage of a Data Scientist and Data Analyst with case status certified. Bubble chart: this chart shows top10 companies for Data Scientist and Data Analyst. Related Research The H-1B Visa Debate, Explained - Harvard Business Review https://hbr.org/2017/05/the-h-1b-visa-debate-explained Foreign Labor Certification Data Center https://www.foreignlaborcert.doleta.gov Key facts about the U.S. H-1B visa program http://www.pewresearch.org/fact-tank/2017/04/27/key-facts-about-the-u-s-h-1b-visa-program/ H1B visa News and Updates from The Economic Times https://economictimes.indiatimes.com/topic/H1B-visa/news H-1B visa - Wikipedia https://en.wikipedia.org/wiki/H-1B_visa Key Findings From the analysis, the government is cutting down the number of approvals for H1B on 2017. In the past decade, due to the nature of demand for high-skilled workers, visa holders have clustered in STEM fields and come mostly from countries in Asia such as China and India. Technical Jobs fill up the majority of Top 10 Jobs among foreign workers such as Computer Systems Analyst and Software Developers. The employers located in the metro areas thrive to find foreign workforce who can fill the technical position that they have in their organization. States like California, New York, Washington, New Jersey, Massachusetts, Illinois, and Texas are the prime location for foreign workers and provide many job opportunities. Top Companies such Infosys, Tata, IBM India that submit most H1B Visa Applications are companies based in India associated with software and IT services. Data Scientist position has experienced an exponential growth in terms of H1B visa applications and jobs are clustered in West region with the highest number. Visualization utilizing programs HTML, JavaScript, CSS, D3.js, Google API, Python, R, and Tableau
H1B visa, Data Analysis, HTML, JavaScript, Tableau, D3.js, Visualization of Complex Data, CSS
H1B visa, Data Analysis, HTML, JavaScript, Tableau, D3.js, Visualization of Complex Data, CSS
| selected citations These citations are derived from selected sources. This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | 0 | |
| popularity This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network. | Average | |
| influence This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | Average | |
| impulse This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network. | Average |
| views | 6 |

Views provided by UsageCounts