HR Analytics in Power BI

Case Study: HR Analytics in Power BI

Jess Ahmet

Content Developer at DataCamp

What is a case study?

  • Apply Power BI skills
  • Combine previously learned concepts
  • Solve an example real-world problem

$$

Prerequisite courses:

  • Intermediate DAX in Power BI
  • Data Modelling in Power BI
  • Data Visualization in Power BI

Report

Case Study: HR Analytics in Power BI

Report development in Power BI

Report development process

1 Note: This process applies specifically to developing a report, not to analyzing a dataset.
Case Study: HR Analytics in Power BI

Report development in Power BI

Report development process - first two steps

Case Study: HR Analytics in Power BI

Report development in Power BI

Step 1 in the Report development process

Case Study: HR Analytics in Power BI

Report development in Power BI

Step 2 Report development in Power BI

Case Study: HR Analytics in Power BI

Case study goals

  • Primary goal: Monitor key HR metrics on employees
  • Secondary goal: Understand what factors impact attrition

Analytics

Case Study: HR Analytics in Power BI

The dataset: Fact table

Column name Description
PerformanceID A unique id that identifies a performance review
EmployeeID A unique ID that identifies an employee. Connects to Employee table.
ReviewDate Date an employees' review took place.
EnvironmentSatisfaction Rating for employees' satisfaction with their environment. Connects to Satisfied Level table.
... ...
Case Study: HR Analytics in Power BI

The dataset: Dimension tables

  • Employee
  • EducationLevel
  • RatingLevel
  • SatisfiedLevel
  • Date
Case Study: HR Analytics in Power BI

The dataset: Snowflake schema

Snowflake Schema

Case Study: HR Analytics in Power BI

Let's practice!

Case Study: HR Analytics in Power BI

Preparing Video For Download...