HR DATA ANALYSIS

-

 



Project Questions:

This role is a HR data analyst to develop a HR Dashboard for your organization. The organization has purchased Inforiver as its primary custom visuals to standardize and simplify the reporting. It is an opportunity for you to show your creativity about our investment. Required to answer a few, not all, the questions below, they are prepared to help you to focus on an aspect of your analysis.

  1. Can you find the age segments about the employees?

  2. What is the gender ratio each hire year?

  3. What is the martial status distributed each hire year? Did number of single new hires increase or decrease historically?

  4. What branch had the most/fewest new hires each year?

  5. How about the employee retention rate each year? What is the main leave reason? 6. Which department had the most/fewest new hires each year?

  6. Which department had the highest/lowest retention rate each year?

  7. Which department had the highest/lowest average satisfaction score each year?

  8. Can you provide the yearly average salary the organization paid to each department?

10.Which department had been paid most/fewest bonus each year?

11.Which job title had the highest/lowest satisfaction score?

  1. Which job title had been paid the highest/ lowest salary each year?

  2. How much money have we invested to management position each year?

  3. Can you show us any correlation between employee performance and material status?

15.Whether you have a better performance to make more money?

Tools Used:

Power BI

Project Insights:

I have categorized the dashboard in four sections and my insights are below:

  1. Employee Demographics analysis such as age group, number of male and female employees growth, and number of employees by department and branch.
  2. Employee salary and satisfaction analysis: What is average salary by department. which job roles are getting higher and lesser salary than others and which job roles has highest and lowest satisfaction towards their work.
  3. Hire and Retention analysis by the company: how is the hiring growth by martial status and department. what is the key reason of retention over years and which department impacted the most.
  4. Performance analysis of employees by department and martial status and investment analysis by the company for the management positions over the last 5-6 years.

Comments

Post a Comment

Popular posts from this blog

How to create a Word Cloud in R

-
Image
I have seen Word-cloud in so many places such as magazines, websites, blogs, etc. however never thought of making it by myself. I would like to thank R that taught me such a wonderful technique which everybody would like to learn. I don’t know if there are any other free options are available to create word-cloud. Let me give a quick explanation about R first, R is a free source packages and very useful for statistical analysis. We can use R for various purposes, from data mining to data visualization. Word-cloud is a tool where you can highlight the words which have been used the most in quick visualization. If you know the correct procedure and usage, then Word Cloud is simple in R Studio. Further, a package called “Word-cloud” is released in R, which will help us to create word-cloud. You can follow my simple four steps mentioned below to create word-cloud. Those are new to R or Word Cloud, I would suggest first install R studio from the link rstudio.com Also, the following...
Read more

Free Cash Flow to the Firm (FCFF) v/s Free Cash Flow to Equity(FCFE)

-
Shows both the Free Cash Flow to Firm (FCFF) and Equity components of the valuation of an enterprise. Free Cash Flow to the Firm v/s Free Cash Flow to Equity Inputs Earnings before interest and taxes (EBIT) = 100 E xpected growth for next 5 years = 20% Expected growth after year 5 = 5% Tax rate = 40% Debt ratio for the firm = 20% Cost of equity = 15% Pre-tax cost of debt = 9% Return on capital in high growth= 15% Return on capital in stable growth = 10% 0 1 2 3 4 5 Terminal Year Expected Growth rate 10% 10% 10% 10% 10% 5% Reinvestment rate 66.67% 66.67% 66.67% 66.67% 66.67% 50.00% EBIT(Earnings before interest & tax) ...
Read more

A Key Challenge for Apple's Quest for Carbon Neutrality

-
Image
  The Goal of the project: To visualize Apple progress towards becoming carbon neutral in 2030. In 2020, after announcing their corporate operations were officially carbon neutral, Apple pledged to make their products carbon neutral by 2030. To achieve this goal, they set their emissions for 2015 (38.4 million metric tons CO2e) as the baseline and will aim to reduce them by 75% by 2030. The remaining 25% of gross emissions (9.6 million metric tons CO2e) will be removed using carbon offsets, bringing the net emissions to 0. To find out the how much carbon emission is already reduced by Apple in 2022 and how it going to reduce the remaining by 2030. Key Insights: Based on the data and analysis, i have found these below points: Apple has reduced its carbon emission in corporates operations by 2020 The top three highest emission segments are manufacturing, transportations and product use How Apple will reduce the remaining emission by 2030? Apple already implementation many transformat...
Read more

Why Patients Rating (HCAHPS) Declined During COVID-19?

-
Image
  Project Description: The HCAHPS survey is the first national, standardized, publicly reported survey of patients' perspectives of hospital care. HCAHPS (pronounced "H-caps"), also known as the CAHPS Hospital Survey, is a survey instrument and data collection methodology for measuring patients' perceptions of their hospital experience. HCAHPS was designed to help government agencies begin to collect and aggregate data on patient’s perspectives of care at the various healthcare facilities in the United States. HCAHPS scores are used to enable objective comparisons of hospitals across a variety of metrics, inform healthcare consumers about the relative standard of care at each facility and create incentives for hospitals and healthcare organizations to compete on patient engagement and satisfaction. This is the September challenge organized by Maven Analytics. You can find the dataset here . The challenge data consists of 7 files: Measurers National result Questions ...
Read more

Great thought by Mrunal Nandankar

-
Success is not measured by how much a man has, But how much he has done, How far he has gone. Success is the basic human knowledge, Of how well a man has done. It is not taken lightly, Or as it shouldn't be. This is a serious task. One given to man by fate. Only you can determine your success. Only people can comment it. Push your self to the limit, Gas far as you can, Strive for it, For it is important, Your success. One of the most important traits of human kind, Taken for granted by the rich, And serious by the poor. We all have it in us, What it takes to be a success. We just have to reach in deep enough, And we will soon find the success in us, That has been lying there all a long. Success is key to all of life's compances, Enjoy it while it lasts. By Mrunal Nandankar...............
Read more

Global GDP Flow slowed down in 2022

-
Image
  I have only worked on Power BI but to use this voronoi treemap, I have chosen Tableau. I have mentioned the link below, if anybody would like to work on this. Please share your feedback, if you like it. :-) Veronoi treemap link: https://lnkd.in/gVqFuZ8M Thanks for reading.
Read more

Vince Lombardi

-
It's easy to have faith in yourself when you're a winner, when you're number one. What you've got to have is faith in yourself when you're not a winner. - Vince Lombardi
Read more

The Global Space Exploration Roadmap

-
Image
All space missions from 1957 to August 2022, including details on the location, date, and result of the launch, the company responsible, and the name, price, and status of the rocket used for the mission. Recommended Analysis How have rocket launches trended across time? Has mission success rate increased? Which countries have had the most successful space missions? Has it always been that way? Which rocket has been used for the most space missions? Is it still active? Are there any patterns you can notice with the launch locations?  Tool: Power BI
Read more

Pizza Place Sales Analysis

-
Image
  A year's worth of sales from a fictitious pizza place, including the date and time of each order and the pizzas served, with additional details on the type, size, quantity, price, and ingredients. Recommended Analysis How many customers do we have each day? Are there any peak hours? How many pizzas are typically in an order? Do we have any bestsellers? How much money did we make this year? Can we indentify any seasonality in the sales? Are there any pizzas we should take of the menu, or any promotions we could leverage? Tool: Power BI
Read more