Skip to main content
HomePower BICase Study: Analyzing Job Market Data in Power BI

Case Study: Analyzing Job Market Data in Power BI

4.4+
17 reviews
Beginner

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!

Start Course for Free
3 Hours4 Videos24 Exercises
11,648 LearnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTraining 2 or more people?Try DataCamp For Business

Loved by learners at thousands of companies

Course Description

Apply Your Skills with a Power BI Case Study

In this Power BI case study, you’ll explore a real-world job posting dataset to uncover insights for a fictional recruitment company, DataSearch.

Use Power Query to Investigate and Clean Data

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.

Utilize DAX to Build Insightful Visualisazations

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.
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Exploratory Analysis

    Free

    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.

    Play Chapter Now
    Job market analysis with Power BI
    50 xp
    EDA questions to ask
    100 xp
    Data import with Power Query
    100 xp
    Initial EDA with Power Query
    100 xp
    Job posting trend analysis
    100 xp
    Data cleanup of job titles
    100 xp
    Effect of years experience on salary
    100 xp
    Trends found with EDA
    100 xp
  2. 2

    Analyzing Market Trends

    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.

    Play Chapter Now
    Market insight analysis
    50 xp
    Key insights to focus
    100 xp
    Cleanup and skill analysis
    100 xp
    Likelihood of skills in job posting
    100 xp
    Trends in skills over time
    100 xp
    Deep dive into key job descriptions
    100 xp
    Other job recommendations
    100 xp
    Trends from analysis
    100 xp
  3. 3

    Dashboard Build

    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.

    Play Chapter Now
    Building job market analysis dashboard
    50 xp
    How to design a dashboard
    50 xp
    Begin dashboard templates
    100 xp
    Designing a dashboard layout
    100 xp
    Exploring top skills for jobs
    100 xp
    Salary gauge for companies
    100 xp
    Adding interactivity with bookmarks
    100 xp
    Case study wrap-up
    50 xp

Datasets

Metadata sheetDataCamp vs. Local ExperienceExercises and Datasets

Collaborators

Collaborator's avatar
Maarten Van den Broeck
Collaborator's avatar
Carl Rosseel

Prerequisites

Data Visualization in Power BIIntroduction to DAX in Power BI
Luke Barousse HeadshotLuke Barousse

Data Analyst and YouTuber

Luke has been working as a data analyst for the past number of years and has a passion for sharing learnings in data science; hence why he created a YouTube channel. Prior to his life as a data analyst, he obtained his degree in mechanical engineering and then served in the United States Navy’s submarine force for 7 years. Following his naval service, he obtained his MBA specializing in business analytics and then transitioned to become a data analyst.
See More

Don’t just take our word for it

*4.4
from 17 reviews
59%
24%
18%
0%
0%
Sort by
  • Luis C.
    about 1 year

    Awesome case

  • Enyinna A.
    about 1 year

    N/A

  • Timiebiotubo P.
    about 1 year

    I really fine this case study practical and informative. It really got me thinking about the necessary skills needed, that I don't yet have,in the Data Job Market. It was and still is, really beneficial to my learning and growth as a Upcoming Data Analyst.

  • Erik M.
    about 1 year

    This was a great way to get your hands wet with some power bi. There was plenty of guidance, but the expectations were scaled in a way that used a lot of the previous trainings. There were still somethings I had to google, or take the hint on, but it was all positive. Highly recommend if you are in the Datacamp environment and are looking for some real world experience building something out.

  • Miroslav R.
    about 1 year

    Very good practical exercise which also "forces" you to find solutions on your own.

"Awesome case"

Luis C.

"N/A"

Enyinna A.

"I really fine this case study practical and informative. It really got me thinking about the necessary skills needed, that I don't yet have,in the Data Job Market. It was and still is, really beneficial to my learning and growth as a Upcoming Data Analyst."

Timiebiotubo P.

Join over 13 million learners and start Case Study: Analyzing Job Market Data in Power BI today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.