Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
07-25-2023 06:52 AM
Hi,
A Dashboard for FP20 Analytics Challenge 4 - HR data Analysis
THE BRIEF -
*IMPORTANT* 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.
Key Insights-
1. The company has total 694 employees, with males employees 382 (55%) and females 312 (45%).
2. Those within the 60 to above year age group make up the greater percentage of the employees (33%) and lowest 50 to 60-year age group (19.9%) employees.
3. Most of the employees were hired in 2014,139 employees (20%) and least percentage (12.7%) of employees were hired in 2018,
134 employees were hired in 2017.
4. Of the 694 employees, 85.3% (592) were still working with the company (active), while 14.7% (102) are those who either resigned or had their employment terminated by HR.
5. Employees who left mentioned performance issues (36) as their main reason for leaving the company, followed by a higher salary expectation (25).
6. Employees in the Administration & Z Management departments showed the most satisfaction (score: 5) in 2017, while employees in the Administration department were the least satisfied (score: 2) in 2015. Also, employee satisfaction is mostly related to performance. Only 3 people gave low satisfaction score who have been given PIP.
7.Production Technicians have higher salary per year.
8.The Company had retention rate of 85.3% and attrition rate
14.7%.in Matrix chart we can analyze.
Your feedback would be much appreciated!
Thanks,
eyJrIjoiOWI0YTYxMGItNjFmMS00NjVhLTk1MjMtYzMzODkxZGExZmZkIiwidCI6ImQ4ZTFiMDVlLTcwYWEtNGVmNy1iODc4LTQ2NmI2ODhmOTUyZiJ9
Excellent. Can you share Jaisprk@gmail.com
Good job, Could you please share to bobo.solo94@gmail.com
Can share power bi template to samchen2549@gmail.com
Thanks
This is terrific work! Could I please have a copy of the pbix file? mhavnen@ucmo.edu
Hola. Excelente trabajo
Puedes compartirme el archivo pbix a ing.lfhernandez@gmail.com
exceptional!!! can you share the pbix file? please and thankyou; ornelasg@gmail.com
Bonjour pouvez-vous m'envoyer ce fichier pbix. merci d'avance
khadyndour9757@hotmail.com
Ola, voce poderia compartilhar o arquivo em pbix? email: bella.brand@hotmail.com
Can you please sent me this pbix file. thank you in advance
Great work! could you please send to me the pbix to hammohdahmed@gmail.com thank you in advance.
This is brilliant! Could you share the power bi template to djpatel19762017@gmail.com
可以将这个共享给我吗?569125316@qq.com