Certification Project
© B r a i n 4 c e E d u c a t i o n S o l u t i o n s P v t . L t d
Scenario : The HR (Human Resource) department is the heart of every organization. From recruitment to compensation to performance appraisal and employee wellbeing, the HR department plays several roles in the enterprise. HR acts as a mediator or a bridge between the employees and the management or enterprise. It’s no surprise that the HR department is already burdened with work. Providing them access to the latest technology and the means to derive insights in real time will help reduce the workload and create a healthy environment throughout the organization.
Problem Statement :
Market fluctuations and rapidly changing technology have affected the global market. Many published reports showed that around half of the employees wanted to change jobs. While some market researchers said that flexible working and job security were their primary factors, few admitted that a higher salary was their aim. Different regions saw an increase and a decrease in salaries over the years. While the increase was to retain top-level professional employees, the pay cuts were due to market fluctuations and were resorted after the market conditions improved. HR people across the globe are hiring new employees, trying to retain and understand the needs of employees who got separated (those who left the company). So, how does the HR department make these decisions in volatile market conditions? They rely on HR analytics to understand the existing situation and develop a new modern approach. For this requirement, you have been asked in your company to build a dashboard in Power BI considering the following challenges of HR people and provide an effective way to find the answers to their day-to-day questions.
Tasks :
1. Use the HR data set provided for this project and analyze that to understand the data and terms.
2. Load data into the Power BI Query Editor and perform the required actions.
3. Establish the required relationships