Prepare HR Workforce Dataset for Analysis

Business Scenario

Welcome!

 

This project focuses on preparing and transforming the HR Workforce dataset to build an end-to-end interactive Power BI dashboard that delivers actionable workforce insights.

Pre-Lab Preparation

Topic : Modelling Data in Power BI

1) Import HR dataset

2) Clean missing values

3) Merge HR datasets

4) Append multiple datasets  

Task 1: Import HR Dataset

The project includes comprehensive data preparation, modeling, and advanced DAX measure development to support strategic HR decision-making.

 

We have already imported in PB5 lab 

git pull origin branchName

Git Pull

Task 2: Clean Missing Values

1

Open Power query editor

Home tab—> transform data–→ transform data

2

View tab—>Column preview —> Check all checkboxes, Analyse which column need cleaning an transformation

 

Great job!

You have successfully completed building data relation for analytical model lab

Checkpoint

Next-Lab Preparation

   Git Push

git push origin branchName

Topic : Mastering DAX for Data Analysis

1) Introduction to DAX

2) Difference Between M Query and DAX Query

3) DAX Data Types ,DAX Operators

4) DAX Measures and Calculations ,

5) Aggregation functions

6) Text Functions

7) Date and Time Function, Time Intelligence

8)Filter Function (ROW Context and Filter Context)

9) Most Versatile DAX Function:-CALCULATE DAX

10) IF and Switch in DAX