You'll start this Power BI case study by importing and cleaning the job posting dataset using Power Query. Once you’ve done this, it’s time to roll up your sleeves and do some initial data exploration.

Job market analysis with Power BI

Options

In Scope

Out of scope

EDA questions to ask

Data import with Power Query

Initial EDA with Power Query

Job posting trend analysis

Data cleanup of job titles

Effect of years experience on salary

True

False

Trends found with EDA

Exploratory Analysis

The DataSearch team still needs answers. Luckily, they have you on their team! In this chapter, you’ll continue to apply your Power BI skills to extract data insights with tools like DAX and begin to build unique data visualizations.

Market insight analysis

Key insights to focus

Cleanup and skill analysis

Likelihood of skills in job posting

Trends in skills over time

Deep dive into key job descriptions

Other job recommendations

Trends from analysis

Analyzing Market Trends

It’s almost time to hand over the final deliverable. In this final chapter, you’ll combine all of the job listing insights you’ve discovered into an interactive Power BI dashboard for the DataSearch team.

Building job market analysis dashboard

How to design a dashboard

Begin dashboard templates

Designing a dashboard layout

Exploring top skills for jobs

Salary gauge for companies

Adding interactivity with bookmarks

Case study wrap-up

Dashboard Build

Metadata sheet

DataCamp vs. Local Experience

Exercises and Datasets

In this Power BI case study, you’ll explore a real-world job posting dataset to uncover insights for a fictional recruitment company called DataSearch. Using what you’ve learned from previous courses, you’ll use Power Query to investigate and clean the data to find out what skills are most in-demand for data scientists, data analysts, and data engineers. You’ll then use DAX to build insightful visualizations of your findings. Finally, you’ll bring it all together using everything Power BI has to offer to create a business dashboard so that you can answer questions for the DataSearch team.

<h2>Apply Your Skills with a Power BI Case Study</h2>
In this Power BI case study, you’ll explore a real-world job posting dataset to uncover insights for a fictional recruitment company, DataSearch. 
<br><br>
<h2>Use Power Query to Investigate and Clean Data</h2>
Using what you’ve learned from previous courses, you’ll use Power Query to investigate and clean the data to find out what skills are most in-demand for data scientists, data analysts, and data engineers. 
<br><br>
<h2>Utilize DAX to Build Insightful Visualisazations</h2>
You’ll then use DAX to build insightful visualizations of your findings. Finally, you’ll bring it all together using everything Power BI has to offer to create a business dashboard so that you can answer questions for the DataSearch team.


Data Visualization in Power BI

Introduction to DAX in Power BI

Help a fictional company in this interactive Power BI case study. You’ll use Power Query, DAX, and dashboards to identify the most in-demand data jobs!

Case Study: Analyzing Job Market Data in Power BI

Job postings over the past 5 years are trending upward.

As years of experience increase for a job, so does the associated salary.

There are many empty values for salary information.

There is no correlation between job position level (i.e., Entry level, Director, Internship) and years of experience for a job.

Data Science Manager is the most popular and in demand role in data science.

Trends found with EDA

Case Study: Analyzing Job Market Data in Power BI

Hands-on interactive exercise