Skip to main content
Giuseppe Legrottaglie avatar

Giuseppe Legrottaglie has completed

Case Study: Analyzing Job Market Data in Power BI

Start course For Free
3 hours
2,150 XP
Statement of Accomplishment Badge

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

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

Datasets

Metadata sheetDataCamp vs. Local ExperienceExercises and Datasets

Collaborators

Collaborator's avatar
Maarten Van den Broeck
Collaborator's avatar
Carl Rosseel
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

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.