Posted by Kisaki Watanabe
Updated: Jan 26, 2020
Job Growth - "Are people getting hired?", "If so, where?"
The main goal of this exploratory data analysis project was to find out if there had been employment growth in the U.S. for the past several years, and if so, particularly in which state we can see the large growth.
Also, by narrowing down the changes by industry, I made it easier to analyze which industry is booming. Additionally, I performed time-series analysis to show the growth by year and enterprise size to analyze if there is a trend of employment growth by enterprise size.
Based on the dataset from Census Bureau, "Statistics of US Business (SUSB) Employment Change Data Tables" was retrieved for the changes from 2010 to 2016.
Each dataset records birth and death of employment and expansion, and contraction of establishment (enteprise count) by industry classification based on 2012 North American Industry Classification System (NAICS) codes.
Heat Map - Industry
Overall, the total number showed the growht of 1.6%.
Some states showed tremendous growth such as Florida.
This heat map by state shows the following industries have the highest average growth:
Arts, Entertainment, and Recreation 3.5%
Finance and Insurance 3%
Educational Services 3%
Mining, Quarrying, and Oil and Gas Extraction -10.7%
Some industries had the concentration of growth in some states (e.g. 23.2% growth in D.C. for Arts, Entertainment, and Recreation), but other industries displayed more general growth at many of states (e.g. Professional, Scientific, and Technical Services)
From 2010 to 2016, there were both ups and downs in the employment and enterprise expansion/birth as shown in the following chart. It is notable that especially in 2010 and 2011, there were decreases in the number of enterprises.
However, from 2012, the changes had been positive changes.
When you select enterprise size, you can see that the smaller the enterprise size is, there is an increasing growth in the employment. It has to be noted that smallest enterprises did not even show negative changes when the enterprises of other sizes suffered the decrease.
The largest enterprise size, companies that employ more than 500 employees, showed slowest growth.
Overall, the numbers from the dataset display positive changes in most of industries over the recent years.
If one is looking for a job, it would be advisable to look for employment at smaller companies. Also, it should be noted that if you are shifting your career towards construction, arts, entertainment and recreation, finance and insurance, or educational services, the chances of employment are relatively high.
The next step of this research project could be to confirm the predicted positive changes based on the next economic census results to be released in next few years or other datasets.
Statistics of US Business (SUSB)
The Business Register is the Census Bureau’s source of information on employer establishments included in the Statistics of U.S. Businesses (SUSB) program. The Business Register is a multi-relational database that contains a record for each known establishment that is located in the United States or Puerto Rico and has employees.
Data Scientist with strong consulting experiences in data analytics/visualization and risk management, serving for industries ranging from social networking service, game, pharmaceutical, media, and advertising. Advanced skills in fraud investigation and trend projection/analysis with tools such as Tableau, Alteryx, and Qlikview. Trained and certified for data science - programming languages (R and Python), statistics, and machine learning.View all articles