One Dashboard Shows You Why San Francisco isn’t the #1 hot metropolitan for internet industry in America.
Challenge: Visualizing the Indeed.com dataset
Skills used: data wrangling, spatial analysis, data visualization, use/join outside data
Key Software: R, Tableau
If I want to work in the internet & software industry, where should I land my job?
This blog post is a description for the winner presentation of Duke DataFest 2018. Indeed.com has provided us with a rich dataset of economic opportunity in the form of jobs, across America. (n = 1.6M)
Using this dataset we have made a unique model that when visualized provides key insights into American industry and accessibility for any potential job seeker.
In an age where it is very easy to move location, we believe our visualization could be of great value to make future job seekers wonder where in the US they might the best fit for their talents.
Our first and main visualization shows US metropolitan areas and the unique concentration of industries that each has and lacks. The second visualization reveals a strong inverse correlation between the number of local clicks each job gets and its education requirements.
To create this dashboard, here’s our workflow.
~ spatial-join individual cities into metro(politan) area, using Census Bureau shapefiles
~ join metro population data with our dataset
~ calculate industry favorability score for each city
Using our model we found non traditional areas with many opportunities for different industries.
While these locations we have identified currently have a large number of opportunities in their respective industries. It is important to remember that the health of the local economy as a whole and the ability for anybody to access these jobs is not as exciting.
Additional analysis we have performed has found that there is a strong inverse correlation between the number of local job clicks a job is getting and the educational requirement that the job has.
This graph shows that areas that have many jobs with low education requirements are receiving the highest number of local clicks in proportion to total clicks. This means that many of the areas we have recommended, as they are more idiosyncratic, are likely to have higher inequalities between the kinds of jobs available and whether locals or outsiders are applying for and winning them.
The blue areas are those which require the least amount of educational attainment and receive the largest amount of local clicks. Areas in red require the highest degree of educational attainment and receive the smallest amount of local clicks.
From this interactive map, we painted a vibrant story of America workforce. Whether it’s the policy maker in the nation’s capital, the blue collars in the port side along the Mississippi river, or the news anchormen projecting in media speaking out the voice of America, the story they told, the sweat they had, and the joy they earned, painted drops and veins on the canvas of American dream, a story we share throughout generations
