Skip to main content

Case Study: Analyzing Job Market Data 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!

Start Course for Free
3 Hours4 Videos24 Exercises2150 XPData Analyst TrackPower BI Fundamentals Track

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. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).

Loved by learners at thousands of companies


Course Description

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.

  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
  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

In the following tracks

Data AnalystPower BI Fundamentals

Collaborators

maartenvdbroeckMaarten Van den Broeckcarlrosseel-73112126-9ed2-4866-942a-96fbf265b088Carl Rosseel
Luke Barousse Headshot

Luke 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

What do other learners have to say?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA