A full interactive and dynamic Power BI dashboard for analysing the top 5 most common data related jobs in the job market.

Overview

The dashboard is composed of 4 pages:

The Home page

The Jobs page

The Skills page

The Companies page

Home Page

From this page you can navigate to the other 3 pages using the buttons above "Jobs", "Skills" and "Company"

Jobs Page

This page gives a full overview about the jobs metrics with a full set of filters to answer all the questions needed

Some of the questions it answers:

1- What is the average years of experience for each position level?

2- What is the average salary for each position level?

3- What is the average salary for each for each Job type?

4- What is the trend of number of job postings over time?

5- What is the most requested job position level?

6- What is the most requested job type?

7- What is the order of the top 5 data jobs?

8- What are the skills needed for the top 5 data jobs?

9- What is the number of job postings for each job title?

10- What is the number of job postings for each job position level?

You can open the filters using the Filter Panel button

You can navigate to Home page using the Home button

Skills Page

This page gives a full overview about the skills metrics with a full set of filters to answer all the questions needed

Some of the questions it answers:

1- What are the most popular skills?

2- What is the count of the most popular skills?

3- What is the trend of the top skills over time?

4- What is the percentage of appearance of each job skill?

5- What is the number of jobs in which each skill was mentioned?

6- What is the distribution of skills for each job title?

You can open the filters using the Filter Panel button

You can navigate to Home page using the Home button

Companies Page

This page gives a full overview about the companies metrics with a full set of filters to answer all the questions needed

Some of the questions it answers:

1- What is the average number of jobs for each company industry?

2- What is the average years of experience for each company industry?

3- What is the average salary for each company industry?

4- What is the most requested job position level for each company industry?

5- What is number of jobs for each company size?

6- What is average years of experience for each company size?

7- What is the average salary for each company size?

8- What is the most requested job for each company industry?

9- What is the most requested job for each company size?

10- What is the distribution of jobs according to company locations?

You can open the filters using the Filter Panel button

You can navigate to Home page using the Home button

Filter Panel

A full set of filters that fulfills all your needs.

The same is available for all the pages.

Data Schema

I used a star schema to store and process the data efficiently.