Job market analysis in Tableau

Case Study: Analyzing Job Market Data in Tableau

Shivali Malhotra

Business Analyst and Musician

What is a case study?

  • Apply Tableau skills
  • Combine previously learned concepts
  • Solve an example real-world problem

$$

Prerequisite courses:

  • Introduction to Tableau
  • Analyzing Data in Tableau
  • Creating Dashboards in Tableau

This image shows a few infographics to depict a presentation or case study

Case Study: Analyzing Job Market Data in Tableau

Data analysis process with Tableau

Data Analysis Process Overall: This image is representative of the 5 stages of a Data Analytics process. stage 1 is the Data Check and Exploration Stage, stage 2 is the Analysis and Visualization stage, and stage 3 encompasses Dashboards. Stage 4, communicating insights, is beyond the scope.

Case Study: Analyzing Job Market Data in Tableau

Data analysis process with Tableau

Data Analysis Process Part 1: This image demonstrates stage 1 of the data analytics process: Data Check and Exploration

  • Perform an integrity check of the dataset
  • Exploratory data analysis (EDA)
  • Apply business questions to start investigating the problem
Case Study: Analyzing Job Market Data in Tableau

Data analysis process with Tableau

Data Analysis Process Part 2: This image demonstrates stage 2 of the data analytics process: Analysis and Visualisation

  • Various visualization types
  • Calculated fields
Case Study: Analyzing Job Market Data in Tableau

Data analysis process with Tableau

Data Analysis Process Part 3: This image demonstrates stage 3 of the data analytics process: Dashboard Creation

  • Publishing dashboards is out of scope
Case Study: Analyzing Job Market Data in Tableau

Problem to solve

Investigate market trends for data science roles

  • The context: An employee recruiting firm, DataSearch, needs to uncover job trends
  • The dataset: A fictitious collection of key details from job postings industry
  • The task: Discover trends in jobs and skills within the data science

$$ Job Market: Candidates holding up CVs

Case Study: Analyzing Job Market Data in Tableau

The data

Key characteristics

  • Key details from job postings from 2017 to 2021 for jobs in the Data and Analytics industry
  • Each row correlates to a specific job posting in time
  • One table containing 19 columns

Job Postings Flyer

Case Study: Analyzing Job Market Data in Tableau

The data

Qualitative Columns

Column name Description
Job Posting Id The unique ID that identifies a job
Job Title Data Analyst, Data Scientist, ...
Job Position Type Full-time, Contract
Job Position Level Internship, Entry-level, Executive, ...
Job Skills ['tableau, excel, sql'], ['python', 'databases'], ...
... ...
Case Study: Analyzing Job Market Data in Tableau

The data

Quantitative Columns

Column name Description
Job Posting Date The date of the job posting
Years of Experience Number of years minimum experience
Minimum Pay Minimum expected salary
Maximum Pay Maximum expected salary
Number of Applicants Number of applicants in first 24 hours of job posting
... ...
Case Study: Analyzing Job Market Data in Tableau

Final deliverable

Final Dashboard: This is a snapshot of the final deliverable for this case study

Case Study: Analyzing Job Market Data in Tableau

Let's practice!

Case Study: Analyzing Job Market Data in Tableau

Preparing Video For Download...