Tableau: Data Visualization of Data Scientist Job Listings

Dataset: Data Science Job Posting on Glassdoor

The data was scrapped from glassdoor's website. There are two sets of data: Cleaned, Uncleaned.

Source:https://www.kaggle.com/datasets/rashikrahmanpritom/data-science-job-posting-on-glassdoor

Insights:

• The location with the most Data Scientist listings is California

• Python is the most required skill by far

• Data Science has the Highest Average salary excluding Managerial and directorial positions.

• Python and Tableau is the most required skill for Data Analytics

This visualization also shows data on other job titles: Data Engineer, Data Analyst, Manager(DA or DS), Data Scientist, and directorial (DA or DS)

Story:

Data Cleaning:

Of course, first we have to clean the data so Tableau can recognize and parse the data correctly. The most significant thing I did was clean the location data using

=SUBSTITUTE to keep the city name only.

This is one of the biggest obstacles to creating a digestible geographical chart.

Making the geographical chart

Im making the geo chart first because it tends to present the most challenges. And the biggest challenge here was making sure tableau detected the location data correctly.

Afterward, it was only a matter of creating Hierarchies (middle left of picture) to create a heatmap.

Calculated Fields:

The next question I wanted to answer was what skills are the most sought after. I did that by creating calculated fields to produce percentage data on how many times that skill showed up in the data for a certain job title.

Min and Max Average Salary:

Next, I want to answer how lucrative the job was, to do so I calculated the max and min average salary from the data. Then I used the bar chart with a reference line showing the min average salary.

Dashboard:

To create the dashboard I gathered the previous charts together to showcase all the important data. The dropdown list in the top right allows you to select which job title you want data on.

As shown here you can also see data on data analyst job listings, Data Engineer, or machine learning engineer.

Click Here to interact with the dashboard