Guided Project : HR Analytics with Power BIin Data Analytics with Microsoft Power BI
What you will learn?
Understand the basics of Power BI and its role in HR dashboard design.
Create data models using DAX formulas.
Develop and format visualizations to convey HR data effectively.
Build dynamic HR dashboards that allow for real-time data analysis.
Apply advanced DAX functions to analyze HR data.
Customize visualizations to meet specific HR needs and goals.
Design and share HR reports and dashboards with stakeholders using best practices for data analysis, visualization, and interpretation in HR contexts.
About this course
Microsoft Power BI gives you a wide range of methods to analyze your data and generate insights to support business decisions.
Who should take this course
Learners must have basic understanding of Power BI and DAX
Download the resources zip file and unzip it on your PC. The folder contains the dataset, the report template, the icon, and the completed Power BI file.
Business requirement of this guided project
Q1 - Calculate the number of males and female employees in the firm using DAX.
Calculate the percentage of staff who are males and females
Calculate the number of staff promoted in 2020 and 2021.
Calculate the percentage of staff promoted in 2020 vs 2021
Calculate the percentage of men and women promoted in 2020 vs 2021.
Calculate the managers who were promoted to senior managers in 2021
Calculate the number of Directors promoted in 2021.
Determine the Directors who resigned in 2020.
Calculate the number of males and females who resigned in 2020.
Calculate the staff turnover rate in 2020
Assess the impact of new proposed salary increase by management.
Introduction to the second business requirement
View the sample dashboard we are going to develop together.
The report theme file is part of the downloaded files.