A human resource manager is tasked with managing a very great asset in the organization; The employees. This analysis has been made to gain insights from the Hr dataset. Please keep on reading to know more.

Loading and cleaning of the dataset

The dataset came in as an Excel file with a total of thirty-seven (37) rows and one-thousand, four-hundred and seventy-one (1471) columns, and fifteen (15) sheets.

The main data for the analysis is in the Employees' spreadsheet, the fourteen (14) other spreadsheets in the workbook were used in the transformation of the dataset.

Transformation

Opened the data in Power Bi power query editor, and changed the data type for the necessary columns

I began to transform the data after loading it Power Query editor

Writing DAX

Visuales of the data

The home visual, that summarizes the data

The second page with further details on the data

The last page of the visualizations

Thank you for taking the time to read this article please do let me know if you have any questions or observations.