This project aims to help students major in Applied Data Science and Business Analytics to better understand what skills they should develop throughout their academic careers, what experiences they should highlight on their resumes, and which areas will offer them better chances to land a job.

The handshake dataset consolidates Handshake job data from five excel files. The five Handshake job excel files were originally created by the Career Center at Whitman School of Management and sent out to all Whitman students via email. Upon the completion of data consolidation, I have a Handshake dataset ( Handshake_Internship_Job.xlsx) that contains job information on various types of jobs including Business Analysis and Data Scientists. The dataset with a total of 11 columns and 6359 columns.

• Q1: Where are the jobs come from?
• Q2: What is the number of jobs in a city or cities in different countries?

• Q1: What is the number of jobs for each job type? What are the percentages?

• Q1: What is the number of jobs for each employment type? What are the percentages?

• Q1: What are the salary types and their percentage?
• Q2: What is the number of jobs for each level of salary type within employment type for each job type?

• Q1: How likely it is to find an employer that will accept OPT/CPT candidates?
• Q2: Where are the employers that accept OPT/CPT candidates in terms of location and industry? How many employers are there?

• Q1: How likely it is to find an employer that is willing to sponsor a candidate?
• Q2: Which employers are willing to accept OPT/CPT candidates and provide sponsorship?

• Q1: What is the number of jobs expires in each weekday in different months?

Please use the below link to view the notebook if you are receiving the 'Sorry, soemthing went wrong. Reload?' error message. https://nbviewer.jupyter.org/github/Jieer334/Job-Analysis-Handshake/blob/main/Job%20analysis%20Handshake.ipynb